RE: Driver for NT SQL Db?

You need a type 4 JDBC Driver.  I've used the following product to connect
to an MS SQL server from my AS/400.

i-net OPTA 2000 Version 2.05 for MS SQL Server.  http://www.inetsoftware.de

-----Original Message-----
From: Stone, Brad V (TC) [mailto:bvstone@taylorcorp.com]
Sent: Wednesday, March 21, 2001 12:12 PM
To: 'JAVA400-L@midrange.com'
Subject: RE: Driver for NT SQL Db?


I meant the SQL Server DB.  Sorry.  I guess if it's an MS product I'd better
get it now or it won't be available soon.  :)

Brad

> -----Original Message-----
> From: Richard Dettinger [mailto:cujo@us.ibm.com]
> Sent: Wednesday, March 21, 2001 11:45 AM
> To: JAVA400-L@midrange.com
> Subject: Re: Driver for NT SQL Db?
> 
> 
> 
> 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
> +---
> 
+---
| 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
+---