Re: Driver for NT SQL Db?

["Richard Dettinger" <cujo@xxxxxxxxxx>]

I think it depends on what you mean by an NT SQL database.  If you mean UDB
on NT, I would suggest using the IBM JDBC driver over using the JDBC/ODBC
bridge.  For one thing, you don't need to set up an ODBC data source to
make it work, for another, JDBC drivers are pretty portable, but they are
not the poster child of "write once run anywhere".  Even if you don't care
about performance now, I find it a good idea to be running with what you
would like to deploy on as early as possible.

If you mean some other NT database, the same applies... find their JDBC
driver and try to set it up.

Regards,

Richard D. Dettinger
AS/400 Java Data Access Team

"Biologists have a special word for stability -- dead"

                Larry Wall
                Open Source Developers Journal
                Issue 1, Jan  2000


"Stone, Brad V (TC)" <bvstone@taylorcorp.com> on 03/21/2001 10:17:10 AM

Please respond to JAVA400-L@midrange.com

To:   "'JAVA400-L@midrange.com'" <JAVA400-L@midrange.com>
cc:
Subject:  Driver for NT SQL Db?




Interested in what driver folks use for attaching to an NT SQL database.
Any info is appreciated.  For example, one that comes with JDK, or it has
to
be downloaded, etc.

Right now I'm not worried about speed, I just want to see if I can attach
to
one on our network.  I am using the "properties" method explained a while
ago here where I have a db properties file that looks like:

driver=com.ibm.as400.access.AS400JDBCDriver
url=jdbc:as400://machine
user=user
password=password

So Im really looking for something as easy as replacing the driver and url
properties in the file for the particular machine (I plan on having one db
properties file for each machine that I want to attach to).

Thanks!

Brad
+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---



+---
| This is the JAVA/400 Mailing List!
| To submit a new message, send your mail to JAVA400-L@midrange.com.
| To subscribe to this list send email to JAVA400-L-SUB@midrange.com.
| To unsubscribe from this list send email to JAVA400-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: joe@zappie.net
+---