Unexpected error from external database driver (11265).

[carlosparedes]

Hi guys

I'am trying to connect to a paradox database.
The connection works fine. When it gets to the line
"rs.Open SQL, conn"
it throws the folowing error:
Error Type:
Microsoft JET Database Engine (0x80004005)
Unexpected error from external database driver (11265).
Any ideias how to solve it. Thanks in advance

sandra

 

[Sheco]

Often it is a problem with the SQL syntax. The first thing I would suggest is write it out to the screen to see if it is really what it is supposed to be:

[tt]Response.Write "The SQL is: " & SQL
Response.End [/tt]


If that is OK then next I would check to see if the connection really is fine. To do this I would use the .Execute method of the connection object:
[tt]
Set rs = conn.Execute(SQL)[/tt]

 

[carlosparedes]

I have tried both things still getting the same error. Changed the connection to ADO OLE DB and the error is now:
Error Type:
Microsoft JET Database Engine (0x80004005)
Unrecognized database format 'C:\Testlocation\data\TEST.db'.
Reformat database to paradox 4 but still getting the same error.

Thanks
Sandra

 

[Sheco]

What program are you using to view/reformat the database?