the postgres dam works far better than the odbc dam – since it handles all the data types natively and faster.
the dam is part of the Studio 5.1 deployment — but I’d suggest that you use stuio 5.2.3 (if possible) as it has the most up to date dam’s for studio 5 series.
and yes, it works on windows and mac — we’ve been using it for years with studio 5.x and ever since studio 4.1.5.
if you were using the MS SQL dam’s before you would have ahad a choice to use V2 or v3 dams.
If I recall correctly,
– v2 dams were roll your own SQL.
– v3 dams encapsulated things within table classes.
most of the world uses v3 dams at this time.
notwithstanding the above, if your code is written to V2 dams or V3 dams, you should easily be able to swap out MS sql for postgres, as long as there was an object or table class layer in the middle to give you a little bit of abstraction.
see you at the third annual users conference
> On Nov 21, 2017, at 11:22 AM, Dawid Mocke <email@example.com> wrote:
> The 32 bit ODBC driver worked….thank you! How does the PostgreSQL DAM
> On 21 November 2017 at 20:08, Dawid Mocke <firstname.lastname@example.org> wrote:
>> 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 <email@example.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 <firstname.lastname@example.org> wrote:
>>>> Good day fellow Omnis Developers.
>>>> I have been asked to switch a client from MSSQL to PostGres and as such
>>>> 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
>>>> 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
>>>> that is confidential, subject to copyright or constitutes a trade
>>>> 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
>>>> 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
> 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