File to JDBC scenario

[Former Member]

Hello,

We have a scenario in sending a file to update our MS sql server 2000 DB. The XI system runs on an Unix OS platform but the MS Sql server 2000 is on a windows platform. Are the JDBC drivers OS dependent? If yes do I need to install the MS Sql JDBC drivers for windows or the MS Sql JDBC drivers unix (if they are different). Please advise.

-Teresa

[agasthuri_doss · Accepted solution]

Hi,

>The XI system runs on an Unix OS platform but the MS Sql server 2000 is on a windows platform. Are the >JDBC drivers OS dependent?

NO, Swarup mentioned the url from there you can download the Driver and deploy it in the XI box.

Regards

Agasthuri Doss

[Former Member · Accepted solution]

Hi,

From the replies, I opened the link to download the driver but just a little confused. We have XI on Unix and SQL server on Windows. So should I download the windows driver version or the UNix driver version? In other words should I choose the driver version of the SQL server OS even though my XI server is in a different OS.

Please advise.

Teresa

[Former Member · Accepted solution]

Yes, you have to download the version exist on the SQL Server.

Which is windows in your case.

Gaurav Jain

*Points

[Former Member]

Hi,

You will be using the external MS SQL system so it can either download the JDBC drivers from Microsoft Website. These will work with Unix as well as Windows paltform.

http://www.microsoft.com/downloads/details.aspx?FamilyID=6D483869-816A-44CB-9787-A866235EFC7C&displa...

and deploy the JDBC driver using SDM.

JDBC Driver Deployment Guide...

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

There is a commercial product available from the following..

http://www.openlinksw.com/

There is also a evaluation download.

Thanks

Swarup

Edited by: Swarup Sawant on Jun 7, 2008 7:41 PM