I want to take a learning vb enters sells saves the software, the result when the database sqlserver2000, win sqlserver2000 failed, to find out a xp computer, after successful installation sqlserver2000 database, found unable to connect, vb components could not add components ado, the sqlserver2000 database data export to access files, on win10 debugging, but always vb to connect the access database is not successful, please have a strength of the great god help solve,

Source url: https://pan.baidu.com/s/1qgLovAItKwFB4wMoS06Hzg extraction code: FSTH

CodePudding user response:

You need to put you say detailed point of the machine environment parameters, your odbc version, etc.,

CodePudding user response:

Win10 system, I now use computer access2010, had been in xp jacket office2003, on xp by sqlserver2000 export data access, roll out the access2003 version of the database, @ ruan1978

CodePudding user response:

SQL Server 2000 database MedicineJXC. MDF, MedicineJXC_Log LDF can be converted to SQL Server 2008 R2 database, in VB60 W7 system operation is very easy, W 10 system with poor seems to support VB60 many functions, it is recommended to use W 7 system, using VB60 SQL Server 2008 R2 database operation, will MedicineJXC. MDF, MedicineJXC_Log. LDF database file is attached to the user database, very simple,

CodePudding user response:

win10 system, I now use computer access2010, had been in xp jacket office2003, on the xp by sqlserver2000 export data access, roll out the access2003 version of the database, @ ruan1978

Nyjxc. MDB Access database. Save as nyjxc accdb Access 2010 version of the database, the connection code from the original 2003 Access database connection
The Provider=Microsoft. Jet. The OLEDB. 4.0; Data Source="& amp; App. The Path & amp; "\ DATA \ nyjxc. MDB; Persist Security Info=False
Modified to connect Access database 2010
The Provider=Microsoft. ACE. The OLEDB. 12.0; Data Source="& amp; App. The Path & amp; "" \ DATA \ nyjxc accdb; The Jet OLEDB: Database Password=;

No W 10 system, no test, but there is no question of W 7, 7 W system is 2003 does not exist in the database connection,

CodePudding user response:

@ ZHRXJR my links to database access string is similar to what you said above, but in the process of running too many questions, can't operate,

CodePudding user response:

Install MSDE and SQL Server 2000 client tools, effect of equivalent SQL Server2000, XP, Windows 7 support, on Win10 didn't try

CodePudding user response:

You look is not the connection string, but the problem of SQL command

reference 5 floor later we reply: 888

@ ZHRXJR my links to database access string is similar to what you said above, can't operation, but in the process of running too many questions