Re: VB6 ADO SQL2005 problem

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Jan Hyde (VB MVP)" <StellaDrinker@xxxxxxxxxxxxxxxxxxx>
Date: Mon, 17 Mar 2008 09:53:30 +0000

Vadim Vulfov <vadim_odessa@xxxxxxxxx>'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
.

References:
- VB6 ADO SQL2005 problem
  - From: Vadim Vulfov

Prev by Date: Re: VB6 & SQL2000 Stored Proc problem
Next by Date: Standardspeicherort der Daten
Previous by thread: VB6 ADO SQL2005 problem
Next by thread: Help with an SQL statement?
Index(es):
- Date
- Thread

Relevant Pages

Re: Exchange 2003 ADO SELECT performance
... You will want to open an ADO connection object and pass it to your Rec.Open ... > I have written a application that, among other things, updates ... Dim RS As New ADODB.Recordset ...
(microsoft.public.exchange.development)
Re: Close ports that stay open during loop of updates to db
... > I make "create object" to this dll from an simple exe. ... > When i do the updates in loop,the ... > Why the ports do not close after I set the object to nothing? ... Setting a connection object to Nothing does not close it, ...
(microsoft.public.vb.database.ado)
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 ...
(microsoft.public.vb.database.ado)
Datagrid updation
... update data of DataGrid in Asp.Net with VB.Net.and are ... If we write a fixed value in code to change it in datagrid then it updates ... DataSet1.Tables.Rows=HdDH This command updates ...
(microsoft.public.dotnet.framework.aspnet)
Re: Set Warnings on/off in VBA
... Take a look at the RecordsAffected property in DAO help. ... Execute method to run your updates, this property will tell you how many ... before you run your updates you could run those queries as ... > FinalAns tblNo1 5 ...
(microsoft.public.access.formscoding)