[ODBC Paradox Driver] Unexpected error from external database driver (11010).

[Maciek Pawlowski]

I am trying to import data from a set of Paradox tables. For some reason, I
am getting the following error:

Microsoft.Data.Odbc.OdbcException: ERROR [HY000] [Microsoft][ODBC Paradox
Driver] Unexpected error from external database driver (11010).
Could anyone give me any insight on this error (at least a good resource
which will help me to resolve this issue)? I have been searching for a
solution to this problem for quite some time now and I cannot seem to get it
resolved.
Thanks for all your input.
Maciek P

 

[Paul Clement]

¤ I am trying to import data from a set of Paradox tables. For some reason, I
¤ am getting the following error:
¤
¤ Microsoft.Data.Odbc.OdbcException: ERROR [HY000] [Microsoft][ODBC Paradox
¤ Driver] Unexpected error from external database driver (11010).
¤ Could anyone give me any insight on this error (at least a good resource
¤ which will help me to resolve this issue)? I have been searching for a
¤ solution to this problem for quite some time now and I cannot seem to get it
¤ resolved.

What version of the Paradox is the database?

Have you tried using the Jet provider and Paradox ISAM:

Public Sub ImportParadoxToAccess()

Dim AccessConn As New System.Data.OleDb.OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;"
& _
"Data Source=e:\My Documents\db1.mdb")

AccessConn.Open()

Dim AccessCommand As New System.Data.OleDb.OleDbCommand("SELECT * INTO [ParadoxTable] FROM
[Paradox 5.x;DATABASE=e:\My Documents\Paradox].[Paradox5.DB]", AccessConn)

AccessCommand.ExecuteNonQuery()
AccessConn.Close()

End Sub


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)