AnsweredAssumed Answered

Why ODBC driver for PostgreSQL is not working when I use the option "TABLE LINK" on PI AF?

Question asked by Lowreno on Sep 21, 2015
Latest reply on Sep 23, 2015 by Lowreno

Hi folks,

 

   So, the ODBC driver for Postgre with Table LINK on PI AF just fails!

   I tried the version of ODBC driver 32 and 64 bits and got the error as below on event viewer.

 

   NOTE: It seems to be strange once I can use with success just the option Table IMPORT on PI AF.

 

    Does anyone have any idea what is happening ? Any thoughts / fix?

 

Thanks in advance,

 

Lowreno.

 

>>>>>> Error attached from event viewer:

Function System.String FillDataSetCommon(OSIsoft.AF.Service.CallContext, System.String, System.String, System.String, Boolean, Byte[], OSIsoft.AF.Service.dcTableColumnDef[], OSIsoft.AF.Service.dcTableParameter[], System.Collections.Generic.Dictionary`2[System.String,System.String], OSIsoft.AF.Service.dcServerError ByRef) at line: 0 in file

 

System.Data.Odbc.OdbcException (0x80131937): ERROR [IM014] [Microsoft][ODBC Driver Manager] O DSN especificado contém uma incompatibilidade de arquiteturas entre o Driver e o Aplicativo

   at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

   at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)

   at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)

   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)

   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)

   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

   at System.Data.Odbc.OdbcConnection.Open()

   at OSIsoft.AF.Service.AFService.CreateDataAdapter(CallContext callContext, String strDataAdapterType, String strConnection, String strCommand, Byte[]& password)

   at OSIsoft.AF.Service.AFService.FillDataSetCommon(CallContext callContext, String dataAdapterType, String connection, String command, Boolean impersonateUser, Byte[] encryptedPassword, dcTableColumnDef[] tableColumnDefs, dcTableParameter[] parameters, Dictionary`2 defaultParameters, dcServerError& err)

 

dcServerError state:

Operation =  0

ErrorNumber =  -2

Message =  ERROR [IM014] [Microsoft][ODBC Driver Manager] O DSN especificado contém uma incompatibilidade de arquiteturas entre o Driver e o Aplicativo

Procedure = 

ObjectType =  43

ID =  93459f41-ba04-40d7-a340-93ab02824d87

ObjectName =  Table11

SubObjectType =  0

User =  Unknown

LockedByUser =     at System.Data.Odbc.OdbcConnection.HandleError(OdbcHandle hrHandle, RetCode retcode)

   at System.Data.Odbc.OdbcConnectionHandle..ctor(OdbcConnection connection, OdbcConnectionString constr, OdbcEnvironmentHandle environmentHandle)

   at System.Data.Odbc.OdbcConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject)

   at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions)

   at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)

   at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)

   at System.Data.ProviderBase.DbConnectionInternal.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)

   at System.Data.Odbc.OdbcConnection.Open()

   at OSIsoft.AF.Service.AFService.CreateDataAdapter(CallContext callContext, String strDataAdapterType, String strConnection, String strCommand, Byte[]& password)

   at OSIsoft.AF.Service.AFService.FillDataSetCommon(CallContext callContext, String dataAdapterType, String connection, String command, Boolean impersonateUser, Byte[] encryptedPassword, dcTableColumnDef[] tableColumnDefs, dcTableParameter[] parameters, Dictionary`2 defaultParameters, dcServerError& err)

OtherObjectType =  0

OtherObjectName =  Unknown

OtherObjectID =  00000000-0000-0000-0000-000000000000

Outcomes