JDBC Adapter - Established database connection failed

[Former Member]

Hi Guys,

we have installed the JDBC Adapter based on the How To Guide and we checked after the installation the Libaries :Cluster --> Server --> Libraries --> com.sap.aii.af.jmsproviderlib and the box Box "JARs Contained" was filled.

So in my point of view we have done everything right during the installation.

Now the developer tested theJDBC Adapter and he comes back with following Error:

Attempt to establish database connection failed with SQL error com.sap.aii.adapter.jdbc.sql.DriverManagementException: Cannot establish connection to URL "jdbc:microsoft:sqlserver://xxx.x.xx.xxx:1433; databaseName=CZZ03;":ClassNot FoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

Do you have any ideas?

Regards

Markus

[former_member556603]

Hello Markus,

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]

According to the release of your SQLServer, class name used for driver will be different :

2K : com.microsoft.jdbc.sqlserver.SQLServerDriver

2K5 : com.microsoft.sqlserver.jdbc.SQLServerDriver

Rgds

Chris

[Former Member]

Hi,

it seems we have installed the wrong driver.. 2005 and not 2000..

Just one question: We have downloaded the MS SQL JDBC driver from microsoft SPS 3 and ther we have 3 files:

msbase.jar

mssqlserver.jar

msutil.jar

Do we have to take all 3 of them?

Further we have to install the JDBC driver for a different database and for that we have downloaded the jtopen_5_4.zip which contains al lot of jar files. Can anybody of you name the the correct one we have to use?

composer.jar

jt400.jar

jt400micro.jar

jt400native.jar

jt400proxy.jar

jt400servlet.jar

juit400.jar

outpurwriters.jar

reportwriter.jar

tes.jar

uitools.jar

util400.jar

SO if you can name me the correct ones, it would be great.

cheers

Markus

[Former Member]

Hi Guys,

it seems that we have used a wrong driver...

Can anybody of you tell me where I can download the JDBC driver for MSSQL2000?

When I go to the microsoft page I can only download an exe file (what is not working for Unix).

And in the servicepacks are only the files I listed in the

[VijayKonam]

Hei,

If it is class not found error, the problem must be in the driver installation only. Check if the drivers were properly installed..!! Did you do it through SDM?

VJ