Note that the 32-bit Administrator, and all 32-bit ODBC applications (typically installed to %systemdrive%/Program Files (x86)/), will list 64-bit User DSNs (that is, DSNs based on 64-bit ODBC drivers) - even though these DSNs and drivers cannot be used by the 32-bit tools/applications. Start -> Control Panels -> Data Sources (ODBC) (The 64-bit ODBC Administrator can also be accessed through the Control Panels interface, as the Data Sources (ODBC) control panel.) Typical Paths to ODBC Administrators This controls 64-bit ODBC drivers, which are required by 64-bit client applications. (The 32-bit ODBC Administrator cannot be accessed through the Control Panels interface the Data Sources (ODBC) control panel is the 64-bit ODBC Administrator.)Ĭounterintuitively, the 64-bit ODBC Administrator is found at %systemdrive%/Windows/System32/odbcad32.exe. This controls 32-bit ODBC drivers, which are required by 32-bit client applications. The 32-bit ODBC Administrator is found at %systemdrive%/Windows/ SysWoW64/odbcad32.exe. They are differentiated by their filesystem location. Many 64-bit environments still support 32-bit applications, and these require 32-bit ODBC drivers and DSNs, so it's important to understand how this all works.īoth the 32-bit and 64-bit ODBC Administrator are named odbcad32.exe. If this does not work speak to your DBA (database administrator).Using ODBC (32-bit and 64-bit) on 64-bit WindowsĦ4-bit Windows has some surprising and counterintuitive setup and behavior around 32-bit and 64-bit ODBC. Using integrated security is the usual way to connect to a Microsoft SQL Server database. Speak to your database administrator (DBA) or network administrator. SQL Server defaults to port 5432, but a different port can be used. Please contact us at if you need to know the latest supported version of the psqlodbc ODBC drivers. Iguana may not always support the very latest version of the psqlodbc ODBC drivers:.Speak to your DBA (database administrator) for general connection issues like: User name and password, Database Server network name etc. If the connection does not work speak to your DBA (database administrator) about how to login to the database (user authentication).Click Save to create the ODBC data source:.Note: If you are unsure of these ask your DBA (database administrator). Optional: Enter the Port number (default = 5432).Note: If you are unsure of the name ask your DBA (database administrator). Enter the Network Name of the PostgreSQL Server in the Server field:.Optional: Choose your default Database.Use any Data Source and Description you prefer.Choose the latest PostgreSQL ODBC driver and click Finish:.Right Click and choose Run as Administrator:.Search for ODBC and choose ODBC Data Sources (64 bit):.Windows 10 (64 bit version) supports 32 and 64 bit ODBC sources - always use the 64 bit ODBC Administrator. Run the msi installer and accept the defaults.Download the latest 64 bit driver installer (zipped msi file) from the psqlodbc download site.Install the latest PostgreSQL ODBC drivers:.If you need to know which versions of PostgreSQL are supported by the version of Iguana you are using please contact us at set up a new ODBC data source for PostgreSQL: ![]() This is particularly true if you are not able to use the the latest version of Iguana. Note: Iguana may not always support the very latest version of the PostgreSQL ODBC drivers, so you can simply download an earlier version if necessary.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |