cancel
Showing results for 
Search instead for 
Did you mean: 

Error in JDBC Adapter-"Error establishing socket"

Former Member
0 Kudos

Hi,

I am getting an error in the seander JDBC adapter. PFB the error:

Error during database connection to the database URL 'jdbc:microsoft:sqlserver://Server Name;DatabaseName=DB Name;SelectMethod=cursor' using the JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://Server Name;DatabaseName=DB Name;SelectMethod=cursor': SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.'

Can any one hlep me to resolve the error.

Thanks,

RK

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Krish,

It says "Cannot establish connection to URL". So please check the Connection string(IP address, Port and database name) which you have given in sender JDBC communication channel.

Thanks & Regards,

Senthil.

Former Member
0 Kudos

Hi,

Also check whether you have given database connection parameters in the following format:

JDBC Driver:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection: jdbc:microsoft:sqlserver://<HOSTNAME>:1433;DatabaseName=<xxxx>;SelectMethod=cursor

I think the deployment is done, because you have not got "SAPClassNotFoundException" error.(If the deployment is not done, the driver file cant be located so this will be thrown...)

Thanks & Regards,

Senthil.

Former Member
0 Kudos

'com.sap.aii.adapter.jdbc.sql.DriverManagerException

--->check with Basis administrator if drivers have been installed properly on XI server