OpenLink Lite ODBC Connection Not Open 08003

pmj · June 15, 2023, 2:30pm

Good day!
We just enrolled an existing MacOS client (12.6.6) into Workspace One UEM. Before the enrollment everything worked fine with the ODBC connection with Openlink, afterwards we are getting messages like “08003 Connection not open”, although the ODBC tests says, the connection is OK. Also “nc -v” to the MSSQL server with 1433 says, that the connection is successful

Do you any steps how to debug this problem? I know, the enrollment in Workspace One seems as the nearest reason, but why do the connection tests work on the other hand, but the connection to a specific database won’t?

OpenLink driver: OpenLink SQL Server Lite (Unicode) v8.0 …version 08.00.211105
MacOS 12.6.6

Thanks in advance for any hints!

Kind regards,
PMJ

hwilliams · June 15, 2023, 8:53pm

I don’t understand what you mean by but why do the connection tests work on the other hand, but the connection to a specific database won’t, as a “test” connection is also connecting to the database, that being the only thing our ODBC driver does ie connect to databases ?

I presume this is the Workspace One UEM product you are referring, which if that is the only thing installed after which the connections stop working, must be the cause ?

You can obtain ODBC and TDS trace logs of the connection attempts being made to the database which may shed some light on why the connections are failing if they are getting that far.

What is the ODBC application being used in this case, that is giving the “08003 Connection not open” error, which does not look like an ODBC error and so I assume is application specific ? Have you attempted to make an ODBC connection with the iODBC Test sample program we provide ?

pmj · June 16, 2023, 7:23am

Good morning!
I don’t know the exact wording, as I debugged with a colleague yesterday and I don’t have access to the ODBC administration tool. But as I remember, there was a connection test during the setup of the ODBC connection and that one said “Connection successful”, and afterwards we made connection test with a specific user to the DB (which can be be done in the administration tool too, but I can’t remember the exact words), and then we got error “Connection not open”

I cannot really tell if the enrollmen in UEM is the root cause, but yes, it is probably.
The application in the where ODBC is connecting to is just simply an MSSQL server.

We did already some tests yesterday, but I’m not an expert when it comes to debug SQL… I was hoping, I would probably get some hints here where to investigate further

Here is a trace we did yesterday. If interpret it correctly, the connection to MSSQL server is working, but something afterwards not.

** iODBC Trace file
** Trace started on Thu Jun 15 15:44:33 2023
** Driver Manager: 03.52.1521.0705

[000000.000373]
iODBC Administr 117C56600 ENTER SQLAllocHandle
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x7ff7b1141218

[000000.000397]
iODBC Administr 117C56600 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x7ff7b1141218 (0x600002579950)

[000000.000420]
iODBC Administr 117C56600 ENTER SQLSetEnvAttr
SQLHENV 0x600002579950
SQLINTEGER 1064 (unknown environment attribute)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)

[000000.000446]
iODBC Administr 117C56600 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x600002579950
SQLINTEGER 1064 (unknown environment attribute)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)

[000000.000472]
iODBC Administr 117C56600 ENTER SQLSetEnvAttr
SQLHENV 0x600002579950
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)

[000000.000498]
iODBC Administr 117C56600 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x600002579950
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)

[000000.000523]
iODBC Administr 117C56600 ENTER SQLAllocHandle
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHANDLE 0x600002579950
SQLHANDLE * 0x7ff7b1141210

[000000.000550]
iODBC Administr 117C56600 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHANDLE 0x600002579950
SQLHANDLE * 0x7ff7b1141210 (0x7f816af077a0)

[000000.000575]
iODBC Administr 117C56600 ENTER SQLDriverConnectW
SQLHDBC 0x7f816af077a0
SQLPOINTER 0x1
SQLWCHAR * 0x7ff7b1145220
SQLSMALLINT -3 (SQL_NTS)
SQLWCHAR * 0x7ff7b1141220
SQLSMALLINT 4096
SQLSMALLINT * 0x7ff7b114120e
SQLUSMALLINT 2 (SQL_DRIVER_PROMPT)

