Good day fellow Omnis Developers.
I have been asked to switch a client from MSSQL to PostGres and as such I
am dabbing my toes into the Omnis water again.
I managed to download, setup and configure an instance of PostgreSQL om
Windows 10 workstation and also managed to setup an ODBC link to it, using
the Postgres ODBC driver.
In Omnis Studio (5.1), I can open a SQL Browser link using the ODBC
Connector and I can see the DB and managed to drag and drop a couple of
Schemas to the DB and PostGres created the required tables, with a couple
In another Omnis project (it was many years ago and I had to seriously dust
of the cob webs), I copied and pasted a Database Object of type ODBC.
However I cannot get the ODBC Method $logon to actually open the connection
to the DB via code (as mentioned, I can do this via the SQL Browser), I get
the following error:
“[Microsoft][ODBC Driver Manager] The specified DSN contains an
architecture mismatch between the Driver and Application”
I am a bit stumped, is there anyone that managed to create a logon to a
PostGreSQL DB via code on a Windows Environment?
This message (and any associated files) is intended only for the use of the
individual or entity to which it is addressed and may contain information
that is confidential, subject to copyright or constitutes a trade secret.
If you are not the intended recipient you are hereby notified that any
dissemination, copying or distribution of this message, or files associated
with this message, is strictly prohibited. If you have received this
message in error, please notify us immediately by replying to the message
and deleting it from your computer.
Manage your list subscriptions at lists.omnis-dev.com