Agentry Application Showing error while running on Client

[former_member337066]

AK K's Profile | SCN

Chandra Ayyagari's Profile | SCN

Hello

                    We developed one Agentry application with name Field. We are using oracle back-end.We created ODBC connection as below:-

But while running application on client it showing below error

So how can i resolve this issue. In events.log it showing

connect identifier specified

, sqlBE.cpp#1411:DbConnectionPoolMgr::create

05/23/2015 11:23:52, 1,        16,      101, Thr      4736, 3: SA_DBMS_API_Error, DB Code: 12154, DB Text:ORA-12154: TNS:could not resolve the connect identifier specified

, sqlBE.cpp#1411:DbConnectionPoolMgr::create

05/23/2015 11:23:53, 1,        16,      101, Thr      4736, 3: SA_DBMS_API_Error, DB Code: 12154, DB Text:ORA-12154: TNS:could not resolve the connect identifier specified

, sqlBE.cpp#1411:DbConnectionPoolMgr::create

05/23/2015 11:23:54, 1,        16,      101, Thr      4736, 3: SA_DBMS_API_Error, DB Code: 12154, DB Text:ORA-12154: TNS:could not resolve the connect identifier specified

, sqlBE.cpp#1411:DbConnectionPoolMgr::create

05/23/2015 11:23:55, 1,        16,      101, Thr      4736, 3: SA_DBMS_API_Error, DB Code: 12154, DB Text:ORA-12154: TNS:could not resolve the connect identifier specified

, sqlBE.cpp#1411:DbConnectionPoolMgr::create

05/23/2015 11:23:56, 1,        16,      101, Thr      4736, 3: SA_DBMS_API_Error, DB Code: 12154, DB Text:ORA-12154: TNS:could not resolve the connect identifier specified

, sqlBE.cpp#1411:DbConnectionPoolMgr::create

05/23/2015 11:23:57, 1,        16,      101, Thr      4736, 3: SA_DBMS_API_Error, DB Code: 12154, DB Text:ORA-12154: TNS:could not resolve the connect identifier specified

, sqlBE.cpp#1411:DbConnectionPoolMgr::create

05/23/2015 11:23:58, 1,        16,      101, Thr      4736, 3: SA_DBMS_API_Error, DB Code: 12154, DB Text:ORA-12154: TNS:could not resolve the connect identifier specified

, sqlBE.cpp#1411:DbConnectionPoolMgr::create

05/23/2015 11:23:59, 1,        16,      101, Thr      4736, 3: SA_DBMS_API_Error, DB Code: 12154, DB Text:ORA-12154: TNS:could not resolve the connect identifier specified

, sqlBE.cpp#1411:DbConnectionPoolMgr::create

05/23/2015 11:24:00, 1,        16,      101, Thr      4736, 3: SA_DBMS_API_Error, DB Code: 12154, DB Text:ORA-12154: TNS:could not resolve the connect identifier specified

, sqlBE.cpp#1411:DbConnectionPoolMgr::create

05/23/2015 11:24:01, 1,        16,      101, Thr      4736, 3: SA_DBMS_API_Error, DB Code: 12154, DB Text:ORA-12154: TNS:could not resolve the connect identifier specified

, sqlBE.cpp#1411:DbConnectionPoolMgr::create

05/23/2015 11:24:02, 1,        16,      101, Thr      4736, 3: SA_DBMS_API_Error, DB Code: 12154, DB Text:ORA-12154: TNS:could not resolve the connect identifier specified

, sqlBE.cpp#1411:DbConnectionPoolMgr::create

05/23/2015 11:24:03, 1,        16,      101, Thr      4736, 3: SA_DBMS_API_Error, DB Code: 12154, DB Text:ORA-12154: TNS:could not resolve the connect identifier specified

, sqlBE.cpp#1411:DbConnectionPoolMgr::create

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Agentry.ini File content is as below:-

[System Connections]

1=ag3sqlbe.dll

[Configuration]

apnsCertificateDirectory=apnsCertificates

apnsCertificatePassword=Rzdrj~SwixoAqzmbVxgi

apnsCertificatePasswordEncoded=True

apnsEnabled=True

applicationGlobalsFile=Globals.ini

applicationStringsFile=ApplicationText.ini

clientStringNamesFile=ClientStringNames.ini

clientStringsFile=ClientText.ini

developmentServer=True

enableFailedTransactionLogging=True

enableOverrideFile=Enables.ini

enableTransactionFailureHandling=False

failedTransactionFilenameFormat=%{userid} %{transaction_name} %{date} %{time}-%{count}.xml

failedTransactionsQueue=FailedTransactionsQueue

gcmEnabled=True

gcmServerAuthorizationKey=Authorization:key=AIzaSyDi0qWQEewdbmNSV_o9QNtSQrlxPnBXtBM

gcmServerLink=https://android.googleapis.com/gcm/send

imagesPath=Application\Development\Images

localizationPath=

localizations=

overrideInfoTableDirectory=OverrideInfoTable

overrideTypesFile=OverrideTypes.ini

scriptsPath=Application\Development\Scripts

spinDocIniFile=

threadCount=0

transmitConfigurationFile=TransmitConfigurations.ini

trustedCertificateStore=

updateIdleWait=60

updatePeriod=60

urlPath=FIELD

[SpinDoc]

facePath=sql\custom;sql

facepath=sql\custom;sql

[TimeZoneAlias]

[SQL-1]

allowUserToChangePassword=True

autoDequote=True

dbConnectionName=COMM

dbConnectionPassword=coms

dbConnectionPasswordEncoded=False

dbConnectionType=ODBC

dbConnectionUserID=COMS

disconnectFromDB=False

disconnectTime=0:59:0

enableAuthentication=True

enablePreviousUserAuthentication=True

name=SQL Back End

prefetchRows=1000

preloadQueryInitFile=False

queryConstantFiles=SqlServer_sd.ini

queryInitFile=SqlBE.ini

reconnectTime=1:59:0

sharedConnections=0

timeZoneName=

useUserDBAuthConnection=True

[LastUpdates]

System Connections=17:6:54 5/22/2015

SQL-1=16:49:44 5/22/2015

Configuration=16:49:44 5/22/2015

SpinDoc=16:49:44 5/22/2015

TimeZoneAlias=16:49:44 5/22/2015

[Former Member]

For Oracle DB's connections, Setup an Oracle client on the machine ( same bit level as your server)   Setup the TNSnames.ora file to connect database server.

Test the connection with TNSping.

In the SQL-1 section set "dbConnectionType" to Orcale

and "queryConstantFiles" to Orcale_sd.ini

" dbConnectionName" to the name of the section in the TNSname file.

Local Naming Parameters (tnsnames.ora)