SQLTag™ Provider Status Problem

Archived Topics
1

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)

2

Please don’t use the JDBC-ODBC bridge to connect to MS SQL Server - use the actual SQL Server driver. For Express, you’ll need “instance=SQLEXPRESS;” in the “extra connection properties” for the connection.

3

I also followed the Video instruction help for MS SQL Express 2005 connection, and everything is working great.

Thanks for the help!