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.
1 Answer
-
Former MemberPosted on Jan 25, 2005 at 09:13 AMHi 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!
Add a comment
Add a comment