SQL Server... HELPPPPPPPPPPPPPPP

[Long]

Dear All,

I would like to ask you about my VB application Error, related with SQL Server Database.

I've create a module to drop and then create view. And then, when I run my module, suddenly happened to my application. An error occured....

The error said :

Run-Time error '-2147217871 (80040e31)':
[Microsoft][ODBC SQL Server Driver]TimeOut expired


Could you guys explain how to fix it and why ??? Coz, I can't run my module at all....

Thx in reply, nd I need it ASAP

Regards,
Long

[ExcalibursZone]

Is your SQL server running? Do you have the correct server name? Are you in the same domain as your server?

[Long]

Well... for your information...
my SQL Server always run 24 hours a day (non-stop)...
and
I've put the correct Server Name...
and
I'm in the same domain with my SQL Server Database...

so ???

Regards,
Long

[*Vince]

Hi,

do you LOCK some table that you never close the connection to ?

If you are doing very long queries, there is a property when you connect to your DATABASE to set the timeout time and I think it's 30 seconds for default...try changing it ???
If you are using ODBC there is another time out there in the ODBC configuration...try changing it too ???????

Do you use Begin transactions ?

If so, be sure there are no transactions openned but never rolled or committed...

hope I helped !