Dim as SQL string
Dim RST As New ADODB. You
RST. CursorLocation=adUseClient
RST. LockType=adLockOptimistic
The Debug. Print SQL
The Debug. Print pAdoCN
RST, the Open SQL, pAdoCN, adOpenKeyset
The Set OpenRecordset=RST
The do while RST. Eof...
Loop
"' program execution here
RST, the Open SQL, pAdoCN, adOpenKeyset
So the following error:
"' real-time error - 2147467259 (80004005). '
' ' '[Microsoft] [ODBC SQL Server Driver] communication link failure
After the test if you don't set the ado CursorLocation and LockType properties, can be normal access to the data, but cannot update

In the just connect to the database query analyzer, will appear the following error:
Server: 11 news, level 16, state 1, line 0
[Microsoft] [ODBC SQL Server Driver] [DBNETLIB] general network error, please check the web documents,
ODBC: 0, level 16, state 1
[Microsoft] [ODBC SQL Server Driver] communication link failure
ODBC: 0, level 16, state 1
[Microsoft] [ODBC SQL Server Driver] communication link failure

Premise condition is:
Running under win7X64 MSDE2000 version of the independent model, MSDE run normally, is not normal visit client, the same structure under XP normal!
Baidu N many web pages, is the same:
Is said that the old Ado15 program, recompile, under Windows 7 can't normal running under Windows XP,
But on the contrary, I in this
Recently found under some XP, occasionally also appeared dead tired, SQL query analyzer connection also appear the same mistake!
Please discuss, now still should have the same problems in the old database application!

CodePudding user response:

Win7X64 MSDE2000 version should be run under the 64 - bit,
And application is using a 32-bit drivers,
Use 64 - bit database access 32-bit drivers, this...

Really want to use a Virtual PC is installed,

CodePudding user response:

I now is to release a version under XP, best can also compatible with Windows XP and Windows 7

See if there are any solution

Or just have to put the software upgrade to a new platform

Imagine a huge sql2008 is a bit scary

CodePudding user response:

In a 64 - bit Windows:
64 exe and DLL in the directory c: \ Windows \ sys tem32 directory.
32 bit exe and DLL in the directory c: \ Windows \ sys wow64 directory.

Please run the
C: \ Windows \ syswow64 \ cliconfg exe configured 32-bit database alias
C: \ Windows \ syswow64 \ odbcad32 exe configuration 32-bit system DSN

CodePudding user response:

Method is relatively simple, direct reference version higher ADO, such as version 2.8, general Windows 7 can be found in the directory, C: \ Program Files \ (x86) Common Files \ System \ ADO
If not properly connected, register the DLL in the directory or OCX,