on 06-17-2005 12:19 PM
Hi all,
I am trying to connect a database using the config tool as given in the following link.
http://help.sap.com/saphelp_nw04/helpdata/en/ec/9432d189c445cdacdc7e520981b4b6/frameset.htm
Here I need to overwrite the settings and hence need to provide the RDBMS url.
What should I specify in the space givne for that?
Thanks in advance.
Regards
Noufal
Hi noufal ,
U have to specify ur string class.forName there in that url. Its sun.jdbc.odbc.JdbcOdbcDriver , and u have to specify ur DNS name ther ,i dont remember that exactly u can try this.
Regards,
Sirisha.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Noufal
You need to provide the URL which is specific to the DB you are trying to use. Because thin drivers are used to call the DB the url should contain the sever name ,port and DB name.
Eg:-
For SQL Server
jdbc:datadirect:sqlserver://<server>:<port>;databasename=<db name>
For Oracle (I think)
jdbc:oracle:thin:@<server>:<port>:<sid>
But this DB connection is for WAS to talk to the DB for configuration settings(usually done during and cut and paste installations ) . Application specific usage of DB should be done through DB Provider in VA
Regards
Pran
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Pran,
I tried your suggestion for SQL server, but it didn't work. I entered the ff.:
jdbc:datadirect:sqlserver://ssip-adb001:1433;databasename=J2E
I keep on getting an error that says, "Error occured while working with Configuration (Scanning). Msg: Error while connecting to DB."
Regards,
Erik
User | Count |
---|---|
85 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.