Re:BDE - Paradox - ODBC driver for Paradox - Error (urgent)
In article <7dumup$3f...@nnrp1.dejanews.com>,
Quote
jamesfaj...@my-dejanews.com wrote:
> In article <7ds94a$ao...@forums.borland.com>,
> "Nelson Henrique" <nel...@datagricolae.com.br> wrote:
> > I need access these Paradox databases using ODBC driver for Paradox. I can
> > open the Paradox databases by Database Explorer, but when I try access any
> > table, I receive a Database Engine Error: BDE Error 10039 {$27} {37}
> > "Invalid Table Name".
> Use the BDE Administrator to set the
> Paradox LANGDRIVER to "Paradox 'ascii'"
> and the LEVEL to 5
> and recreate the tables.
> (LANGDRIVER and LEVEL are found under
> Configuration / Drivers / Native / PARADOX)
> You _must_ recreate the tables when the above settings
> are in effect, because those settings are written into
> the table & can't be changed afterwards.
Hooray!!! - thanks to you I have solved a problem I have been beavering away
at since January! How did you hit upon changing the language drivers? I
looked all over the place and asked in the borland.com newsgroups and got
nowhere...
Actually life isn't quite as easy as your message implies. You have to change
the language driver of the ODBC driver as well. Here's what I did:
1) changed the drivers /native /paradox langdriver to "Paradox 'ascii'"
2) created a paradox table using the native driver
3) created an odbc (user) dsn to access the paradox table
4) changed the odbc driver to use "Paradox 'ascii'" as well
5) opened the dsn and then the table
And there were no error messages!
It looks like you have to select a common language driver for both the native
driver and the odbc driver - the defaults are inappropriate.
Also you may have to be careful about the ODBC's understanding of indices. If
you create a primary key using the BDE native driver, the ODBC reports that it
is a unique non-primary key!
I am not sure that is a major problem but I think its worth knowing about.
The other possible incompatibility is an AUTOINC field. As it turns out this
is handled properly and has not caused a problem in my tests.
Thanks again
Mark
-----------== Posted via Deja News, The Discussion Network ==----------
http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
