Ssh -C -N -L 60000:localhost:5432 will map our local port 60000 to the remote port 5432 at the machine (we'll obviously need to update the Port = 5432 line in the previous example with Port = 60000). If we wanted to connect to a remote one, there are many configurations, but for me the easiest and safe one is to create an SSH tunnel: The previous DSN example was created for a local postgreSQL database. This define a User DSN named ib3db (with its user and password). Driver = PostgreSQL Unicode ServerName = localhost Port = 5432 Database = ib3db Username = iberouser Password = mypass1234 Protocol = 9.1.6 Debug = 1 Now we have to define an ODBC driver entry for PortgreSQL in the file /usr/local/etc/odbcinst.ini in a similar fashion to this one:
Check odbc manager mac drivers#
If everything went ok, you should have the PostgreSQL drivers installed as 2 library files located at /usr/local/lib/psqlodbcw.la and /usr/local/lib/psqlodbcw.soĪnd that's all. Pick a recent one and uncompress it in a directory of your choice, then open a terminal and 'cd' into it.Ĭompile it following the typical command sequence: Once installed, it's time to compile the PostgreSQL ODBC driver (not available in Homebrew yet, unfortunately, so we'll do it by hand): It's an example of a good work very well done (however, using Homebrew is not mandatory, there are other projects long ago: Fink and MacPorts). Personally, I think the simplest way to do it is using Homebrew, that fantastic open source package tool which makes Ruby to call my attention (disclaimer: I'm a zealot pythonista! )).
Check odbc manager mac for mac os#
I'm surprised, because it works incredibly well:įirst thing to do is installing unixODBC for Mac OS X. And I've finally found an easy way to create ODBC connections using unixODBC as I do in Linux. But after having sorted out a little some other aspects of my life, I'm back, stronger than ever! :)Īmong the things I've recently had to deal with, is the ODBC connections and Mac (yes, I own a Mac for some time now ) ). Wow! Almost a whole (sabbatic?) year has passed since my last post! I really was neither in the mood, nor motivated for writing.
0 kommentar(er)
