on 05-13-2006 7:35 AM
Hi All,
I have a requiement like this.....
How to connect sqlserver through WebApplicationServer.
can anybody help me about how to access(connect) sqlserver through WAS ,Thanks in Advance.
Regards.
Srinivas
Hi
1) First you have to load the JDBC driver. Hope you have the JDBC driver related Library( zip /jar ....) files . You can do this using visual admin
http://help.sap.com/saphelp_nw04/helpdata/en/c0/3ad4d5cdc66447a188b582aad537d3/frameset.htm
For MS-SQl u will need the following jar's
Microsoft SQL : msbase.jar, mssqlserver.jar, msutil.jar
2)Then you need to create a Datasource .
This can be done in 2 ways
1)Visual admin
http://help.sap.com/saphelp_nw04/helpdata/en/c0/3ad4d5cdc66447a188b582aad537d3/frameset.htm
2)Deploying DataSource with an application (EAR) or J2ee library
-- Create a file named data-sources.xml
(http://help.sap.com/saphelp_nw04/helpdata/en/64/0bee3da7138e5be10000000a114084/frameset.htm)
--Include the file in the META-INF directory of your application archive (EAR) file and deploy it to the J2EE Engine or Include the file in the ../server/descriptors directory of the library SDA, and deploy it to the J2EE Engine
3) Once this is done yoy can acess the Data source Directly in your java code using JNDI lokk up to that data source
Hope this helps ,please do not forget to reward points
regards
rajeshkr
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Srini,
For that you will have to use JDBC with the SAP WAS.
Please go through the following link for more help,
http://help.sap.com/saphelp_webas630/helpdata/en/b0/6e62f30cbe9e44977c78dbdc7a6b27/content.htm
For overview of JDBC please refer to following link,
http://help.sap.com/saphelp_nw04/helpdata/en/5f/3a8b14c26349b2ba964707ccceffd8/frameset.htm
Hope this helps,
Guru.
PS: Reward points for helpfull answers.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.