![]() I'm in over my head here, hoping for some help.Ĥ - Note: I am aware that Devart produces a Postgres driver which may be simpler, but it should be possible to use an open-source version. Choose the Amazon Redshift ODBC driver, and then choose Finish. After that, I'm still not sure how even with unixodbc that would translate to the kind of connection string you could pass into an application wanting to use the driver. Amazon Redshift ODBC Driver (32-bit) Choose the System DSN tab to configure the driver for all users on the computer, or the User DSN tab to configure the driver for your user account only. Returns ERROR: Could not SQLDriverConnectģ - I'm looking for some help generally with a Postgres ODBC driver on Linux. Returns multiple drivers one of which reads: # Driver from the postgresql-odbc package As fog noticed you can also use other technology to connect to PostgreSQL. ![]() For PostgreSQL driver there is also 'Test' button to check if connection can be established. After installation of the driver manager and driver, you will have to register the driver in a odbcinst.ini file for it to appear in odbc::odbcListDrivers(). I dont know Mac, but in Windows there is ODBC Manager where you configure Data Sources. I have also tried passing in odbc_config which returns the same error.Ģ - This link gives informs me that there is a fedora package for installing the postgres driver. For Unix and MacOS ODBC drivers should be compiled against unixODBC.Drivers compiled against iODBC may also work, but are not fully supported. ![]() brew (Homebrew) is the package manager command that's required in this case to install the drivers on your Mac so your Python code can talk to the database. Which is returning: configure: error: unixODBC library "odbcinst" not found The answer to this is no, you cannot do what you're asking - you're talking across purposes. configure -with-libpq=/usr/bin/psql -with-unixodbc=/bin/odbcinst However, I am stuck at the configuring stage. Double-click on the installer package (.pkg) to start the installation process. Once the download is complete, double-click on the disk image file (.dmg) to mount it. Make sure to select the version that is compatible with your operating system (macOS). ![]() One should be able to configure - make - make install. Download the ODBC driver for PostgreSQL from the Devart website. It connects to all popular databases and runs on Win, macOS & Linux. This whole process is proving quite difficult for me.ġ - This is the official ODBC driver for Postgres. DbVisualizer is the SQL Client and Database Tool with the highest user satisfaction. I'm trying to use some open-source software ( ) that will ultimately require a general connection string to access a Postgres database using an ODBC driver as it is running on a Linux server(CentOS). I'm surprised that I can't find any posts with this question as I can't be the only one struggling with this. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |