VB6 ADO SQL2005 problem


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.


*** Sent via Developersdex http://www.developersdex.com ***
.

Relevant Pages

  • Re: VB6 ADO SQL2005 problem
    ... I use ADO to update data in SQL2005 db from vb application. ... It updates about 400 records with Execute method from Connection object ... Have you tried doing those same updates via the SQL2005 ...
    (microsoft.public.vb.database.ado)
  • Re: ping DelM: coInitialize
    ... that if an ADO connection object exists, ... never had to actively call coinit or couninit in any of my ISAPI programs. ...
    (borland.public.delphi.database.ado)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.data.ado)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.inetserver.asp.db)
  • Re: ODBC/OLE DB Connection Pool
    ... > connection be kept open for the application as this will serialize all ... threads ONCE they are returned to the pool. ... > Tips for ADO Users ... > The ADO Connection object implicitly uses IDataInitialize. ...
    (microsoft.public.data.oledb)