JDBC Connection

John Panariello

unread,

Oct 18, 2004, 11:42:57 AM10/18/04

to corel.wpoffice.paradox9

Hi all,

My goal is to connect to a Paradox table via Coldfusion Mx 6.1. I am
currently connecting via ODBC socket which is quite slow and limited in
functionality.

Therefore, I am trying to get the JDBC driver to work. I have so far been
unsuccessful.
I have installed the jPox Web Utilites to get the driver (PdxJdbc.jar). Set
the classpath to point to the driver.

I have set up an alias in the BDE.

I have entered the following:

JDBC URL:
jdbc:bdea://localhost/ParadoxDatabaseAlias;SM=SessionMgr; where
ParadoxDatabaseAlias is the name of alias I set up in the BDE.

Driver Name:
com.corel.pdx.driver.PdxJDBCDriver

Class Name:
com.corel.pdx.driver.PdxJDBCDriver

These parameters are consistent with the jPdox Web Utilities User Guide T
documentation.
I keep getting a "No suitable driver" java exception.
Any help would be much appreciated

Thank you in advance,

John

Dennis Santoro

unread,

Oct 18, 2004, 9:18:36 PM10/18/04

to corel.wpoffice.paradox9

John,

You might get lucky and get some help but pretty much no one uses the JDBC
driver (and I don't believe it comes with a distribution license either. Most of
us here build the web stuff we do right in OPAL using the Web Server OCX. YOu
can get more info on that in the web newsgroup here or the one at
thedbcommunity.com.

Denn Santoro
President
Resource Development Associates
http://www.RDAWorldWide.Com
Offices in the United States and Germany
Providing solutions to health care, business, governments and non-profits since
1982

Roy F

unread,

Oct 19, 2004, 12:03:04 AM10/19/04

to corel.wpoffice.paradox9

Hi John,

> My goal is to connect to a Paradox table via
>Coldfusion Mx 6.1. I am currently connecting
>via ODBC socket which is quite slow and limited in
>functionality.

I used to use ColdFusion 5 with Paradox tables quite a bit. I would
connect using the ODBC driver that came with paradox and it was not slow
or limited in any way. If you use the MS driver it is limited in
functionality.

Regards,
Roy F.

John Panariello

unread,

Oct 19, 2004, 8:26:51 AM10/19/04

to corel.wpoffice.paradox9

Roy and Dennis,
Thanks for the quick responses.

I actually am using CF 5.0 with the merant odbc drivers and they work fine,
but we are upgrading to CF MX and the drivers are no longer packaged with
Coldfusion, so we were trying the ms odbc drivers and they are slow and
limited.

According to the documentation the JDBC driver should work. I beleive the
problem is in the JDBC URL string, not properly finding the the BDE to
obtain the aliases.

JDBC URL:
> > jdbc:bdea://localhost/ParadoxDatabaseAlias;SM=SessionMgr;

Also, I will look into using OPAL using the Web Server OCX.
Thanks again,

John

"Roy F" <roy...@NOMORESPAMcox.net> wrote in message
news:41748842$1_1@cnews...

Dennis Santoro

unread,

Oct 19, 2004, 9:39:51 AM10/19/04

to corel.wpoffice.paradox9

John Panariello wrote:

> Also, I will look into using OPAL using the Web Server OCX.

Start with Tony McGuire's Web Server OCX paper at our Paradox resources page
(link in my signature).

Roy F

unread,

Oct 20, 2004, 12:02:40 AM10/20/04

to corel.wpoffice.paradox9

Hi John,

I am still using CF 5. I plan to skip MX and then move to Blackstone
when it is released next year. Rather than the MS drivers or the ones
that ship with CF, I would try the driver that comes with Pdox 9. That
should work fine.

levv14...@gmail.com

unread,

Aug 9, 2016, 11:50:04 AM8/9/16

to

Hello
please; I can send my mail? levv14...@gmail.com the PdxJdbc.jar file.
PdxJdbc_doc.jar, PdxJdbc_source.jar

thank you very much