FIle to JDBC scenario

[Former Member]

Hi guys,

I want to develop a sample file to JDBC scenario. I have seen blogs on it. But how do i intstall the JDBC driver in my local PC and what are the things that needs to be installed in the system.

thanks

sankar

[Former Member · Accepted solution]

Hi,

You need to Install the JDBC Drivers on XI Server not in ur Local Desktop.

To install JDBC driver follow the how to guide.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>

UserID and Password.

If the connection is not working find the correct port number.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d...

REgards

Seshagiri

[Former Member · Accepted solution]

Hi

I am getting an error when opening the below link

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

can you provide me the correct link/

thanks

[Former Member]

i still have some doubts

[Former Member]

Hi,

go through the below link:

chirag

[Former Member]

installation of JDBC driver on XI server must be done.

decide on the database and then install the corresponding driver.

eg. if you decide mySQL database, then mySQL connecter must be installed on XI server and mySQL server instance must be configured in your system.

[Former Member]

Hi

Lets say I am using microsoft access in my local PC to create a database and tables. can I access this database from XI. if yes, what are the JDBC adapter settings i need to do ??

thanks

Edited by: sudhakar murthy on Aug 26, 2008 10:47 AM

[Former Member]

Hi,

please have a look here:

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/f04ce027-934d-2a10-5a8f-fa0b1ed4...

Regards

Patrick