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