JDBC Sender

[Former Member]

Hi All,

I tried a JDBC-XI-File scenario.

In adapter monitoring I am getting this error.

Sender Adapter v0915 for Party '', Service 'BSR_JDBC':

Configured at 16:03:01 2006-08-01

Processing Error: Accessing database connection 'jdbc:microsoft:sqlserver://10.252.10.84:1433;databseName=cmgtdb' failed: java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC]Error establishing socket.

Addtional information: JDBC driver 'com.microsoft.jdbc.sqlserver.SQLServerDriver' loaded successfully, additional driver information:

Available JDBC drivers:

oracle.jdbc.driver.OracleDriver, 1.0 JDBC compliant

last retry interval started 16:24:22 2006-08-01

length 60,000 secs

Can any one tell me what this error means?

Thanks & Regards,

JaiShankar.

[sridharreddy_kondam · Accepted solution]

Hi Jai,

Have followed this Installation guide...

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

Go through each sep once and definitely it should work...

Look at this Thread which will be helpfull to u...

also Check this Thread which was solved with the answers from rajendar rawal

<b>/thread/46653 [original link is broken]

Thanks and Regards,

Sridhar

Message was edited by: sridhar reddy kondam

[Former Member]

Hi Jai,

Can u pls mention the driver string u have used.

Try using the given string:

com.microsoft.jdbc.sqlserver.SQLServerDriver

Regards

Neetu

[Former Member]

Hi,

To use SQLServer we have to deploy the drivers . For deployment please refer to the link

http://help.sap.com/saphelp_nw2004s/helpdata/en/33/e6fb40f17af66fe10000000a1550b0/content.htm

[Former Member]

Hi,

Please make sure that the database name you have given is correct. Check with the case also.

Regards,

Sudheer.

[Former Member]

Hi All,

Thanks for all your effort. The problem was the XI server could not access the specified database.

I tried with a different database server and now my scenario works perfectly fine.

Thanks & Regard,

Jai Shankar.

[Former Member]

Hi Jai,

Try using the Connection String mentioned below:

jdbc:microsoft:sqlserver:@10.252.10.84:1433:cmgtdb

You also need to add the following Jar files:

Microsoft SQL : msbase.jar, mssqlserver.jar, msutil.jar

To do so follow the instructions provided in the given link:

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

Hopefully this works.

Regards

Neetu

[Former Member]

Hi Neetu,

I tried with that connection string.

The error I get in adapter monitoring is Invalid URL.

The jar files are already deployed.

Any thing else I have to look into?

Thanks & Regards,

Jai Shankar.

[Former Member]

Hi Jai,

Check this thraed...

sekhar

[Former Member]

Hi ,

try with this...

<i>jdbc:microsoft:sqlserver://10.252.10.84:1433;databseName=cmgtdb</i>

jdbc:microsoft:sqlserver://10.252.10.84:1433;DatabaseName=cmgtdb

Thanks,

Sekhar