Driver Installation

[Former Member]

Hi Experts,

I am getting the below error when I try to access datas from SQL Server 2005.

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:sqlserver://TARPONARCH3:1433;databaseName=PIP': SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Do we need to any driver installation during Post-Installation of PI 7.0?

Regards

Sara

[Former Member · Accepted solution]

Hi,

We have to install drivers

[Former Member · Accepted solution]

Hi chirag,

I couldn't open the link. Do we need to have any special permission for the link?

Regards

Sara

[former_member181985 · Accepted solution]

Hi,

Give me your mailID, i will send you the required files

Thanks,

Gujjeti

[former_member556603]

Hello Sara,

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,

Satya Kumar

Reward Points If it is Useful..

[Former Member]

Check the links..

To install oracle drive in XI server, just check these links,

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-964...

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

http://msdn2.microsoft.com/en-us/library/ms177523.aspx

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

/people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=jdbc%20with%20multiple%20tables&cat=sdn_all

[Former Member]

HI,

Refer the below step by step process.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-9644e49f...

chirag