Обсуждение: [ODBC] psqlODBC on OSX problems
disclaimer: Mac is not my primary develop env.
Env. iMac OSX Sierra latest patches as of 2017-04-01
Background: I need to connect the app Stata via ODBC to the Postgres 9.5.6 instance (EnterpriseDB build/installer).
A few versions ago Mac stopped shipping their native ODBC manager so I installed iODBC Manager (via iODBC.org)
I got a DSN created and successfully talking to the DB but Stata wouldn't recognize it.
Assuming something was corrupted or permissions weren't correct I uninstalled iODBC and removed some files in various directories to start fresh.
I reinstalled iODBC, I can see the drivers, but when I try to add a dsn or go to the "Configure Drivers" tab and simply click "OK" on closing I get a "General Installer Error".
Now I am thinking I must have removed some file/dir that was necessary I didn't know about. Does anyone have any insight on what I need to do to get it back to a "good state"?
Thanks,
Jonathan
On 04/12/2017 10:04 AM, Jonathan Byrd wrote: > disclaimer: Mac is not my primary develop env. > > > Env. iMac OSX Sierra latest patches as of 2017-04-01 > > > Background: I need to connect the app Stata via ODBC to the Postgres > 9.5.6 instance (EnterpriseDB build/installer). I thought EDB shipped a ODBC driver through the StackBuilder portion of the install. Have you checked there? > > > A few versions ago Mac stopped shipping their native ODBC manager so I > installed iODBC Manager (via iODBC.org) > > > I got a DSN created and successfully talking to the DB but Stata > wouldn't recognize it. > > > Assuming something was corrupted or permissions weren't correct I > uninstalled iODBC and removed some files in various directories to start > fresh. > > > I reinstalled iODBC, I can see the drivers, but when I try to add a dsn > or go to the "Configure Drivers" tab and simply click "OK" on closing I > get a "General Installer Error". Which version of iODBC? How did you install it? Also the highest I see the prepackaged dmg's for OS X go is OS X 10.11(El Capitan). Nothing about 10.12(Sierra) > > > Now I am thinking I must have removed some file/dir that was necessary I > didn't know about. Does anyone have any insight on what I need to do to > get it back to a "good state"? > > > Thanks, > > Jonathan > -- Adrian Klaver adrian.klaver@aklaver.com
Hi Adrian...
1. EDB does ship the driver. I see that no problem.
Sent: Wednesday, April 12, 2017 2:13 PM
To: Jonathan Byrd; pgsql-odbc@postgresql.org
Subject: Re: [ODBC] psqlODBC on OSX problems
> disclaimer: Mac is not my primary develop env.
>
>
> Env. iMac OSX Sierra latest patches as of 2017-04-01
>
>
> Background: I need to connect the app Stata via ODBC to the Postgres
> 9.5.6 instance (EnterpriseDB build/installer).
I thought EDB shipped a ODBC driver through the StackBuilder portion of
the install. Have you checked there?
>
>
> A few versions ago Mac stopped shipping their native ODBC manager so I
> installed iODBC Manager (via iODBC.org)
>
>
> I got a DSN created and successfully talking to the DB but Stata
> wouldn't recognize it.
>
>
> Assuming something was corrupted or permissions weren't correct I
> uninstalled iODBC and removed some files in various directories to start
> fresh.
>
>
> I reinstalled iODBC, I can see the drivers, but when I try to add a dsn
> or go to the "Configure Drivers" tab and simply click "OK" on closing I
> get a "General Installer Error".
Which version of iODBC?
How did you install it?
Also the highest I see the prepackaged dmg's for OS X go is OS X
10.11(El Capitan). Nothing about 10.12(Sierra)
>
>
> Now I am thinking I must have removed some file/dir that was necessary I
> didn't know about. Does anyone have any insight on what I need to do to
> get it back to a "good state"?
>
>
> Thanks,
>
> Jonathan
>
--
Adrian Klaver
adrian.klaver@aklaver.com
On 04/12/2017 12:53 PM, Jonathan Byrd wrote: > Hi Adrian... > > > 1. EDB does ship the driver. I see that no problem. Yeah, that was me not paying attention to the fact you where looking for a driver manager not a driver. > > 2. I installed it from their downloads page, 3.52.12. And yes, it > doesn't say that it supports Sierra. I must have initially used a > different download link. I'll see if I can find that and report back. ? http://www.odbcmanager.net/ > > Note: the version I originally installed was NOT this version (I assumed > they were the same) but I remember because the .dmg file had a much > different name. > > Thanks > -- Adrian Klaver adrian.klaver@aklaver.com