SQL Server Drivers?

[Former Member]

Hi All,

Can anybody help me out with thesequestions.

1. what is the drivers needed to connect XI to SQL Server Database.

2. If I deploy the drivers of lastest version of SQL Server Database , will it enable XI to connect ot the database.

3. does JDBC Driver entry in adapter chanegs with driver version.

[Former Member]

Hi guys,

I'm having the same problem when trying to connect to the database.

I have installed the drivers for SQL2005 in my PI server, but when I search

for the file aii_af_jmsproviderlib.sda in my server, I find it in :

\usr\sap\PXD\DVEBMGS01\SDM\root\origin\sap.com\com.sap.aii.af.jmsproviderlib\SAP AG\2\7.0009.20060728142055.0000\work\META-INF

Is this normal?

Thanks,

Marc

[agasthuri_doss]

Hi,

This will help in downloading JDBC Driver from Microsoft Website and Deploy the JDBC driver using SDM

http://www.microsoft.com/downloads/details.aspx?FamilyID=6D483869-816A-44CB-9787-A866235EFC7C&displa...

JDBC Driver Deployment Guide...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/70ffd890-0201-0010-708f-d5dad2df...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/bf4b1055-0d01-0010-32a3-b3848d77...

Regards

Agasthuri Doss

[Former Member]

Hi Agasthuri,

I have deployed all the three sql server jars in j2ee server, but still I am getting following error.

Error during database connection to the database URL 'jdbc:microsoft:sqlserver://xxxx:1433;DatabaseName=wmData' using the JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver': 'com.sap.aii.adapter.jdbc.sql.DriverManagerException: Cannot establish connection to URL 'jdbc:microsoft:sqlserver://xxxx:1433;DatabaseName=wmData': SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver'

what could the reason?

[agasthuri_doss]

Hi,

Thin client or thick client

Tru to get the drivers from the receiver system team and deploy. The driver you have deployed does not support the receiver system. Required class file is missing.

Regards

Agasthuri Doss

[Former Member]

Hi Agasthuri,

thansk for prompt reply.I check the driver on my server and i think i am missing one jar file..

I have three jars .

util.jar, sqlserver.jar,base.jar..

is these correct ..

there is not mssqlserver.jar file .. If I am not wrong then this jar is required .

I have mssqlserver.jar with me on my system (local PC) and tried to check all the class files present in it . I found SQLServerDriver class file there..

So is mssqlserver.jar is also required...?

[agasthuri_doss]

Hi,

>>So is mssqlserver.jar is also required...?

YES..

Let us know any issue further....

Shall i know thin or thick client.

Regards

Agasthuri Doss

[agasthuri_doss]

Hi,

Are you mentioning all the jar files in your provider xml file

Regards

Agasthuri Doss

[Former Member]

Hi Agasthuri,

I am not sure tht what does thin and thick mean?

As far as provider xml file is concerned , I have to check with my basis person. I will get back to you.

Thanks for your help.

[agasthuri_doss]

Hi,

>>As far as provider xml file is concerned , I have to check with my basis person

you are right..Basis team will be aware of that

Is the Database is in the same network of XI system ?

We can say as Thick client - intranet.

Regards

Agasthuri Doss

[Former Member]

yes Database is in the same network as XI.

[Former Member]

Hi Ranjeet,

You must have done this but just again check if you have given correct SQL username / password . You get same error if username/password is wrong.

Nilesh

[agasthuri_doss]

Hi,

From the Receiver Business get the Drivers with thick client and try it out.

Regards

Agasthuri Doss