Skip to Content
author's profile photo
Former Member

JDBC driver for SQL

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • author's profile photo
    Former Member
    Posted on Sep 28, 2007 at 10:48 AM

    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:

    sap-xi-adapter-jdbc-error-during-database-connecti

    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

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member 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.

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 10:55 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 27, 2007 at 11:23 AM

    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

    JDBC connection to DB2 Database

    Add comment
    10|10000 characters needed characters exceeded