on 05-23-2015 10:06 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
9 | |
9 | |
7 | |
7 | |
6 | |
6 | |
6 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.