B
Bill Phillips
I am trying to connect to a Progress database and keep getting the following
error:
Could find installabel ISAM with the following error codes -2147467259 and
80004005.
I have tried checking the newsgroups, but none of the solutions seem to work
for me. Here is my code snippet:
Private Sub Command1_Click()
Dim conn As ADODB.Connection
Dim rs1 As ADODB.Recordset
Set conn = New ADODB.Connection
conn.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;DSN=MyDSN;UID=MyUID;PWD=MyPWD;Data Source =
MyDataSrcName"
conn.Open
MsgBox "Connection Established"
I put the MsgBox in just to test the connection. I am using the Merant v3.60
SQL92 drivers and an Access 2000 database. When I test the connection from
Administrative Tools/ODBC I get a connection. I just can't figure out the
problem on the call from Access.
Thanks
error:
Could find installabel ISAM with the following error codes -2147467259 and
80004005.
I have tried checking the newsgroups, but none of the solutions seem to work
for me. Here is my code snippet:
Private Sub Command1_Click()
Dim conn As ADODB.Connection
Dim rs1 As ADODB.Recordset
Set conn = New ADODB.Connection
conn.ConnectionString =
"Provider=Microsoft.Jet.OLEDB.4.0;DSN=MyDSN;UID=MyUID;PWD=MyPWD;Data Source =
MyDataSrcName"
conn.Open
MsgBox "Connection Established"
I put the MsgBox in just to test the connection. I am using the Merant v3.60
SQL92 drivers and an Access 2000 database. When I test the connection from
Administrative Tools/ODBC I get a connection. I just can't figure out the
problem on the call from Access.
Thanks