RE: JDBC driver for SQLServer

[Charles Anthony <charles.anthony@xxxxxxxxxxxxxxx>]

Hi,

We've successfully used the Microsoft jdbc jar driver access an MSSqlServer
database from an As/400. It is free to use, although you're not allowed to
distribute it. It is a Type4 driver - i.e. 100% java, and hence should work
on any JVM.

How you unpack it etc, on the ISeries, I've no idea. We basically installed
in on a windows PC, and just moved the jars onto the AS/400.

Cheers,

Charles.



>-----Original Message-----
>From: Patrick L Archibald [mailto:Patrick.Archibald@xxxxxxxxxxxxx]
>Sent: Wednesday, August 27, 2003 2:03 PM
>To: Java Programming on and around the iSeries / AS400
>Subject: Re: JDBC driver for SQLServer
>
>
>Keith
>
>I bought a type 4 JDBC driver from Weblogic, mssqlserver4v70.jar to 
>access, via a Servlet, our Building Access Server that uses MS 
>SQLServer 
>database.  Let me know if you find a free version somewhere.
>
>Thanx, PLA
>
>keith_mccully@xxxxxxxxxxxxxxx wrote:
>
>>Has anyone located and successfully implemented a JDBC driver 
>on the AS400
>>for access to a MS SQLServer database?
>>
>>So far, I've downloaded the JDBC driver mssqlserver.tar from the MS
>>downloads site but can I untar this in qshell? My first 
>attempt failed but
>>I'm unfamiliar with the tar command parms so probably missed 
>something.
>>
>>Thanks,
>>
>>Keith
>>
>>
>>
>>
>>
>>
>>_______________________________________________
>>This is the Java Programming on and around the iSeries / 
>AS400 (JAVA400-L) mailing list
>>To post a message email: JAVA400-L@xxxxxxxxxxxx
>>To subscribe, unsubscribe, or change list options,
>>visit: http://lists.midrange.com/mailman/listinfo/java400-l
>>or email: JAVA400-L-request@xxxxxxxxxxxx
>>Before posting, please take a moment to review the archives
>>at http://archive.midrange.com/java400-l.
>>
>>
>>
>>  
>>
>
>
>_______________________________________________
>This is the Java Programming on and around the iSeries / AS400 
>(JAVA400-L) mailing list
>To post a message email: JAVA400-L@xxxxxxxxxxxx
>To subscribe, unsubscribe, or change list options,
>visit: http://lists.midrange.com/mailman/listinfo/java400-l
>or email: JAVA400-L-request@xxxxxxxxxxxx
>Before posting, please take a moment to review the archives
>at http://archive.midrange.com/java400-l.
>


This email and any attachments are strictly confidential and are intended
solely for the addressee. If you are not the intended recipient you must
not disclose, forward, copy or take any action in reliance on this message
or its attachments. If you have received this email in error please notify
the sender as soon as possible and delete it from your computer systems.
Any views or opinions presented are solely those of the author and do not
necessarily reflect those of HPD Software Limited or its affiliates.

 At present the integrity of email across the internet cannot be guaranteed
and messages sent via this medium are potentially at risk.  All liability
is excluded to the extent permitted by law for any claims arising as a re-
sult of the use of this medium to transmit information by or to 
HPD Software Limited or its affiliates.