JDBC Driver

[Former Member]

Hi All,

I am creating an IDoc to JDBC scenario.The DB which I am using is SQL Server.I have got the JAR file from the DB guy and asked our Basis consultant to deploy it on the XI server.So he is on this.

So after deploying the JAR file ,what should I give for the following ,in the communication channel,

JDBC Drive : ?????

Connection : ?????

My DB guy has given me the following details,

1. Database Driver Class Name - com.inet.tds.TdsDriver

2. JDBC Connection URL - jdbc:inetdae7://<DB_HOST_NAME>:1433;DatabaseName=<DB_NAME>

So should I give,

JDBC Drive : com.inet.tds.TdsDriver

Connection : jdbc:inetdae7://<DB_HOST_NAME>:1433;DatabaseName=<DB_NAME>

Correct me if I am wrong ,else where should I check on the XI server ,to get the write values?

Suggestions would be really appreciated.

Thanks,

Venu

[Shabarish_Nair · Accepted solution]

> 
> JDBC Drive : ?????
> Connection : ?????
> 
> My DB guy has given me the following details,
> 1. Database Driver Class Name - com.inet.tds.TdsDriver
>  2. JDBC Connection URL - jdbc:inetdae7://<DB_HOST_NAME>:1433;DatabaseName=<DB_NAME>
> 
> So should I give,
> 
> JDBC Drive : com.inet.tds.TdsDriver
> Connection : jdbc:inetdae7://<DB_HOST_NAME>:1433;DatabaseName=<DB_NAME>
> Venu

The parameters vary depending on the vendor. The vendor being different will have different drivers. Ref, below.

http://www.newfire.com/newfire/open/DMFolder/html/doc/config/driver.html

Best is to consult your DB admin and extract the details and provide them in the CC configuration.

[former_member206760]

give,

jdbc driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

connection : jdbc:sqlserver//<database host name>:1433;DatabaseName=<database name>