jdbc sender error

[former_member745782]

hello everybody!

I configured a interface jdbc-PI-RFC

when i start the Communication Channel i have the follow error:

The JDBC driver returned the following error message: 'java.sql.SQLException: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Invalid column name '0'.'. For details, contact your database server vendor.

maybe the problem is in drivers? the DB is SQL server 2005 but drivers are for 2000.

It's strange because i have some channells writing in same DB without problem.

any suggestion?

[former_member184681 · Accepted solution]

Hi,

See a similar thread here: . The solution there was that the ESR structure was incorrect. Make sure it is correct in your case.

Moreover, if you are using PI 7.3, here is another similar thread: and the problem was solved there by implementing the OSS Note 1639993 (Supporting additional datatypes in PI 730 JDBC adapter).

Hope this helps,

Greg

[baskar_gopalakrishnan2]

> any suggestion?

In addition to drivers issue, You might want to check the name of the field elements in jdbc structure that matches the column names of the database table. If any conflicts or case issues, this could cause invalid column name errors. Please check that too ..

[former_member745782]

I tried but the structures are identical!

I notify that also the import structure from ESR don't work. So maybe is a driver problem

I want install the driver for SQL server 2005 but i afraid about conflict with other databases (i have other interfaces versus a SQL server 2000)