Connecting to SQL Server 2000 with jdbc 2.0 from Web AS SP9

[Former Member]

Can someone tell me how to set op a JDBC 2.0 connection to my existing sql server instance. I must be a JDBC 2.0 connection type. How can a add the Microsoft drivers to the servers classpath and how can i get a connection using JNDI.

Please let me know.

[Former Member]

Hi Edward,

you must follow the steps below:

1. Deploy the drivers as described here: http://help.sap.com/saphelp_nw04/helpdata/en/80/4f34c587f05048adee640f4c346417/frameset.htm

2. Create a DataSource definition as described here: http://help.sap.com/saphelp_nw04/helpdata/en/ab/082484173ae045ab8dad8a41d33da3/frameset.htm

3. Create a reference to the DataSource from your application and then look it up using JNDI. All of these are descibed here: http://help.sap.com/saphelp_nw04/helpdata/en/82/fdbf2085f65f43a71e755fc904478d/frameset.htm

Hope that helps!

[Former Member]

Ivaylo Ivanov,

Thanx,

Everything is working fine now. I mist the driver part in the admin console. But thanx to you I get it working.

With native SQL.