QUESTION POSED ON: 09 June 2004
I have a problem with Paradox. I saw that you had a Connection String and the connection works fine but when I want to do a SQL query on the database it return the following error:
Unexpected error from external database driver (11270).
Here is the code I used:
Dim tempCn As New ADODB.Connection
tempCn.Open("Driver={Microsoft Paradox Driver (*.db )};" & _
"DriverID=538;" & _
"Fil=Paradox 5.X;" & _
"DefaultDir=" & FilePath & ";" & _
"Dbq=" & FilePath & ";" & _
"CollatingSequence=ASCII")
dim lrs as adodb.recordset
This all works fine but I get the error on the following line:
lrs.Open("Select * from MyTest" , tempCn, ADODB.CursorTypeEnum.adOpenForwardOnly, ADODB.LockTypeEnum.adLockReadOnly). Can you give me any help?
Platform: Visual Studio 2003. Windows XP Professional
|
