"Unexpected error from external database driver"

Henrik Larsson

unread,

Sep 15, 2004, 5:48:29 PM9/15/04

to corel.developer.paradox

Hi All!

I'm having problem reading data from a Paradox 9 database file from
microsoft .net in a .aspx file. I never used paradox before, so plase go
easy on me :-)

I'm using a program, Portatree Drag Race which uses Paradox9 runtime. When I
trie to connect to the database files it has created I get the message
"Unexpected error from external database driver". See full error msg at end
of this msg.

If I trie with other older paradox files, it works. Microsoft only support
up to version 5.

This is what I do:

MyConnection = New OleDbConnection( _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\dl\;" & _
"Extended Properties=Paradox 5.x;" & _
"Persist Security Info=False")
MyCommand = New OleDbDataAdapter("select * from 040806.db",
MyConnection)
DS = New DataSet()
MyCommand.fill(DS, "Titles")
MyList.DataSource = DS.Tables("Titles").DefaultView
MyList.DataBind()

As I said it works fine on old files but when it comes to the newones it
fails. Without the bde and the paradox runtime env. I get a diffrent error
msg: "External table is not in the expected format". It doesen't mather if I
connect through ODBC or OLEDB, both fail.

So my question is: how do I connect to a paradox 9 database file from the
..Net enviroment? What driver do I need? And how do I use it, what should i
put in my connection string.

Thanks alot! Your help will be appreciated by alot of dragracers in sweden
who will be able to view there results on the web next season.
Henrik Larsson

---------- Full error msg --------------
Unexpected error from external database driver (11265).
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information
about the error and where it originated in the code.

Exception Details: System.Data.OleDb.OleDbException: Unexpected error from
external database driver (11265).

Source Error:

Line 75:
Line 76: DS = New DataSet()
-->Line 77: MyCommand.fill(DS, "Titles")
Line 78:
Line 79: MyList.DataSource = DS.Tables("Titles").DefaultView

Source File: c:\inetpub\wwwroot\dbtest\WebForm1.aspx.vb Line: 77

Stack Trace:

[OleDbException (0x80004005): Unexpected error from external database driver
(11265).]
System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(Int32 hr)
+41

System.Data.OleDb.OleDbCommand.ExecuteCommandTextForSingleResult(tagDBPARAMS
dbParams, Object& executeResult) +174
System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
+92
System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior,
Object& executeResult) +65
System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior
behavior, String method) +112
System.Data.OleDb.OleDbCommand.ExecuteReader(CommandBehavior behavior)
+69

System.Data.OleDb.OleDbCommand.System.Data.IDbCommand.ExecuteReader(CommandB
ehavior behavior) +5
System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32
startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior) +304
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord,
Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior
behavior) +77
System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
+36
dbtest.WebForm1.Page_Load(Object sender, EventArgs e) in
c:\inetpub\wwwroot\dbtest\WebForm1.aspx.vb:77
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
----------------------------------

Steven Green

unread,

Sep 15, 2004, 7:13:47 PM9/15/04

to corel.developer.paradox

Henrik Larsson wrote:

> I'm having problem reading data from a Paradox 9 database file from microsoft
> .net in a .aspx file.

that's where you should be posting your question.. you might get an answer here,
but were're experts in Paradox, not in dot net..

> If I trie with other older paradox files, it works. Microsoft only support up
> to version 5.

looks like you answered your own question.. you need a newer driver..

--
Steven Green - Waldorf Maryland USA

Diamond Software Group
http://www.diamondsg.com/main.htm
Paradox Support & Sales - Corel CTech Paradox
---------------------------------------------------
Diamond Sports Gems
http://www.diamondsg.com/gemsmain.htm
Trading Cards and other Sports Memorabilia
---------------------------------------------------

Henrik Larsson

unread,

Sep 16, 2004, 5:59:50 AM9/16/04

to corel.developer.paradox

Thanks Steven!

Yes and no, I'm stuck in a grey area. If I would post it on the .Net they
wouldn't know about Paradox and you guys don't know about .Net.
But skip the whole .net part then.

If I ask you like this instead; How do I create an DSN to a Paradox 9
database?

/Henrik Larsson

"Steven Green" <gre...@diamondsg.com> wrote in message
news:4148CCAB...@diamondsg.com...

Steven Green

unread,

Sep 16, 2004, 12:11:44 PM9/16/04

to corel.developer.paradox

Henrik Larsson wrote:

> If I ask you like this instead; How do I create an DSN to a Paradox 9
> database?

somebody else will have to answer that one..

Bertil Isberg

unread,

Sep 19, 2004, 4:19:25 PM9/19/04

to corel.developer.paradox

Henrik

<<
How do I create an DSN to a Paradox 9 database?
>>

Basically you do it the same way as you create any other datasource.

Paradox users have no need to create ODBC datasources to access Paradox
tables.
--
Bertil Isberg - CTECH
Paradox buglist:
online: http://w1.826.comhem.se/~u82608896/
FAQ newsgroup: corel.wpoffice.paradox-faq

Henrik Larsson

unread,

Sep 20, 2004, 4:01:05 AM9/20/04

to corel.developer.paradox

I'm trying to access paradox from outside of paradox.

Could you please tell me how to do this? I'm trying to connect to a Paradox9
file.

Thanks!
Henrik Larsson

"Bertil Isberg" <bertil.isberg@NOcomhemSPAMdotse> wrote in message
news:414de32e$1_2@cnews...

Bertil Isberg

unread,

Sep 20, 2004, 9:08:07 AM9/20/04

to corel.developer.paradox

Henrik

<<
I'm trying to access paradox from outside of paradox.

Could you please tell me how to do this?
>>

Create an ODBC datasource based on an ODBC driver that supports the
Paradox table format you are using. If that doesn't work, tell us
everything you define in the ODBC DSN specification.

--
Bertil Isberg
CTECH
FAQ newsgroup: corel.wpoffice.paradox-faq
Paradox Buglist: http://w1.826.comhem.se/~u82608896/

remove spamfilter (reversed) to reply

Henrik Larsson

unread,

Sep 20, 2004, 10:06:54 AM9/20/04

to corel.developer.paradox

Where do I find a ODBC driver for Paradox 9? I can only find Microsoft
Paradox driver and that one do not support version 9 of paradox databases.

Thanks!
/Henrik Larsson

"Bertil Isberg" <bertil...@retlifmapsSCB.se> wrote in message
news:414ed04c$1_1@cnews...

Bertil Isberg

unread,

Sep 20, 2004, 10:47:27 AM9/20/04

to corel.developer.paradox

Henrik

<<
Where do I find a ODBC driver for Paradox 9? I can only find Microsoft
Paradox driver and that one do not support version 9 of paradox databases
>>

It's enough if the driver supports Paradox 7 tables as there is no later
table format.

Once, a company named Intersolv made ODCB drivers. The name of the company
today is Datadirect. Sitename is probably www.datadirect.com.

Henrik Larsson

unread,

Sep 22, 2004, 11:24:06 AM9/22/04

to corel.developer.paradox

Bertil, if you where a girl, I'll kiss you! But since you're not I'll just
have to owe you a beer instead! :-)
Thanks alot!
Henrik Larsson

"Bertil Isberg" <bertil.isberg@NOcomhemSPAMdotse> wrote in message

news:414ee6db$1_3@cnews...