[000030.896701]
iODBC Administr 117C56600 EXIT SQLDriverConnectW with return code 1 (SQL_SUCCESS_WITH_INFO)
SQLHDBC 0x7f816af077a0
SQLPOINTER 0x1
SQLWCHAR * 0x7ff7b1145220
SQLSMALLINT -3 (SQL_NTS)
SQLWCHAR * 0x7ff7b1141220
SQLSMALLINT 4096
SQLSMALLINT * 0x7ff7b114120e (0)
SQLUSMALLINT 2 (SQL_DRIVER_PROMPT)

[000030.896774]
iODBC Administr 117C56600 ENTER SQLError
SQLHENV 0x600002579950
SQLHDBC 0x7f816af077a0
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLCHAR * 0x7ff7b11401c1
SQLINTEGER * 0x0
SQLCHAR * 0x7ff7b11401d0
SQLSMALLINT 4096
SQLSMALLINT * 0x0

[000030.896833]
iODBC Administr 117C56600 EXIT SQLError with return code 0 (SQL_SUCCESS)
SQLHENV 0x600002579950
SQLHDBC 0x7f816af077a0
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLCHAR * 0x7ff7b11401c1
| 08003 |
SQLINTEGER * 0x0
SQLCHAR * 0x7ff7b11401d0
| [OpenLink][ODBC][Driver]Connection not o |
| pen |
SQLSMALLINT 4096
SQLSMALLINT * 0x0

[000034.164274]
iODBC Administr 117C56600 ENTER SQLError
SQLHENV 0x600002579950
SQLHDBC 0x7f816af077a0
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLCHAR * 0x7ff7b11401c1
SQLINTEGER * 0x0
SQLCHAR * 0x7ff7b11401d0
SQLSMALLINT 4096
SQLSMALLINT * 0x0

[000034.164364]
iODBC Administr 117C56600 EXIT SQLError with return code 100 (SQL_NO_DATA_FOUND)
SQLHENV 0x600002579950
SQLHDBC 0x7f816af077a0
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLCHAR * 0x7ff7b11401c1
SQLINTEGER * 0x0
SQLCHAR * 0x7ff7b11401d0
SQLSMALLINT 4096
SQLSMALLINT * 0x0

[000034.164416]
iODBC Administr 117C56600 ENTER SQLError
SQLHENV 0x600002579950
SQLHDBC 0x0 (SQL_NULL_HANDLE)
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLCHAR * 0x7ff7b11401c1
SQLINTEGER * 0x0
SQLCHAR * 0x7ff7b11401d0
SQLSMALLINT 4096
SQLSMALLINT * 0x0

[000034.164469]
iODBC Administr 117C56600 EXIT SQLError with return code 100 (SQL_NO_DATA_FOUND)
SQLHENV 0x600002579950
SQLHDBC 0x0 (SQL_NULL_HANDLE)
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLCHAR * 0x7ff7b11401c1
SQLINTEGER * 0x0
SQLCHAR * 0x7ff7b11401d0
SQLSMALLINT 4096
SQLSMALLINT * 0x0

[000034.164498]
iODBC Administr 117C56600 ENTER SQLFreeHandle
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHDBC 0x7f816af077a0

[000034.164512]
iODBC Administr 117C56600 EXIT SQLFreeHandle with return code -1 (SQL_ERROR)
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHDBC 0x7f816af077a0

[000034.164526]
iODBC Administr 117C56600 ENTER SQLFreeHandle
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHENV 0x600002579950

[000034.164539]
iODBC Administr 117C56600 EXIT SQLFreeHandle with return code -1 (SQL_ERROR)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHENV 0x600002579950

** Trace finished on Thu Jun 15 15:45:07 2023