Hi,
I just installed the latest version FSQL & FPMI.
I’m having problems with my SQLTags. I’m running MS SQL 2008 Express and everything is running fine except for the SQLTag Provider. Right now under the SQLTags Status under Gateway Status I get the following Error below.
This is affecting my FactoryPMI because I’m not able to see my OPC server in the OPC browser in it.
I’m using RSLinx Classic Gateway version v2.52.00 (CPR 9).
I have FactorySQL Configured just as shown in the help file.
Thanks for the help,
famador
Message: (hide details)
[Microsoft][ODBC SQL Server Driver]Invalid Descriptor Index
Details:
SQLException
sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(Unknown Source)
sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(Unknown Source)
sun.jdbc.odbc.JdbcOdbcResultSet.getString(Unknown Source)
org.apache.commons.dbcp.DelegatingResultSet.getString(DelegatingResultSet.java:175)
com.inductiveautomation.factorypmi.gateway.sqltags.db.DatasourceTagProvider.createFromResultSet(DatasourceTagProvider.java:3144)
com.inductiveautomation.factorypmi.gateway.sqltags.db.DatasourceTagProvider.access$2000(DatasourceTagProvider.java:87)
com.inductiveautomation.factorypmi.gateway.sqltags.db.DatasourceTagProvider$PollingThread.loadScanClasses(DatasourceTagProvider.java:4060)
com.inductiveautomation.factorypmi.gateway.sqltags.db.DatasourceTagProvider$PollingThread.run(DatasourceTagProvider.java:3303)
java.lang.Thread.run(Unknown Source)