Very Computer

  ' Create Ado objections for DB Communication
  Set sAdoDBCon = New ADODB.Connection
  Set sAdoDBRec = New ADODB.Recordset

  ' SQL Select statement
  strSQL = "SELECT * FROM master"

  ' Error handling
  On Error GoTo Error_cmdRead_Click

  ' Connect to the Database via ODBC
  sAdoDBCon.ConnectionString = "DSN=CAMDB"

  ' **************************************************
  ' *** Fails on this Open statement
  ' **************************************************
  sAdoDBCon.Open
  sAdoDBRec.Open strSQL, sAdoDBCon, adOpenKeyset,
adLockOptimistic

Your application should work with Windows 2000 without any changes in code
or recompiling of code. What is MDAC 7.1? There is not such version of MDAC.
Latest one, which you could install on Windows 2000 and which available for
download is MDAC 2.7. What kind of error message do you get?
It is possible that MDAC installation was corrupted and you could check it
if you run Component Checker utility from MDAC to see if it is fine or not.
If it is not, then you would need to run MDAC installation again to fix it

--
Val Mazur
Microsoft MVP

Quote:> I upgraded to Windows 2000 from Windows 98 recently. Some
> software I had written in Visual Basic 6.0 that worked
> fine prior to the upgrade now is unable to open my ADO
> Connection. I have tried several databases in both SQL
> Server and Access, and all fail on the Connection.Open
> statement. I had previously used MDAC 2.5 and have
> upgraded to MDAC 7.1. Any thoughts on where the error
> might be coming from. Here is a code fragment example of
> what I am doing....it is pretty straight forward:

>   ' Create Ado objections for DB Communication
>   Set sAdoDBCon = New ADODB.Connection
>   Set sAdoDBRec = New ADODB.Recordset

>   ' SQL Select statement
>   strSQL = "SELECT * FROM master"

>   ' Error handling
>   On Error GoTo Error_cmdRead_Click

>   ' Connect to the Database via ODBC
>   sAdoDBCon.ConnectionString = "DSN=CAMDB"

>   ' **************************************************
>   ' *** Fails on this Open statement
>   ' **************************************************
>   sAdoDBCon.Open
>   sAdoDBRec.Open strSQL, sAdoDBCon, adOpenKeyset,
> adLockOptimistic

Sean

Quote:>-----Original Message-----
>Hi Sean,

>Your application should work with Windows 2000 without
any changes in code
>or recompiling of code. What is MDAC 7.1? There is not

Quote:>Latest one, which you could install on Windows 2000 and
which available for
>download is MDAC 2.7. What kind of error message do you
get?
>It is possible that MDAC installation was corrupted and
you could check it
>if you run Component Checker utility from MDAC to see if
it is fine or not.
>If it is not, then you would need to run MDAC