connection time out - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

connection time out

Author

Topic

khalik
Constraint Violating Yak Guru

443 Posts

Posted - 2002-01-09 : 03:01:35

hi

i am working on sql 200 and vb i have a huge base of 3 million record on which i do some process.... i have written the sql statment in storeed procedure and when i execute them vb ADO return connection time out is there any way i can do it...

if i run the same statment in query analyzer it takes long time but completes

i tried out
Connection.CommandTimeout=0
and
Connection.CommandTimeout=500
what is the max value.....
but the same problem
thanks in advance

khalik

nrafiq
Starting Member

9 Posts

Posted - 2002-01-09 : 04:32:30

Hi,

I think your syntax like this "Connection.ConnectionTimeout=0".

If you set the property to zero, ADO will wait indefinitely until the connection is opened. Make sure the provider to which you are writing code supports the ConnectionTimeout functionality.

What is your SQL-Server query timeout value? If its > 0 then, Change its to 0(zero).

Try to like this.

Rafi

pradeepbj
Starting Member

6 Posts

Posted - 2002-01-09 : 04:57:56

quote:

Hi,

I think your syntax like this "Connection.ConnectionTimeout=0".

If you set the property to zero, ADO will wait indefinitely until the connection is opened. Make sure the provider to which you are writing code supports the ConnectionTimeout functionality.

What is your SQL-Server query timeout value? If its > 0 then, Change its to 0(zero).

Try to like this.

Rafi

Hi,
You will have to tune your SQL Query in your procedure, maybe create an index on the columns which you are querying. I had a similar problem of connection timeout which was solved by creating an index on the where clause columns.

pradeep

izaltsman
A custom title

1139 Posts

Posted - 2002-01-09 : 09:21:44

Also, in addition to setting CommandTimeout, you might want to set Server.ScriptTimeout as well.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources