Data enviroment to SQL 2000

[HebieBug]

We are now upgrading to SQL 2000 after recent problems with our current Access 2000 databases.
For further references it seems that Access has a maximum of 5 connections avaliable to VB forms. After the 5th error messages will appear showing the database as locked and dropping every user from the database.
Have a trial version from the microsoft site to run some system checks on it.
The data enviroment does not seem to want to connect with the SQL database "connection failed %1"
Have connected using IP address followed by SQL server ect..
Have then tried connecting through ODBC wich seems to be the wrong version as 2000...... is needed.
Does anyone know:
1) How to upgrade the OBDC
2) How to upgrade the data enviroment to the correct provider

Have upgraded to service pack 5 already but it does not seem to fix problem

 

[chiph]

With SQL 2000 you need to make sure you've got the correct client drivers. First step is to install ADO 2.5 on your application server/pc by running the correct MDAC_TYP.EXE (downloaded from microsoft.com/data). Then using the SQL 2000 CD, install the client data access drivers from it.

Chip H.

 

[HebieBug]

downloaded mdac_typ.exe and installed. The following is the log that I sent to the SQL forum
Have installed SQL 2000 on 2000 server box.
server name: phantom
SQL server: FOXGUISQL
IP address of box: 192.168.0.12
Active diectory active
Have set SQL logon to mixed
Install worked fine. Created ODBC on server no problem.
On workstation installed recient MDAC and brought ODBC up to SQL version 2000
Attemped to setup ODBC system DSN have tried all combinations from server name followed by SQL server name to IP address followed by SQL server name.
Something intersting that I found was that when I tried setting it up if I clicked finish insteed of continue the screen that is brought up shows the previous version of ODBC drivers.. Is this something to worry about?
Does anyone out there in thread land know of some tests that I can preform or a solution?

 

[HebieBug]

Problem fixed...
SQL trail version was not uninstalling corectly..
When licensed version was installed ittook onfig of trial version
Had to rebuild server..