I have a problem when I open a Paradox Database Recordset with ADO, the message I receive this message :
Run-time Error '2147467259(80004005)': [Microsoft][ODBC Paradox Driver] External table is not in the expected format."
Thank you for any ideas - Adrian
Code Example :
Dim cn as new adodb.connection
Dim rs as new adodb.recordset
cn.open "Driver={Microsoft Paradox Driver (*.db )};" & _
"DriverID=538;" & _
"File;" & _
"DefaultDir=" & "c:\PFRTITRE.DB"& ";" & _
"Dbq=" & "c:" & "\;" & _
"CollatingSequence=ASCII"
rs.Open "select * from PFRTITRE", cn
rs.Close
cn.Close
Run-time Error '2147467259(80004005)': [Microsoft][ODBC Paradox Driver] External table is not in the expected format."
Thank you for any ideas - Adrian
Code Example :
Dim cn as new adodb.connection
Dim rs as new adodb.recordset
cn.open "Driver={Microsoft Paradox Driver (*.db )};" & _
"DriverID=538;" & _
"File;" & _
"DefaultDir=" & "c:\PFRTITRE.DB"& ";" & _
"Dbq=" & "c:" & "\;" & _
"CollatingSequence=ASCII"
rs.Open "select * from PFRTITRE", cn
rs.Close
cn.Close