|
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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.