JDBC Connectivity error

[manikandan_shanmugam3]

Dear Experts,

We are trying to connect to the JDBC server but getting the below error can you help me wat is the exact issue

Error during database connection to the database URL 'jdbc:microsoft:sqlserver://ipaddres:port\<removed by mod> using the JDBC driver 'com.microsoft.sqlserver.jdbc.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://ipaddress:port\<removed by moderator> : SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.'

Regards,

Mani

Edited by: Gali Kling Schneider on Mar 16, 2011 2:35 PM

[baskar_gopalakrishnan2]

>>We are trying to connect to the JDBC server but getting the below error can you help me wat is the exact issue

Possible issues:

Message shows that your connection URL is WRONG.

Example:
JDBC Driver value is   com.microsoft.jdbc.sqlserver.SQLServerDriver
Connection value is   jdbc:microsoft:sqlserver://SQLSRV:portno;DatabaseName=something;

Check with t he same values and try to connect db client tool like TOAD or SQLExpress ? Just to make sure that connection string is not wrong.

Go through this [link|http://msdn.microsoft.com/en-us/library/ms378428(v=sql.90).aspx]

Verify your java version and SQL Server version matches.

Hope that helps.

[naveen_chichili]

Hi Mani,

First try to test your connectivity by giving the url:http://:<ip>:<port>/ftpjdbc

Click on JDBC connect test to DB--> then provide the details there .

If you are able to establish the connectivity successfully,then try the same thing in the comm channel.

Cheers!!!

NAveen.

[abhay_rajhans2]

Hi Mani,

Where are you putting this URL?

I think so you might be putting it into JDBC receiver or sender communication channel.

Please go through below links. Which will help to maintain parameters for JDBC. Also check if JDBC drivers are installed properly in your system.

http://wiki.sdn.sap.com/wiki/display/XI/JDBCTOJDBC

http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/frameset.htm

In connection parameter you will put values like this: jdbc:oracle:thin:@<ip>:<port>:<database name>

Edited by: Rajhans Abhay on Mar 10, 2011 7:55 AM

[aashish_sinha]

Hi

Check if your ipaddress and port is correct.. It is saying that you are using a wrong address means url for connection is wrong.

Regards

Aashish Sinha

[sivakumar_kilari3]

Hi,

How you are connecting ?

Siva