Hello,
I have installed PostgreSQL 15.3 ODBC driver 8.0, but it fails to connect to the PostgreSQL. This is the error I am getting:
**08003**
[OpenLink][ODBC][Driver]Connection not open
Interesting is that when I try to “test” the connection during the DSN setup it says “successful” (see screenshot below).
Do you know what might be wrong?
I also tried (to exclude problem with DB I am connecting to) running PostgreSQL version 12.x locally and connecting to this DB. The connection worked, but when I connect to the DB using Excel, I cannot see any data, or when I run the query that returns data in pgadmin, it doesn’t in Excel.
I am including the debug logs:
** OpenLink ODBC Trace file for iODBC Administrator64 **
Driver: 08.00.211105 OpenLink PostgreSQL Lite Driver
connStr=[DSN]
key=[DSN] data=[debug log 2] supplied=1
key=[DRIVER] data=[/Library/ODBC/OpenLink PostgreSQL Lite ODBC Driver (Unicode) v8.0.bundle/Contents/MacOS/pgr7_mt_lu.so] supplied=1
key=[UID] data=[<redacted>] supplied=1
key=[DATABASE] data=[<redacted db name>] supplied=1
key=[OPTIONS] data=[-H <redacted host address> -P <redacted port> --ssl-mode DISABLED] supplied=1
key=[READONLY] data=[No] supplied=1
key=[DLF] data=[No] supplied=1
key=[FBS] data=[60] supplied=1
key=[NOAC] data=[No] supplied=1
key=[MAXROWS] data=[0] supplied=1
key=[INITSQL] data=[SELECT * FROM <redacted table name> LIMIT 10] supplied=1
key=[NLB] data=[No] supplied=1
key=[CURSOR_SENSITIVITY] data=[Low] supplied=1
key=[SQLDBMS] data=[] supplied=0
key=[MASE] data=[Yes] supplied=1
key=[HSODBC_FIX] data=[No] supplied=1
key=[IV] data=[No] supplied=1
key=[IA] data=[No] supplied=1
key=[JET] data=[No] supplied=1
key=[OPL_DEBUGFILE] data=[/Users/mcimerman/Desktop/debug log 2.log] supplied=1
key=[NRSSL] data=[No] supplied=1
key=[WideAsUTF16] data=[No] supplied=1
cn_svtype=[PostgreSQL]
cn_dbpath=[<redacted>]
cn_dbopts=[-H <redacted host address> -P <redacted port> --ssl-mode DISABLED]
cn_readonly=0
cn_fetchSize=60
cn_deferLongFetch=0
cn_jetfix=0
cn_noautocommit=0
cn_norowsetsizelimit=0
cn_maxrows=0
cn_appname=[iODBC Administrator64]
cn_sqldbmsname=[]
SetLiteEnvironment: ServerType = PostgreSQL
SetLiteEnvironment: inifile = [openlink.ini]
ConnOpen: Unable to allocate connection handle
[20239E240] SQLDriverConnect: returning SQL_SUCCESS_WITH_INFO
[20239E240] SQLGetInfoW hDbc=20000
fInfoType=23 rgbInfoValue=7FDC21A064A8 cbInfoValueMax=2 pcbInfoValue=0
[20239E240] SQLGetInfoW: returning SQL_ERROR
[20239E240] SQLGetInfoW hDbc=20000
fInfoType=24 rgbInfoValue=7FDC21A064AA cbInfoValueMax=2 pcbInfoValue=0
[20239E240] SQLGetInfoW: returning SQL_ERROR
[20239E240] SQLGetDiagRecW hDbc=20000
RecNumber=1, SqlState=308609198, NativeErrorPtr=0, MessageText=7FDC22824A00, BufferLength=16384, TextLengthPtr=0
returning [OpenLink][ODBC][Driver]Connection not open
[20239E240] SQLGetDiagRecW: returning SQL_SUCCESS
[20239E240] SQLGetDiagRecW hDbc=20000
RecNumber=2, SqlState=308609198, NativeErrorPtr=0, MessageText=7FDC5199C200, BufferLength=16384, TextLengthPtr=0
[20239E240] SQLGetDiagRecW: returning SQL_NO_DATA_FOUND
And also tracing logs:
** iODBC Trace file
** Trace started on Wed Jun 19 16:22:59 2024
** Driver Manager: 03.52.1521.0705
[000000.000618]
iODBC Administr 20239E240 ENTER SQLAllocHandle
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x30860a4e8
[000000.000659]
iODBC Administr 20239E240 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x30860a4e8 (0x600002044690)
[000000.000697]
iODBC Administr 20239E240 ENTER SQLSetEnvAttr
SQLHENV 0x600002044690
SQLINTEGER 1064 (unknown environment attribute)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)
[000000.000741]
iODBC Administr 20239E240 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x600002044690
SQLINTEGER 1064 (unknown environment attribute)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)
[000000.000782]
iODBC Administr 20239E240 ENTER SQLSetEnvAttr
SQLHENV 0x600002044690
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)
[000000.000824]
iODBC Administr 20239E240 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x600002044690
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)
[000000.000865]
iODBC Administr 20239E240 ENTER SQLAllocHandle
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHANDLE 0x600002044690
SQLHANDLE * 0x30860a4e0
[000000.000935]
iODBC Administr 20239E240 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHANDLE 0x600002044690
SQLHANDLE * 0x30860a4e0 (0x7fdc21a063d0)
[000000.000988]
iODBC Administr 20239E240 ENTER SQLDriverConnectW
SQLHDBC 0x7fdc21a063d0
SQLPOINTER 0x1
SQLWCHAR * 0x30860e4f0
SQLSMALLINT -3 (SQL_NTS)
SQLWCHAR * 0x30860a4f0
SQLSMALLINT 4096
SQLSMALLINT * 0x30860a4de
SQLUSMALLINT 2 (SQL_DRIVER_PROMPT)
[000007.807507]
iODBC Administr 20239E240 EXIT SQLDriverConnectW with return code 1 (SQL_SUCCESS_WITH_INFO)
SQLHDBC 0x7fdc21a063d0
SQLPOINTER 0x1
SQLWCHAR * 0x30860e4f0
SQLSMALLINT -3 (SQL_NTS)
SQLWCHAR * 0x30860a4f0
SQLSMALLINT 4096
SQLSMALLINT * 0x30860a4de (0)
SQLUSMALLINT 2 (SQL_DRIVER_PROMPT)
[000007.807795]
iODBC Administr 20239E240 ENTER SQLError
SQLHENV 0x600002044690
SQLHDBC 0x7fdc21a063d0
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLCHAR * 0x308609491
SQLINTEGER * 0x0
SQLCHAR * 0x3086094a0
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000007.808336]
iODBC Administr 20239E240 EXIT SQLError with return code 0 (SQL_SUCCESS)
SQLHENV 0x600002044690
SQLHDBC 0x7fdc21a063d0
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLCHAR * 0x308609491
| 08003 |
SQLINTEGER * 0x0
SQLCHAR * 0x3086094a0
| [OpenLink][ODBC][Driver]Connection not o |
| pen |
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000009.846802]
iODBC Administr 20239E240 ENTER SQLError
SQLHENV 0x600002044690
SQLHDBC 0x7fdc21a063d0
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLCHAR * 0x308609491
SQLINTEGER * 0x0
SQLCHAR * 0x3086094a0
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000009.847043]
iODBC Administr 20239E240 EXIT SQLError with return code 100 (SQL_NO_DATA_FOUND)
SQLHENV 0x600002044690
SQLHDBC 0x7fdc21a063d0
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLCHAR * 0x308609491
SQLINTEGER * 0x0
SQLCHAR * 0x3086094a0
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000009.847095]
iODBC Administr 20239E240 ENTER SQLError
SQLHENV 0x600002044690
SQLHDBC 0x0 (SQL_NULL_HANDLE)
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLCHAR * 0x308609491
SQLINTEGER * 0x0
SQLCHAR * 0x3086094a0
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000009.847183]
iODBC Administr 20239E240 EXIT SQLError with return code 100 (SQL_NO_DATA_FOUND)
SQLHENV 0x600002044690
SQLHDBC 0x0 (SQL_NULL_HANDLE)
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLCHAR * 0x308609491
SQLINTEGER * 0x0
SQLCHAR * 0x3086094a0
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000009.847240]
iODBC Administr 20239E240 ENTER SQLFreeHandle
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHDBC 0x7fdc21a063d0
[000009.847266]
iODBC Administr 20239E240 EXIT SQLFreeHandle with return code -1 (SQL_ERROR)
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHDBC 0x7fdc21a063d0
[000009.847296]
iODBC Administr 20239E240 ENTER SQLFreeHandle
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHENV 0x600002044690
[000009.847320]
iODBC Administr 20239E240 EXIT SQLFreeHandle with return code -1 (SQL_ERROR)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHENV 0x600002044690
** Trace finished on Wed Jun 19 16:23:09 2024
Hi @Matus_Cimerman,
We are currently looking into this matter as it appears there’s an authentication level issue between our ODBC Driver for PostgreSQL and PostgreSQL 15 database server instances.
What do you mean by installed PostgreSQL 15.3 ODBC driver 8.0 ? Is it that you downloaded the Lite Edition (Single-Tier) ODBC Driver Installer Archive for PostgreSQL 7.x, 8.x, 9.x, 10.x, 11.x and 12.x on macOS 11.x (Universal) and Higher and are trying connecting to a PostgreSQL 15.3 database instance ?
What authentication scheme is your PostgreSQL 15.3 database instance setup to use, which should be set in the pg_hba.conf file ?
With regards to your connection to PostgreSQL 12.x version that is not returning data in Excel:
- What is the Excel version being used ?
- What macOS hardware are you running on M1 silicon or Intel ?
- Can you query the database with the OpenLink sample iODBC Demo application
- If running on an M1 machine please refer to this OpenLink ODBC Driver and iODBC usage on Apple Silicon M1 machines which details some of the possible issues that can be encountered running universal binaries with applications like Excel which may not be universal etc
Sorry about the confusion regarding installation. I did install this Lite Edition ODBC Driver for PostgreSQL 7.x-12.x (Apple Silicon) from openlink website so it seems like it is the one you provided Lite Edition (Single-Tier) ODBC Driver Installer Archive for PostgreSQL 7.x, 8.x, 9.x, 10.x, 11.x and 12.x on macOS 11.x (Universal) and Higher.
To answer your questions
What authentication scheme is your PostgreSQL 15.3 database instance setup to use, which should be set in the pg_hba.conf file ?
This is my pg_hba.conf
host all all 0.0.0.0/0 md5
host all all ::/0 md5
local all all md5
host all all 127.0.0.1/32 md5
host all all ::1/128 md5
- What is the Excel version being used ?
Version 16.86 (24060916)
- What macOS hardware are you running on M1 silicon or Intel ?
Apple M1 Max
- Can you query the database with the OpenLink sample iODBC Demo application
I cannot.
Edit: I can retrieve data from PostgreSQL 12.x, but not from PostgreSQL 15.x
- If running on an M1 machine please refer to this OpenLink ODBC Driver and iODBC usage on Apple Silicon M1 machines which details some of the possible issues that can be encountered running universal binaries with applications like Excel which may not be universal etc
Looks like I have everything installed as it should be, so I am unsure whether I should follow some steps from the guide your provided.
Below I am also attaching screenshots from the iODBC administrator app
Are you saying can run queries with the iODBC Demo application against PostgreSQL 12.x but not PostgreSQL 15.x ? And if so does the iODBC Demo application at least connect to PostgreSQL 15.x or not ? If would be useful to see ODBC (iODBC and OpenLink) traces of the iODBC Demo connection/query attempts against PostgreSQL 15.x.
Correct. I can connect and retrieve data from PostgreSQL 12.x in the iODBC Demo app and Excel. On the other hand, I cannot connect to PostgreSQL 15.x either from the iODBC Demo app or Excel.
The traces I have shared are from trying to connect to the PostgreSQL 15.x using Excel.
The iODBC and OpenLink ODBC traces you provided are for the iODBC Administrator64 app which they clearly state, and not for Excel.
Also, why are you using the iODBC Administrator64 (Intel x64) app on an M1 machine, as I would expect you to be using the iODBC Administrator universal binary (M1 & Intel64) app enabling it to work with application build with either chip as detailed in the OpenLink ODBC Driver and iODBC usage on Apple Silicon M1 machines post ?
Is your Excel application a universal (M1 & Intel64) or M1 only or Intel64 only app ?
As you cannot connect with iODBC Demo to PostgreSQL 15.x , we would like to see the ODBC (iODBC and OpenLink) traces for such connection/query attempts, as requested previously.
Sorry I probably attached wrong trace file, but I tested everything - iODBC Application as well.
I am sending you the logs and trace files both from iODBC Demo Unicode app and also from Excel.
Excel logs
** OpenLink ODBC Trace file for Microsoft Excel **
Driver: 08.00.211105 OpenLink PostgreSQL Lite Driver
connStr=[DSN]
key=[DSN] data=[PROD Excel] supplied=1
key=[DRIVER] data=[/Library/ODBC/OpenLink PostgreSQL Lite ODBC Driver (Unicode) v8.0.bundle/Contents/MacOS/pgr7_mt_lu.so] supplied=1
key=[UID] data=[<redacted DB>] supplied=1
key=[DATABASE] data=[<redacted DB>] supplied=1
key=[OPTIONS] data=[-H <redacted IP> -P <redacted port> --ssl-mode DISABLED] supplied=1
key=[READONLY] data=[No] supplied=1
key=[DLF] data=[No] supplied=1
key=[FBS] data=[60] supplied=1
key=[NOAC] data=[No] supplied=1
key=[MAXROWS] data=[0] supplied=1
key=[INITSQL] data=[] supplied=0
key=[NLB] data=[No] supplied=1
key=[CURSOR_SENSITIVITY] data=[Low] supplied=1
key=[SQLDBMS] data=[] supplied=0
key=[MASE] data=[Yes] supplied=1
key=[HSODBC_FIX] data=[No] supplied=1
key=[IV] data=[No] supplied=1
key=[IA] data=[No] supplied=1
key=[JET] data=[No] supplied=1
key=[OPL_DEBUGFILE] data=[/Users/mcimerman/Desktop/PostgreSQL 15.3 iODBC testing.log] supplied=1
key=[NRSSL] data=[No] supplied=1
key=[WideAsUTF16] data=[No] supplied=1
cn_svtype=[PostgreSQL]
cn_dbpath=[<redacted DB>]
cn_dbopts=[-H <redacted IP> -P <redacted port> --ssl-mode DISABLED]
cn_readonly=0
cn_fetchSize=60
cn_deferLongFetch=0
cn_jetfix=0
cn_noautocommit=0
cn_norowsetsizelimit=0
cn_maxrows=0
cn_appname=[Microsoft Excel]
cn_sqldbmsname=[]
SetLiteEnvironment: ServerType = PostgreSQL
SetLiteEnvironment: inifile = [openlink.ini]
ConnOpen: Unable to allocate connection handle
[1E8914C00] SQLDriverConnect: returning SQL_SUCCESS_WITH_INFO
[1E8914C00] SQLGetInfoW hDbc=20002
fInfoType=23 rgbInfoValue=11B848948 cbInfoValueMax=2 pcbInfoValue=0
[1E8914C00] SQLGetInfoW: returning SQL_ERROR
[1E8914C00] SQLGetInfoW hDbc=20002
fInfoType=24 rgbInfoValue=11B84894A cbInfoValueMax=2 pcbInfoValue=0
[1E8914C00] SQLGetInfoW: returning SQL_ERROR
[1E8914C00] SQLGetInfoW hDbc=20002
fInfoType=13 rgbInfoValue=3F9120000 cbInfoValueMax=8200 pcbInfoValue=16BB96E72
[1E8914C00] SQLGetInfoW: returning SQL_ERROR
[1E8914C00] SQLGetInfoW hDbc=20002
fInfoType=29 rgbInfoValue=3F90B7800 cbInfoValueMax=8200 pcbInfoValue=16BB96E72
[1E8914C00] SQLGetInfoW: returning SQL_ERROR
[1E8914C00] SQLAllocStmt hDbc=20002
phstmt=3FBE8AAD8
[1E8914C00] SQLAllocStmt: returning SQL_ERROR
[1E8914C00] SQLDisconnect hDbc=20002
[1E8914C00] SQLDisconnect: returning SQL_ERROR
iODBC Demo Unicode logs
** OpenLink ODBC Trace file for iODBC Demo Unicode **
Driver: 08.00.211105 OpenLink PostgreSQL Lite Driver
connStr=[DSN]
key=[DSN] data=[PROD iODBC app] supplied=1
key=[DRIVER] data=[/Library/ODBC/OpenLink PostgreSQL Lite ODBC Driver (Unicode) v8.0.bundle/Contents/MacOS/pgr7_mt_lu.so] supplied=1
key=[UID] data=[<redacted DB>] supplied=1
key=[DATABASE] data=[<redacted DB>] supplied=1
key=[OPTIONS] data=[-H <redacted IP> -P <redacted port> --ssl-mode DISABLED] supplied=1
key=[READONLY] data=[No] supplied=1
key=[DLF] data=[No] supplied=1
key=[FBS] data=[60] supplied=1
key=[NOAC] data=[No] supplied=1
key=[MAXROWS] data=[0] supplied=1
key=[INITSQL] data=[] supplied=0
key=[NLB] data=[No] supplied=1
key=[CURSOR_SENSITIVITY] data=[Low] supplied=1
key=[SQLDBMS] data=[] supplied=0
key=[MASE] data=[Yes] supplied=1
key=[HSODBC_FIX] data=[No] supplied=1
key=[IV] data=[No] supplied=1
key=[IA] data=[No] supplied=1
key=[JET] data=[No] supplied=1
key=[OPL_DEBUGFILE] data=[/Users/mcimerman/Desktop/PostgreSQL 15.3 iODBC testing.log] supplied=1
key=[NRSSL] data=[No] supplied=1
key=[WideAsUTF16] data=[No] supplied=1
cn_svtype=[PostgreSQL]
cn_dbpath=[<redacted DB>]
cn_dbopts=[-H <redacted IP> -P <redacted port> --ssl-mode DISABLED]
cn_readonly=0
cn_fetchSize=60
cn_deferLongFetch=0
cn_jetfix=0
cn_noautocommit=0
cn_norowsetsizelimit=0
cn_maxrows=0
cn_appname=[iODBC Demo Unicode]
cn_sqldbmsname=[]
SetLiteEnvironment: ServerType = PostgreSQL
SetLiteEnvironment: inifile = [openlink.ini]
ConnOpen: Unable to allocate connection handle
[1E8914C00] SQLDriverConnect: returning SQL_SUCCESS_WITH_INFO
[1E8914C00] SQLGetInfoW hDbc=20000
fInfoType=23 rgbInfoValue=130E08658 cbInfoValueMax=2 pcbInfoValue=0
[1E8914C00] SQLGetInfoW: returning SQL_ERROR
[1E8914C00] SQLGetInfoW hDbc=20000
fInfoType=24 rgbInfoValue=130E0865A cbInfoValueMax=2 pcbInfoValue=0
[1E8914C00] SQLGetInfoW: returning SQL_ERROR
[1E8914C00] SQLGetDiagRecW hDbc=20000
RecNumber=1, SqlState=16B424C48, NativeErrorPtr=0, MessageText=131032000, BufferLength=16384, TextLengthPtr=0
returning [OpenLink][ODBC][Driver]Connection not open
[1E8914C00] SQLGetDiagRecW: returning SQL_SUCCESS
[1E8914C00] SQLGetDiagRecW hDbc=20000
RecNumber=2, SqlState=16B424C48, NativeErrorPtr=0, MessageText=132957800, BufferLength=16384, TextLengthPtr=0
[1E8914C00] SQLGetDiagRecW: returning SQL_NO_DATA_FOUND
[1E8914C00] SQLGetInfoW hDbc=20000
fInfoType=2 rgbInfoValue=16B429FD8 cbInfoValueMax=4096 pcbInfoValue=0
[1E8914C00] SQLGetInfoW: returning SQL_SUCCESS
[1E8914C00] SQLAllocHandle hDbc=20000
handleType=3
[1E8914C00] SQLAllocHandle: returning SQL_ERROR
[1E8914C00] SQLGetDiagRecW hDbc=20000
RecNumber=1, SqlState=16B424C48, NativeErrorPtr=0, MessageText=132957800, BufferLength=16384, TextLengthPtr=0
returning [OpenLink][ODBC][Driver]Connection not open
[1E8914C00] SQLGetDiagRecW: returning SQL_SUCCESS
[1E8914C00] SQLGetDiagRecW hDbc=20000
RecNumber=2, SqlState=16B424C48, NativeErrorPtr=0, MessageText=13310C600, BufferLength=16384, TextLengthPtr=0
[1E8914C00] SQLGetDiagRecW: returning SQL_NO_DATA_FOUND
[1E8914C00] SQLDisconnect hDbc=20000
[1E8914C00] SQLDisconnect: returning SQL_ERROR
iODBC trace files
** iODBC Trace file
** Trace started on Fri Jun 21 14:29:54 2024
** Driver Manager: 03.52.1521.0705
[000000.008422]
iODBC Demo Unic 1E8914C00 ENTER SQLAllocHandle
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x6000013ef8c0
[000000.008457]
iODBC Demo Unic 1E8914C00 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x6000013ef8c0 (0x6000014c1770)
[000000.008494]
iODBC Demo Unic 1E8914C00 ENTER SQLSetEnvAttr
SQLHENV 0x6000014c1770
SQLINTEGER 1064 (unknown environment attribute)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)
[000000.008532]
iODBC Demo Unic 1E8914C00 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x6000014c1770
SQLINTEGER 1064 (unknown environment attribute)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)
[000000.008568]
iODBC Demo Unic 1E8914C00 ENTER SQLSetEnvAttr
SQLHENV 0x6000014c1770
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)
[000000.008604]
iODBC Demo Unic 1E8914C00 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x6000014c1770
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)
[000000.008639]
iODBC Demo Unic 1E8914C00 ENTER SQLAllocHandle
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHANDLE 0x6000014c1770
SQLHANDLE * 0x6000013ef8c8
[000000.008673]
iODBC Demo Unic 1E8914C00 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHANDLE 0x6000014c1770
SQLHANDLE * 0x6000013ef8c8 (0x130e08580)
[000000.008707]
iODBC Demo Unic 1E8914C00 ENTER SQLDriverConnectW
SQLHDBC 0x130e08580
SQLPOINTER 0xffffffffffffffff
SQLWCHAR * 0x1049dbe94
SQLSMALLINT -3 (SQL_NTS)
SQLWCHAR * 0x16b428fd8
SQLSMALLINT 4096
SQLSMALLINT * 0x16b428fd6
SQLUSMALLINT 1 (SQL_DRIVER_COMPLETE)
[000000.448359]
iODBC Demo Unic 1E8914C00 ENTER SQLAllocHandle
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x16b413cb0
[000000.448436]
iODBC Demo Unic 1E8914C00 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x16b413cb0 (0x6000014b0050)
[000000.448468]
iODBC Demo Unic 1E8914C00 ENTER SQLSetEnvAttr
SQLHENV 0x6000014b0050
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)
[000000.448506]
iODBC Demo Unic 1E8914C00 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x6000014b0050
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)
[000000.448542]
iODBC Demo Unic 1E8914C00 ENTER SQLSetEnvAttr
SQLHENV 0x6000014b0050
SQLINTEGER 1064 (unknown environment attribute)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)
[000000.448577]
iODBC Demo Unic 1E8914C00 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x6000014b0050
SQLINTEGER 1064 (unknown environment attribute)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)
[000000.448620]
iODBC Demo Unic 1E8914C00 ENTER SQLDataSourcesW
SQLHENV 0x6000014b0050
SQLUSMALLINT 31 (SQL_FETCH_FIRST_USER)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.532570]
iODBC Demo Unic 1E8914C00 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS)
SQLHENV 0x6000014b0050
SQLUSMALLINT 31 (SQL_FETCH_FIRST_USER)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe (25)
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.543777]
iODBC Demo Unic 1E8914C00 ENTER SQLDataSourcesW
SQLHENV 0x6000014b0050
SQLUSMALLINT 1 (SQL_FETCH_NEXT)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.543887]
iODBC Demo Unic 1E8914C00 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS)
SQLHENV 0x6000014b0050
SQLUSMALLINT 1 (SQL_FETCH_NEXT)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe (9)
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.554682]
iODBC Demo Unic 1E8914C00 ENTER SQLDataSourcesW
SQLHENV 0x6000014b0050
SQLUSMALLINT 1 (SQL_FETCH_NEXT)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.554800]
iODBC Demo Unic 1E8914C00 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS)
SQLHENV 0x6000014b0050
SQLUSMALLINT 1 (SQL_FETCH_NEXT)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe (21)
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.565467]
iODBC Demo Unic 1E8914C00 ENTER SQLDataSourcesW
SQLHENV 0x6000014b0050
SQLUSMALLINT 1 (SQL_FETCH_NEXT)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.565563]
iODBC Demo Unic 1E8914C00 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS)
SQLHENV 0x6000014b0050
SQLUSMALLINT 1 (SQL_FETCH_NEXT)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe (17)
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.575899]
iODBC Demo Unic 1E8914C00 ENTER SQLDataSourcesW
SQLHENV 0x6000014b0050
SQLUSMALLINT 1 (SQL_FETCH_NEXT)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.575996]
iODBC Demo Unic 1E8914C00 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS)
SQLHENV 0x6000014b0050
SQLUSMALLINT 1 (SQL_FETCH_NEXT)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe (19)
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.586126]
iODBC Demo Unic 1E8914C00 ENTER SQLDataSourcesW
SQLHENV 0x6000014b0050
SQLUSMALLINT 1 (SQL_FETCH_NEXT)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.586239]
iODBC Demo Unic 1E8914C00 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS)
SQLHENV 0x6000014b0050
SQLUSMALLINT 1 (SQL_FETCH_NEXT)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe (23)
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.596456]
iODBC Demo Unic 1E8914C00 ENTER SQLDataSourcesW
SQLHENV 0x6000014b0050
SQLUSMALLINT 1 (SQL_FETCH_NEXT)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.596562]
iODBC Demo Unic 1E8914C00 EXIT SQLDataSourcesW with return code 0 (SQL_SUCCESS)
SQLHENV 0x6000014b0050
SQLUSMALLINT 1 (SQL_FETCH_NEXT)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe (16)
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.606669]
iODBC Demo Unic 1E8914C00 ENTER SQLDataSourcesW
SQLHENV 0x6000014b0050
SQLUSMALLINT 1 (SQL_FETCH_NEXT)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.606798]
iODBC Demo Unic 1E8914C00 EXIT SQLDataSourcesW with return code 100 (SQL_NO_DATA_FOUND)
SQLHENV 0x6000014b0050
SQLUSMALLINT 1 (SQL_FETCH_NEXT)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe (16)
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.606857]
iODBC Demo Unic 1E8914C00 ENTER SQLFreeHandle
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHENV 0x6000014b0050
[000000.606893]
iODBC Demo Unic 1E8914C00 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHENV 0x6000014b0050
[000000.783979]
iODBC Demo Unic 1E8914C00 ENTER SQLAllocHandle
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x16b413cb0
[000000.784047]
iODBC Demo Unic 1E8914C00 EXIT SQLAllocHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHANDLE 0x0 (SQL_NULL_HANDLE)
SQLHANDLE * 0x16b413cb0 (0x6000014fa8f0)
[000000.784081]
iODBC Demo Unic 1E8914C00 ENTER SQLSetEnvAttr
SQLHENV 0x6000014fa8f0
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)
[000000.784119]
iODBC Demo Unic 1E8914C00 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x6000014fa8f0
SQLINTEGER 200 (SQL_ATTR_ODBC_VERSION)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)
[000000.784156]
iODBC Demo Unic 1E8914C00 ENTER SQLSetEnvAttr
SQLHENV 0x6000014fa8f0
SQLINTEGER 1064 (unknown environment attribute)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)
[000000.784235]
iODBC Demo Unic 1E8914C00 EXIT SQLSetEnvAttr with return code 0 (SQL_SUCCESS)
SQLHENV 0x6000014fa8f0
SQLINTEGER 1064 (unknown environment attribute)
SQLPOINTER 0x3
SQLINTEGER * -5 (SQL_IS_UINTEGER)
[000000.784271]
iODBC Demo Unic 1E8914C00 ENTER SQLDataSourcesW
SQLHENV 0x6000014fa8f0
SQLUSMALLINT 32 (SQL_FETCH_FIRST_SYSTEM)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.784668]
iODBC Demo Unic 1E8914C00 EXIT SQLDataSourcesW with return code 100 (SQL_NO_DATA_FOUND)
SQLHENV 0x6000014fa8f0
SQLUSMALLINT 32 (SQL_FETCH_FIRST_SYSTEM)
SQLWCHAR * 0x16b414cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x16b413cbe (16)
SQLWCHAR * 0x16b413cc0
SQLSMALLINT 1024
SQLSMALLINT * 0x0
[000000.784781]
iODBC Demo Unic 1E8914C00 ENTER SQLFreeHandle
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHENV 0x6000014fa8f0
[000000.784808]
iODBC Demo Unic 1E8914C00 EXIT SQLFreeHandle with return code 0 (SQL_SUCCESS)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHENV 0x6000014fa8f0
[000010.538510]
iODBC Demo Unic 1E8914C00 EXIT SQLDriverConnectW with return code 1 (SQL_SUCCESS_WITH_INFO)
SQLHDBC 0x130e08580
SQLPOINTER 0xffffffffffffffff
SQLWCHAR * 0x1049dbe94
SQLSMALLINT -3 (SQL_NTS)
SQLWCHAR * 0x16b428fd8
SQLSMALLINT 4096
SQLSMALLINT * 0x16b428fd6 (0)
SQLUSMALLINT 1 (SQL_DRIVER_COMPLETE)
[000010.538633]
iODBC Demo Unic 1E8914C00 ENTER SQLError
SQLHENV 0x6000014c1770
SQLHDBC 0x130e08580
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLWCHAR * 0x16b424f3c
SQLINTEGER * 0x0
SQLWCHAR * 0x16b424f78
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000010.538805]
iODBC Demo Unic 1E8914C00 EXIT SQLError with return code 0 (SQL_SUCCESS)
SQLHENV 0x6000014c1770
SQLHDBC 0x130e08580
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLWCHAR * 0x16b424f3c
SQLINTEGER * 0x0
SQLWCHAR * 0x16b424f78
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000012.205813]
iODBC Demo Unic 1E8914C00 ENTER SQLError
SQLHENV 0x6000014c1770
SQLHDBC 0x130e08580
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLWCHAR * 0x16b424f3c
SQLINTEGER * 0x0
SQLWCHAR * 0x16b424f78
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000012.206057]
iODBC Demo Unic 1E8914C00 EXIT SQLError with return code 100 (SQL_NO_DATA_FOUND)
SQLHENV 0x6000014c1770
SQLHDBC 0x130e08580
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLWCHAR * 0x16b424f3c
SQLINTEGER * 0x0
SQLWCHAR * 0x16b424f78
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000012.206113]
iODBC Demo Unic 1E8914C00 ENTER SQLError
SQLHENV 0x6000014c1770
SQLHDBC 0x0 (SQL_NULL_HANDLE)
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLWCHAR * 0x16b424f3c
SQLINTEGER * 0x0
SQLWCHAR * 0x16b424f78
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000012.206170]
iODBC Demo Unic 1E8914C00 EXIT SQLError with return code 100 (SQL_NO_DATA_FOUND)
SQLHENV 0x6000014c1770
SQLHDBC 0x0 (SQL_NULL_HANDLE)
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLWCHAR * 0x16b424f3c
SQLINTEGER * 0x0
SQLWCHAR * 0x16b424f78
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000012.206226]
iODBC Demo Unic 1E8914C00 ENTER SQLGetInfoW
SQLHDBC 0x130e08580
SQLUSMALLINT 2 (SQL_DATA_SOURCE_NAME)
SQLPOINTER 0x16b429fd8
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000012.206304]
iODBC Demo Unic 1E8914C00 EXIT SQLGetInfoW with return code 0 (SQL_SUCCESS)
SQLHDBC 0x130e08580
SQLUSMALLINT 2 (SQL_DATA_SOURCE_NAME)
SQLPOINTER 0x16b429fd8
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000012.207150]
iODBC Demo Unic 1E8914C00 ENTER SQLAllocHandle
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHANDLE 0x130e08580
SQLHANDLE * 0x6000013ef8d0
[000012.207259]
iODBC Demo Unic 1E8914C00 EXIT SQLAllocHandle with return code -1 (SQL_ERROR)
SQLSMALLINT 3 (SQL_HANDLE_STMT)
SQLHANDLE 0x130e08580
SQLHANDLE * 0x6000013ef8d0
[000012.207294]
iODBC Demo Unic 1E8914C00 ENTER SQLError
SQLHENV 0x6000014c1770
SQLHDBC 0x130e08580
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLWCHAR * 0x16b424f3c
SQLINTEGER * 0x0
SQLWCHAR * 0x16b424f78
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000012.207414]
iODBC Demo Unic 1E8914C00 EXIT SQLError with return code 0 (SQL_SUCCESS)
SQLHENV 0x6000014c1770
SQLHDBC 0x130e08580
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLWCHAR * 0x16b424f3c
SQLINTEGER * 0x0
SQLWCHAR * 0x16b424f78
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000013.121082]
iODBC Demo Unic 1E8914C00 ENTER SQLError
SQLHENV 0x6000014c1770
SQLHDBC 0x130e08580
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLWCHAR * 0x16b424f3c
SQLINTEGER * 0x0
SQLWCHAR * 0x16b424f78
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000013.121310]
iODBC Demo Unic 1E8914C00 EXIT SQLError with return code 100 (SQL_NO_DATA_FOUND)
SQLHENV 0x6000014c1770
SQLHDBC 0x130e08580
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLWCHAR * 0x16b424f3c
SQLINTEGER * 0x0
SQLWCHAR * 0x16b424f78
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000013.121350]
iODBC Demo Unic 1E8914C00 ENTER SQLError
SQLHENV 0x6000014c1770
SQLHDBC 0x0 (SQL_NULL_HANDLE)
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLWCHAR * 0x16b424f3c
SQLINTEGER * 0x0
SQLWCHAR * 0x16b424f78
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000013.121400]
iODBC Demo Unic 1E8914C00 EXIT SQLError with return code 100 (SQL_NO_DATA_FOUND)
SQLHENV 0x6000014c1770
SQLHDBC 0x0 (SQL_NULL_HANDLE)
SQLHSTMT 0x0 (SQL_NULL_HANDLE)
SQLWCHAR * 0x16b424f3c
SQLINTEGER * 0x0
SQLWCHAR * 0x16b424f78
SQLSMALLINT 4096
SQLSMALLINT * 0x0
[000013.121464]
iODBC Demo Unic 1E8914C00 ENTER SQLDisconnect
SQLHDBC 0x130e08580
[000013.121511]
iODBC Demo Unic 1E8914C00 EXIT SQLDisconnect with return code -1 (SQL_ERROR)
SQLHDBC 0x130e08580
[000013.122054]
iODBC Demo Unic 1E8914C00 ENTER SQLFreeHandle
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHDBC 0x130e08580
[000013.122079]
iODBC Demo Unic 1E8914C00 EXIT SQLFreeHandle with return code -1 (SQL_ERROR)
SQLSMALLINT 2 (SQL_HANDLE_DBC)
SQLHDBC 0x130e08580
[000013.122098]
iODBC Demo Unic 1E8914C00 ENTER SQLFreeHandle
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHENV 0x6000014c1770
[000013.122118]
iODBC Demo Unic 1E8914C00 EXIT SQLFreeHandle with return code -1 (SQL_ERROR)
SQLSMALLINT 1 (SQL_HANDLE_ENV)
SQLHENV 0x6000014c1770
** Trace finished on Fri Jun 21 14:30:07 2024
Excel should be running in the Apple silicon mode if I understand it correctly.
Please let me know if you need additional information.
The Excel and iODBC Demo are universal binary apps and so should work with our universal PostgreSQL ODBC Driver binary:
$ file /Library/ODBC/OpenLink\ PostgreSQL\ Lite\ ODBC\ Driver\ \(Unicode\)\ v8.0.bundle/Contents/MacOS/pgr7_mt_lu.so
/Library/ODBC/OpenLink PostgreSQL Lite ODBC Driver (Unicode) v8.0.bundle/Contents/MacOS/pgr7_mt_lu.so: Mach-O universal binary with 2 architectures: [x86_64:Mach-O 64-bit bundle x86_64] [arm64]
/Library/ODBC/OpenLink PostgreSQL Lite ODBC Driver (Unicode) v8.0.bundle/Contents/MacOS/pgr7_mt_lu.so (for architecture x86_64): Mach-O 64-bit bundle x86_64
/Library/ODBC/OpenLink PostgreSQL Lite ODBC Driver (Unicode) v8.0.bundle/Contents/MacOS/pgr7_mt_lu.so (for architecture arm64): Mach-O 64-bit bundle arm64
and works for me with iODBC Demo Unicode app enabling me to connect and query data:
$ cat /private/tmp/openlink.log
** OpenLink ODBC Trace file for iODBC Demo Unicode **
Driver: 08.00.211105 OpenLink PostgreSQL Lite Driver
connStr=[DSN]
key=[DSN] data=[pgr15_lu_v8] supplied=1
key=[DRIVER] data=[] supplied=0
key=[UID] data=[postgres] supplied=1
key=[DATABASE] data=[postgres] supplied=1
key=[OPTIONS] data=[-H xxx.xxx.xxx.xxx -P 5432 --ssl-mode PREFER] supplied=1
key=[READONLY] data=[No] supplied=1
key=[DLF] data=[No] supplied=1
key=[FBS] data=[60] supplied=1
key=[NOAC] data=[No] supplied=1
key=[MAXROWS] data=[0] supplied=1
key=[INITSQL] data=[] supplied=0
key=[NLB] data=[No] supplied=1
key=[CURSOR_SENSITIVITY] data=[Low] supplied=1
key=[SQLDBMS] data=[] supplied=0
key=[MASE] data=[Yes] supplied=1
key=[HSODBC_FIX] data=[No] supplied=1
key=[IV] data=[No] supplied=1
key=[IA] data=[No] supplied=1
key=[JET] data=[No] supplied=1
key=[OPL_DEBUGFILE] data=[/tmp/openlink.log] supplied=1
key=[NRSSL] data=[No] supplied=1
key=[WideAsUTF16] data=[No] supplied=1
cn_svtype=[PostgreSQL]
cn_dbpath=[postgres]
cn_dbopts=[-H xxx.xxx.xxx.xxx -P 5432 --ssl-mode PREFER]
cn_readonly=0
cn_fetchSize=60
cn_deferLongFetch=0
cn_jetfix=0
cn_noautocommit=0
cn_norowsetsizelimit=0
cn_maxrows=0
cn_appname=[iODBC Demo Unicode]
cn_sqldbmsname=[]
SetLiteEnvironment: ServerType = PostgreSQL
SetLiteEnvironment: inifile = [openlink.ini]
cn_needbind=1
cn_hasMoreRes=1
cn_hasParamOp=1
cn_hasScrlCurs=1
cn_hasDynMixCurs=1
cn_hasV2DAE=0
cn_spOutDeferFetch=0
cn_hasExecute2=1
autocommit=0
[1DB5A5C40] SQLDriverConnect: returning SQL_SUCCESS
[1DB5A5C40] SQLGetInfoW hDbc=20000
fInfoType=23 rgbInfoValue=1400047C8 cbInfoValueMax=2 pcbInfoValue=0
[1DB5A5C40] SQLGetInfoW: returning SQL_SUCCESS
[1DB5A5C40] SQLGetInfoW hDbc=20000
fInfoType=24 rgbInfoValue=1400047CA cbInfoValueMax=2 pcbInfoValue=0
[1DB5A5C40] SQLGetInfoW: returning SQL_SUCCESS
[1DB5A5C40] SQLGetInfoW hDbc=20000
fInfoType=2 rgbInfoValue=16BA0A098 cbInfoValueMax=4096 pcbInfoValue=0
[1DB5A5C40] SQLGetInfoW: returning SQL_SUCCESS
[1DB5A5C40] SQLAllocHandle hDbc=20000
handleType=3
[1DB5A5C40] SQLAllocHandle: returning SQL_SUCCESS
[1DB5A5C40] SQLGetStmtAttrW hStmt=30000
Attribute=10010 ValuePtr=6000027668A8 BufferLength=0 StringLengthPtr=00000000
[1DB5A5C40] SQLGetStmtAttrW: returning SQL_SUCCESS
[1DB5A5C40] SQLGetStmtAttrW hStmt=30000
Attribute=10011 ValuePtr=6000027667A8 BufferLength=0 StringLengthPtr=00000000
[1DB5A5C40] SQLGetStmtAttrW: returning SQL_SUCCESS
[1DB5A5C40] SQLGetStmtAttrW hStmt=30000
Attribute=10012 ValuePtr=600002764AE8 BufferLength=0 StringLengthPtr=00000000
[1DB5A5C40] SQLGetStmtAttrW: returning SQL_SUCCESS
[1DB5A5C40] SQLGetStmtAttrW hStmt=30000
Attribute=10013 ValuePtr=600002766728 BufferLength=0 StringLengthPtr=00000000
[1DB5A5C40] SQLGetStmtAttrW: returning SQL_SUCCESS
[1DB5A5C40] SQLPrepareW hStmt=30000
szSqlStr=6000032A0120 cbSqlStr=4294967293
[select count(*) from hugh]
[1DB5A5C40] SQLPrepareW: returning SQL_SUCCESS
[1DB5A5C40] SQLExecute hStmt=30000
[1DB5A5C40] SQLExecute: returning SQL_SUCCESS
[1DB5A5C40] SQLNumResultCols hStmt=30000
pccol=16BA0B01E
[1DB5A5C40] SQLNumResultCols: returning SQL_SUCCESS
[1DB5A5C40] SQLNumResultCols hStmt=30000
pccol=16BA09B7E
[1DB5A5C40] SQLNumResultCols: returning SQL_SUCCESS
[1DB5A5C40] SQLDescribeColW hStmt=30000
icol=1 szColName=140833600 cbColNameMax=4096 pcbColName=0 pfSqlType=16BA09C5C pcbColDef=16BA09C50 pibScale=16BA09C46 pfNullable=16BA09C44
[1DB5A5C40] SQLDescribeColW: returning SQL_SUCCESS
[1DB5A5C40] SQLFetch hStmt=30000
[1DB5A5C40] SQLFetch: returning SQL_SUCCESS
[1DB5A5C40] SQLGetData hStmt=30000
icol=1 fCType=-8 rgbValue=16BA0A060 cbValueMax=4096 pcbValue=16BA09C48
ConvertCHAR: retBufferLength(4096) to SQL_C_WCHAR
[1DB5A5C40] SQLGetData: returning SQL_SUCCESS
[1DB5A5C40] SQLFetch hStmt=30000
[1DB5A5C40] SQLFetch: returning SQL_NO_DATA_FOUND
[1DB5A5C40] SQLCloseCursor hStmt=30000
[1DB5A5C40] SQLCloseCursor: returning SQL_SUCCESS
[1DB5A5C40] SQLFreeHandle hStmt=30000
handleType=3
[1DB5A5C40] SQLFreeHandle: returning SQL_SUCCESS
[1DB5A5C40] SQLDisconnect hDbc=20000
[1DB5A5C40] SQLDisconnect: returning SQL_SUCCESS
[1DB5A5C40] SQLFreeHandle hDbc=20000
handleType=2
[1DB5A5C40] SQLFreeHandle: returning SQL_SUCCESS
[1DB5A5C40] SQLFreeHandle hEnv=10000
handleType=1
[1DB5A5C40] SQLFreeHandle: returning SQL_SUCCESS
** finished on Fri Jun 21 17:59:09 2024 **
** normal end **
$
The ConnOpen: Unable to allocate connection handle error in your ODBC trace seems to imply that the driver could not be loaded as if the is a binary mismatch or missing library neither of which should be the case using universal apps with x86_64 and arm64 binaries.
What are the exact versions of macOS and Postgres you are running ?
Mine are:
$ sw_vers
ProductName: macOS
ProductVersion: 14.3.1
BuildVersion: 23D60
$
root@b166bfe428f9:/# postgres --version
postgres (PostgreSQL) 15.7 (Debian 15.7-1.pgdg120+1)
root@b166bfe428f9:/#
These are my versions:
➜ ~ sw_vers
ProductName: macOS
ProductVersion: 14.5
BuildVersion: 23F79
➜ ~ file /Library/ODBC/OpenLink\ PostgreSQL\ Lite\ ODBC\ Driver\ \(Unicode\)\ v8.0.bundle/Contents/MacOS/pgr7_mt_lu.so
/Library/ODBC/OpenLink PostgreSQL Lite ODBC Driver (Unicode) v8.0.bundle/Contents/MacOS/pgr7_mt_lu.so: Mach-O universal binary with 2 architectures: [x86_64:Mach-O 64-bit bundle x86_64] [arm64]
/Library/ODBC/OpenLink PostgreSQL Lite ODBC Driver (Unicode) v8.0.bundle/Contents/MacOS/pgr7_mt_lu.so (for architecture x86_64): Mach-O 64-bit bundle x86_64
/Library/ODBC/OpenLink PostgreSQL Lite ODBC Driver (Unicode) v8.0.bundle/Contents/MacOS/pgr7_mt_lu.so (for architecture arm64): Mach-O 64-bit bundle arm64
$ postgres --version
postgres (PostgreSQL) 15.3
I upgraded my macOS machine to 14.5 and can still connect to the PostgreSQL database without problems.
I assume you are using the same macOS client machine to make the PostgreSQL 12.x and 15.x connections ? In which case given the PostgreSQL 12.x client works would indicate there is not a problem loading the ODBC Driver and the problem must be in the interaction with the PostgreSQL 15.x database ?
Do you have the PostgreSQL pgAdmin or other client tool on the macOS machine to prove that a connection from it is possible to the PostgreSQL 15.x database ?
You could also try enabling PostgreSQL logging on the 15.x database to see if the connection requests are reaching the server ?
Yes, I am connected to the PostgreSQL 15.x DB using pgAdmin, JetBrains DataGrip, or even the command-line psql tool. These are no problem at all.
Good idea with the pg server logging, let me check those.
