Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sandesh_moghe
Constraint Violating Yak Guru
310 Posts |
 Posted - 2003-01-27 : 06:55:44
|
| Hi,I have one application in VB & SQL Server useing RDO.The problem is when i restart the database server, it shows MSSQLServer icon as running, means it starts the service. But the application couldnt connect to the database.The funniest part is that if i open database thru EM/QA, first time it takes lot of time to open. After opening the database, then it connects to the application.please tell me, why this is happening and what is the solution for that.Thanx in Advance.---------------------------Sandesh - The Messanger |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2003-01-27 : 08:13:09
|
| Why are you using RDO??? |
 |
|
|
gvphubli
Yak Posting Veteran
54 Posts |
Posted - 2003-01-28 : 00:22:37
|
| In your VB application the RDO CommandTimeOut and ConnectionTimeOut properties have to be changed, may be its set to 20 seconds or so, set it to more ..may be around 200 seconds.Let me know after making these changes.- = Cracky DBA = - |
|
|
|
sujay
Starting Member
2 Posts |
Posted - 2003-01-28 : 00:37:58
|
quote:
what is the problem in using RDO??? i have used RDO in 8 projects and it works fine
|
|
|
|
sujay
Starting Member
2 Posts |
Posted - 2003-01-28 : 00:48:56
|
quote:
In your VB application check for querytimeout property of the connection.The default is 30 seconds.If RDO is used and the querytimeout property is not set it takes default for all queries it runs..if it is querytimeout = 0 the query will run indefenitely.i think thats is what has happened in your vb application.check it out and let me know.
|
|
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2003-01-28 : 04:22:51
|
quote:
what is the problem in using RDO??? i have used RDO in 8 projects and it works fine
It's nothing wrong with it, it's just old and obsolete.You should pick up a book on MSSQL & VB communication. |
|
|
|
|
|
|
Connectivity Problem