Howdy fellows, Recently when attempting to install xca 2.5.0 (using

Please see <a href="https://github.com/chris2511/xca?tab=readme-ov-file#sql-remote-dat

<a class="user-mention notranslate" data-hovercard-type="user" data-hovercard-url="/us

ODBC the only option for "Open Remote Database" on Windows systems about xca HOT 5 CLOSED

laserguidedcake commented on June 11, 2024

ODBC the only option for "Open Remote Database" on Windows systems

from xca.

Comments (5)

AnonATXDO commented on June 11, 2024 1

Please see https://github.com/chris2511/xca?tab=readme-ov-file#sql-remote-database-drivers and #495. You have to install other database drivers yourself because of license issues (they are not shipped with Qt anymore by default).

from xca.

flybyray commented on June 11, 2024

@AnonATXDO do you know what exactly needs to be in the path for windows?
I have installed postgresql 16 (via scoop) and the following files are in path now:

._libcrypto-3-x64.dll
._libssl-3-x64.dll
._libxml2.dll
._zlib1.dll
clusterdb.exe
createdb.exe
createuser.exe
dropdb.exe
dropuser.exe
ecpg.exe
icudt67.dll
icuin67.dll
icuio67.dll
icutu67.dll
icuuc67.dll
initdb.exe
isolationtester.exe
libcrypto-3-x64.dll
libecpg.dll
libecpg_compat.dll
libiconv-2.dll
libintl-9.dll
liblz4.dll
libpgtypes.dll
libpq.dll
libpq_pipeline.exe
libpq_testclient.exe
libpq_uri_regress.exe
libssl-3-x64.dll
libwinpthread-1.dll
libxml2.dll
libxslt.dll
libzstd.dll
oid2name.exe
pg_amcheck.exe
pg_archivecleanup.exe
pg_basebackup.exe
pg_checksums.exe
pg_config.exe
pg_controldata.exe
pg_ctl.exe
pg_dump.exe
pg_dumpall.exe
pg_isolation_regress.exe
pg_isready.exe
pg_receivewal.exe
pg_recvlogical.exe
pg_regress.exe
pg_regress_ecpg.exe
pg_resetwal.exe
pg_restore.exe
pg_rewind.exe
pg_test_fsync.exe
pg_test_timing.exe
pg_upgrade.exe
pg_verifybackup.exe
pg_waldump.exe
pgbench.exe
postgres.exe
psql.exe
reindexdb.exe
stackbuilder.exe
vacuumdb.exe
vacuumlo.exe
wxbase317u_vc_custom.dll
wxbase317u_xml_vc_custom.dll
wxbase317ud_net_vc_custom.dll
wxmsw317u_adv_vc_custom.dll
wxmsw317u_core_vc_custom.dll
wxmsw317ud_aui_vc_custom.dll
wxmsw317ud_html_vc_custom.dll
wxmsw317ud_xrc_vc_custom.dll
zic.exe
zlib1.dll

Tested this with PowerShell like this (first file in the bin directory) Get-Command ._libcrypto-3-x64.dll
The output shows the path to: $env:USERPROFILE\scoop\apps\postgresql\current\bin\._libcrypto-3-x64.dll

I guess this was an auto update without testing ScoopInstaller/Extras@2f50f3c

from xca.