JDBC Communication channel error

[Former Member]

Hi All,

I am facing a problem with JDBC channel.

We have depolyed the New JDBC driver called SQLSERVER2005 and also in JDBC channel i have changed to the server name and port, because we have new server details now.

But still channel is getting into error

Following are my observations:-

1) I can see in the error log of these channels its still continuing to poll in SQL Server 2000 version (though it is updated to SQL 2005).

2) When i see in the CC monitoring it is giving the login error

Let me know if anything should be changed in this direction.

Please dont give me any links, kindly suggest me your solutions.

Regards

Sai Ganesh

[Former Member]

Hi Ganesh,

Specify the connection parameters as given below

Jdbc Driver : com.microsoft.sqlserver.jdbc.SQLServerDriver

Connection: jdbc:sqlserver://ip address of databasehost:1433;databaseName=name of your database

Regards

Leela

[Former Member]

kindly cross check ur database connection parameters in JDBC cc

[dharamveer_gaur2]

Hi

Are u using sqljdbc.jar is the new SQL Server 2005 jdbc driver.

Driver and Url would be diffrent.

com.microsoft.sqlserver.jdbc.SQLServerDriver

jdbc:sqlserver://host:1433;DatabaseName=name

[Former Member]

...and just du be sure make an manually cache refresh.

regards, björn

[Former Member]

Hi,

1. Check your connection string in communication channel

2. Confirm from Basis, about driver version

3. Then restart the XI server.

Regards