RDBMS url in the config tool

[Former Member]

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

[Former Member · Accepted solution]

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.

[guru_subramanianb]

Hi Eric,

If u have still problem go thro' this thread which has answer for ur query.

Rdgs,

guru

[Former Member]

Hi!

Turns out that JDK 1.5 was present. JDK 1.4 was the requirement.

Downgraded and it worked.

Any reference article for this incident?

[Former Member]

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

[Former Member]

Hi Pran,

Can I have your mail Id please?

[Former Member]

pran_bhaskaran at satyam dot com

[Former Member]

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

[Former Member]

Hi Erik,

please try using

jdbc:sap:sqlserver://ssip-adb001:1433;databasename=J2E

and see whether it works or not.

Regards,

Shubhadip

[Former Member]

Shubhadip,

Still the same error.

Regards,

Erik