logo

Notification

Icon
Error

Options
Go to last post Go to first unread
Offline Soon Ling Chua  
#1 Posted : Monday, September 5, 2016 8:12:17 PM(UTC)
Soon Ling Chua

Rank: Newbie

Joined: 6/12/2016(UTC)
Posts: 9

Was thanked: 2 time(s) in 2 post(s)
Hi,

I have download Matrikon Desktop Historian and install in Windows 2012 R2.
But I encounter problem Matrikon ODBC Server for HDA which auto install & configure during Desktop historian installation not able to connect to Desktop Historian.

when try the ODBC Connection in server, it throw RDA Error


[TID: 720], ewoprint.c:73: **********************************************************************
[TID = 720]:SQLAllocEnv called:
phenv=044E569C
[TID = 720]:SQLAllocEnv: returns SQL_SUCCESS
*phenv=007D9380
[TID = 720]:SQLAllocConnect called:
henv=007D9380
phdbc=044E5688
SQLAllocConnectOnThread: called
SQLAllocConnectOnThread: return with: 0
[TID = 720]:SQLAllocConnect: returns SQL_SUCCESS
*phdbc=00805300
[TID = 720]:SQLGetInfo called:
hdbc=00805300
fInfoType=SQL_DRIVER_ODBC_VER
rgbInfoValue=044E5948
cbInfoValueMax=12
pcbInfoValue=0491F5E4
[TID = 720]:SQLGetInfo: returns SQL_SUCCESS
pcbInfoValue=5
[TID = 720]:SQLSetConnectOption called:
hdbc=00805300
fOption=1203
vParam=1
[TID: 720], ewoopts.c:591: SQLSetConnectOption(Option=1203): Driver not capable
[TID = 720]:SQLSetConnectOption: returns SQL_ERROR
[TID: 720], ewodata.c:244: SQLState=S, ErrorMsg=D
[TID = 720]:SQLConnect called:
[TID = 720]:SQLConnectW called:
hdbc=00805300
wszDSN=
Desktop Historian
cbDSN=17
wszUID=
***
cbUID=SQL_NTS
wszAuthStr=
***
cbAuthStr=SQL_NTS
<UNICODE>[TID: 720], \openodbc\src\ewocomm.c:4280: OaValidateODBCProductNameLic() called to validate license for DSN=<Desktop Historian>
<UNICODE>[TID: 720], \openodbc\src\ewoconn.c:429: Looking for Custom connect property string for DSN=Desktop Historian
[TID: 720], ewoconn.c:451: SQLGetPrivateProfileStringW return 0 for Custom connect property string
<UNICODE>[TID: 720], \openodbc\src\ewoconn.c:487: pwcSRV=Desktop Historian
[TID: 720], ewoconn.c:488: pcSRV=Desktop Historian

<UNICODE>[TID: 720], \openodbc\src\ewoconn.c:2667: OaSetExtendedFunctionsOption=0xf
[TID = 720]:SQLConnectW:returns SQL_ERROR
[TID: 720], ewodata.c:298: SQLState=H, ErrorMsg=R
[TID = 720]:SQLConnect returns:SQL_ERROR
[TID = 720]:SQLErrorW called:
henv=<NULL>
hdbc=00805300
hstmt=<NULL>
szSqlState=0491AFB8
pfNativeError=0491F068
wszErrorMsg=0491AFC4
cbErrorMsgMax=8192
pcbErrorMsg=0491F058
[TID: 720], eworesu.c:1215: SQLErrorW: rda_cliError() returns.
[TID = 720]:SQLErrorW: returns SQL_SUCCESS
szSqlState=HZ080
pfNativeError=0
szErrorMsg=
[DataDirect][OpenAccess ODBC]RDA error: Resource not available - Failed connecting to the database. Make sure the database is configured correctly.
pcbErrorMsg=147
[TID: 720], ewocomm.c:2120: SQLError Returns: ErrorMsg([DataDirect][OpenAccess ODBC]RDA error: Resource not available - Failed connecting to the database. Make sure the database is configured correctly.), SqlState(HZ080)
[TID = 720]:SQLErrorW called:
henv=<NULL>
hdbc=00805300
hstmt=<NULL>
szSqlState=0491AFB8
pfNativeError=0491F068
wszErrorMsg=0491AFC4
cbErrorMsgMax=8192
pcbErrorMsg=0491F058
[TID: 720], eworesu.c:1215: SQLErrorW: rda_cliError() returns.
[TID = 720]:SQLErrorW: returns SQL_NO_DATA
szSqlState=00000
pfNativeError=0
szErrorMsg=

pcbErrorMsg=0
[TID: 720], ewocomm.c:2120: SQLError Returns: ErrorMsg(À), SqlState(hð‘  Ëoîij5ö‘TAÉo)
[TID = 720]:SQLErrorW called:
henv=<NULL>
hdbc=00805300
hstmt=<NULL>
szSqlState=04918C40
pfNativeError=0491CCE4
wszErrorMsg=04918C4C
cbErrorMsgMax=8192
pcbErrorMsg=0491CCEC
[TID: 720], eworesu.c:1215: SQLErrorW: rda_cliError() returns.
[TID = 720]:SQLErrorW: returns SQL_NO_DATA
szSqlState=00000
pfNativeError=0
szErrorMsg=

pcbErrorMsg=0
[TID: 720], ewocomm.c:2120: SQLError Returns: ErrorMsg(À), SqlState(äÌ‘4Í‘fUj5Ñ‘Èo)
[TID = 720]:SQLFreeConnect called:
hdbc=00805300
[TID = 720]:SQLFreeConnect: returns SQL_SUCCESS
[TID = 720]:SQLFreeEnv called:
henv=007D9380
[TID = 720]:SQLFreeEnv: returns SQL_SUCCESS
[TID: 720], ewoinit.c:175: TID = 720 ***************************DLL_PROCESS_DETACH***************************
thanks 1 user thanked Soon Ling Chua for this useful post.
Offline Roger Fortune  
#2 Posted : Monday, September 5, 2016 8:16:11 PM(UTC)
Roger Fortune

Rank: Advanced Member

Joined: 10/21/2014(UTC)
Posts: 105

Was thanked: 35 time(s) in 32 post(s)
Matrikon ODBC Server for OPC was not designed for Windows Server 2012 R2. Please contact support@matrikonopc.com to discuss the best path forward.
thanks 1 user thanked Roger Fortune for this useful post.
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Matrikon Subscribe  |   Matrikon Unsubscribe  |   Global Unsubscribe  |   Privacy Statement  |   Do Not Sell My Personal Information   |   Cookie Notice