PostGreSQL Newbie
Help Thad,
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 <thad@technosolver.com> 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 <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
—
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
