VB6 ADO SQL2005 problem

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vadim Vulfov - 11 Mar 2008 16:47 GMT

I use ADO to update data in SQL2005 db from vb application.
It updates about 400 records with Execute method from Connection object
and then give an error message "SQL Server doew not exist or access
denied". How this can be fixed? Should I increase ConnectionTimeOut or
something else? Please help.

Reply to this Message

Jan Hyde (VB MVP) - 17 Mar 2008 10:53 GMT

Vadim Vulfov <vadim_odessa@yahoo.com>'s wild thoughts were
released on Tue, 11 Mar 2008 08:47:01 -0700 bearing the
following fruit:

>I use ADO to update data in SQL2005 db from vb application.
>It updates about 400 records with Execute method from Connection object
>and then give an error message "SQL Server doew not exist or access
>denied". How this can be fixed? Should I increase ConnectionTimeOut or
>something else? Please help.

Have you tried doing those same updates via the SQL2005
tools?

--
Jan Hyde

https://mvp.support.microsoft.com/profile/Jan.Hyde

Reply to this Message

VB Forum / Database Access / March 2008

VB6 ADO SQL2005 problem