![]() ![]() modem- lines, but not for faster ones), and also use -N (do not execute anything remotely) so a remote ssh window is not opened, for example. You can also use extra flags, like -C (above) to compress the data transmitted to the tunnel (recommended for slow -e.g. ![]() To shutdown the tunnel, just kill the ssh command pressing CTRL-C. 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. You won’t get a pop-up to confirm the process, but rest assured. Open the instantclient folder in your Oracle folder, and right-click odbcinstall.exe. This define a User DSN named ib3db (with its user and password). Click New and enter the same folder path again into the Variable Value box. tar.gz file that matches your version of Linux. For example, to install Firefox, you would run: brew install firefox. Homebrew can install both graphical applications (known as casks) and open-source command-line tools (known as formulae). Go to the directory where the Microsoft SQL Server ODBC Driver download placed the file called msodbcsql-.0.tar.gz. Use the brew install name command to install applications on your Mac, replacing name with the name of the application you want to install. Driver = PostgreSQL Unicode ServerName = localhost Port = 5432 Database = ib3db Username = iberouser Password = mypass1234 Protocol = 9.1.6 Debug = 1 To install the driver manager: Make sure that you have root permission. 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: 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! )). 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 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |