JDBC driver for SQL

[Former Member]

Hi experts,

I'm connecting with a SQL Data base. I don't know if my JDBC adapter is properly configured. I'm working with <b>SQL Server 2000 SP3a WINDOWS 2000 Advanced Server SP4 </b>. Do you know wich is the correct configuration for the parameters '<b>Driver</b>' and '<b>Connection</b>'?

Regards

Gonzalo

[Former Member]

I tried with:

<b>URL:</b> jdbc:sqlserver://<host>[:<port1433>];databaseName=<database>

<b>Driver:</b> com.microsoft.sqlserver.jdbc.SQLServerDriver

more or less what you recommended.Taken th drivers from here:

http://www.minq.se/products/dbvis/drivers.html

It's explained too in a post here:

We've already installed the drivers but it doesn't work we receive this error:

- 2007-09-27 17:58:42 CEST: Error: Accessing database connection 'jdbc:sqlserver://EMECRW501PRE:1433;DatabaseName=INFCONTA' failed: DriverManagerException: Cannot establish connection to URL 'jdbc:sqlserver://EMECRW501PRE:1433;DatabaseName=INFCONTA': SAPClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

We're checking the driver instalation. Thank you both for your help.

Regards

Gonzalo

[Former Member]

Ah! If anybody have any idea about what's wrong with the driver it would be wonderful...

[Former Member]

This error message may also appear if the IP connection to the database is not possible or not allowed. Did you check IP routing/DNS and firewall settings if a firewall is present?

Sorry, I was wrong, did not read the end of the error message. That rather points to the driver.

Message was edited by:

Rolf Micus

[Former Member]

I had the same problem!! This error is because the JDBC drivers are not properly deploy in the XI SAP J2EE engine. I had our basic (Technical Consultant) install the driver and now it work perfectly.

[nisarkhan_n]

I hope the required driver file is already deployed in XI.

for conection parameter try this

Example

SQL-Server-Name: PC1

Instance: Inst1

URL: jdbc:sqlserver://PC1\Inst1:<port>;databaseName=< db_name>

or checkt think link

[Former Member]

Sender JDBC-

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

JDBC Receiver Adapter -- Synchronous Select – Step by Step

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

Receiver JDBC scenario MS access -

/people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

Stored Procedures-

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

Regards,

Sreenivas