Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Using SQL Dev 1.2.1 to access Paradox 4.x (or later) via JDBC?

486483Apr 3 2008 — edited Apr 5 2008
Howdy, y'all; it'd be useful if I could get at a Paradox fileset for conversion to XE (or other updating).

After defining specifying the path to the Paradox JDBC object via "Tools, Preferences, Database, Third-party JDBC Drivers," how would I define a connection object? I was under the impression (did I read it somewhere?) that SQL Dev could access anything via JDBC.

Thanks kindly.

Andy Bender
SoCal, USA.

Comments

-K-
Yes and no.
If you figure out the JDBC URL, you can set up an Advanced Connection Type.
But connecting is 1 thing, and working with the objects inside the database is something else. Maybe you could get plain SQL to work inside a worksheet, but since Paradox isn't supported, you won't get anything more than that.

You can add a feature request on the SQL Developer Exchange, but I think there's little chance you get it soon.

Take a look at the Migration tech center on OTN, there should be a 32-bit ODBC tool somewhere which pulls the table data...

Regards,
K.
SueHarper
Take a look at Oracle's Application development tools: Oracle JDeveloper supports this via JDBC.

Sue
Just to add to k's comments. The workbench side of SQL developer will have the ability to pull from odbc at some point, but we will not be offering general browsers like the ones for MySQL SQLServer etc. The reason being is that we can never be sure what features of jdbc/odbc any driver supports and will have to do a case by case basis. For the migration part, the logical starting point would be to get the tables and data out of the paradox or whatever it is.
Anyway, thats in the future for now.
B
1 - 3
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 3 2008
Added on Apr 3 2008
3 comments
1,248 views