problem connecting to a DB ?

[Former Member]

Hi Guys,

I have configured JDBC receiver channel for the DBLookup and install the drivers for the sql server and i am getting the error as below

Error when attempting to get processing resources: com.sap.aii.af.service.util.concurrent.ResourcePoolException: Unable to create new pooled resource: DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://IPaddress:1433;DatabaseName=WEBSERVICES01': SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Unable to connect. Invalid URL.

any help or suggestions would be appreciated

Thanks,

Srini

[Former Member]

Hi,

You need to install some drivers.

To install JDBC driver follow the how to guide.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

Configuration of JDBC Adapter for SQL Server

JDBC Driver = com.microsoft.jdbc.sqlserver.SQLServerDriver

Connection = jdbc:microsoft:sqlserver://hostname:<port>;DatabaseName=<DBName>

UserID and Password.

If the connection is not working find the correct port number.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/40b92770-db81-2a10-8e91-f747188d...

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Thanks

vikranth

[Former Member]

Hi,

It doesn't seem to be problem with driver as you have already instaled all the three necessary drivers. Try connecting to your sql sever from some sql client and see if all the parameters you mentioned in the jdbc channel are correct.

If you know Java, just for debugging purpose try to use the driver you have and write a java(jdbc) program to connect to the sql sever 2005. This way you can narrow down your problem.

If this doesn't wok you might need to download the drivers for sql server 2005, install on XI server and try again.

Reward point if answer is useful

Thanks

Amit