HowTo Install jdbc on Linux Machine

[Former Member]

Hi, well i want to connect to a ODBC on a MS Machine. Our XI is installed on a Linux EP 10.0. Therefore I downloaded this:

<a href="http://www.microsoft.com/downloads/details.aspx?familyid=6D483869-816A-44CB-9787-A866235EFC7C&displaylang=en">http://www.microsoft.com/downloads/details.aspx?familyid=6D483869-816A-44CB-9787-A866235EFC7C&displaylang=en</a>

...but here i only found the sqljdbc.jar which i tried to deploy like the guide <i>How To Install and Configure External Drivers for JDBC and JMS Adapters</i> told me.

I do miss the following jar's:

msbase.jar, mssqlserver.jar, msutil.jar

Where can i get them and what is mandatory for using them on a Linux-Machine?!

br

[Former Member]

Hi !

Check with these pdf's

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/2498bf90-0201-0010-4884-83568752...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/6945da7d-0c01-0010-1792-dd7b5d87...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/d149ec34-0d01-0010-4791-db4f1d86...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/607ebbd5-6555-2a10-e285-c2cbec4e...

<b>for these JARs msbase.jar, mssqlserver.jar, msutil.jar</b> Check these pdf's

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

<b>Find this doc for JDBC drivers-</b>https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

(msbase.jar, mssqlserver.jar, msutil.jar).

Driver:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection for MS SQL Server:

jdbc:microsoft:sqlserver://<server>:1433;databaseName=<dbname>

If you are using the new SQL Server 2005 jdbc driver (sqljdbc.jar). Setup is basically the same, except the driver is now:

com.microsoft.sqlserver.jdbc.SQLServerDriver

And the URL is slightly different as well:

jdbc:sqlserver://host:1433;DatabaseName=name

<b>Check This thread discuss the same for these jars</b>

Thanks!!

[Former Member]

Carsten,

Which databse would you like to connect?

Microsoft SQL server 2000? Or any other db version?

Regards,

Jai Shankar