Yes I am on a 64bit machine and using the 64bit odbc driver.
I have not tried the PostgreSQL DAM. Where do I get it?
I am going to give the 32 bit odbc driver in the meantime
On Tue, 21 Nov 2017 at 20:04, Thad Bogert <firstname.lastname@example.org> wrote:
> 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 <email@example.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,
> > 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
> > 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
> > to the DB via code (as mentioned, I can do this via the SQL Browser), I
> > 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
> > 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
> > 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
Vertrou op JEHUAH met jou hele hart en steun nie op jou eie insig nie. Ken
Hom in al jou weë, dan sal Hy jou paaie gelykmaak
Manage your list subscriptions at lists.omnis-dev.com