PostGreSQL Newbie
Are you on a 64bit machine? Studio 5 is a 32bit application which requires a 32bit driver and the datasource name (DSN) must be configured using the 32bit ODBC admin.
c: WINDOWSSysWOW64odbcad32.exe
Have you considered using the PostgreSQL DAM?
> On Nov 21, 2017, at 12:42 PM, Dawid Mocke <dawidmocke@gmail.com> wrote:
>
> 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
> of quirks.
>
> 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?
>
> Thank you,
>
> —
> Dawid Mocke
> 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
_____________________________________________________________
Manage your list subscriptions at lists.omnis-dev.com