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

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

Post by Maciek Paw » Wed, 28 Jan 2004 12:06:15


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
 
 
 

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

Post by Paul Cleme » Wed, 28 Jan 2004 23:08:51


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 ~~~ XXXX@XXXXX.COM
Microsoft MVP (Visual Basic)