on 02-27-2012 4:29 PM
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?
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
> 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 ..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.