Hello
I have setup a postgres connection using the standard ODBC. Problem is that it generates hundreds lines of logs showing multiple attempts to connect using different ports than the one appearing in the setup. Seems like it does connection pooling though I read that Designer doesn't do connection pooling.
Same driver works as expected when used in Excel: it doesn't create any logs, apart from standard.
I also found this query appearing in the logs, with a bunch of errors attached to it:
select USER(), APPLICATION_ID() from system.iota
select USER(), APPLICATION_ID() from system.iota
select USER as USER_NAME from SYSIBM. SYSDUMMY1
select USER as USER_NAME from SYSIBM. SYSDUMMY1
select * from rdb$relations
select * from rdb$relations
select first 1 dbinfo('version', 'full') from systables
select first 1 dbinfo('version', 'full') from systables
select #01/01/01# as AccessDate
select #01/01/01# as AccessDate
exec sp_server_info1
exec sp_server_info 1
select top (0) * from INFORMATION_SCHEMA. INDEXES
select top (0) * from INFORMATION_SCHEMA. INDEXES
SELECT SERVERPROPERTY('edition')
SELECT SERVERPROPERTY('edition')
select DATABASE() as 'database', VERSION() as 'version"
select DATABASE() as 'database', VERSION() as `version
select cast(version() as char(10)), current_useroid as t
select cast(version() as char(10)), current_useroid as t
select * from sys.V_$VERSION at where RowNum<2
select * from sys.V_$VERSION at where RowNum<2
select cast(version() as char(10)), (select 1 from pg_catalog.pg_class) as t
select NAME from sqlite_master
select NAME from sqlite_master
select xp_msver( 'CompanyName')
select xp_msver('CompanyName')
@version
@version
select * from dbc.dbcinfo
select * from dbc.dbcinfo
@VERSION
@VERSION;
Postgres version is 15, ODBC connector is from https://www.postgresql.org/ftp/odbc/versions/msi/. It is installed using System DSN and using recommended configuration.
Any ideas what is going on?
