![]() Once you are done with defining the DSN, you can verify your DSN using the following command Note that you need "sudo" permissions to edit the "/etc/odbc.ini" file.įor all the available configurable options that you can use in defining a DSN can be found # enable below when dealing large resultsets Now it is time to create a DSN.Įdit "/etc/odbc.ini" file and add the following That should show you all the ODBC drivers installed in your system. Now, to o verify that PostgreSQL driver installed correctly from earlier step, execute the following command Run into any issues during the installation. To install, simply untar the contents of the file to a temporary location and execute the following commands as super user.Ĭheck unixODBC website site for more information, if you Otherwise you can download the unixODBC manager here. If you are working with RedHat Linux or Fedora you can check the graphical "yum" installer to search, find and install unixODBC. As the ODBC Driver manager Teiid recommends unixODBC. This is possible because Teiid has specialized handling that allows it emulate a PostgreSQL server and respond appropriate to expectedīefore you can access Teiid using ODBC on any *nix platforms, you need to either install a ODBC driver manager or verify Teiid can provide ODBC access to deployed VDBs in the Teiid runtime through that is, the application must be capable of issuing ODBC commands and theĭBMS must be capable of responding to them. For this to work, both the application and the DBMS must be ODBC-compliant ODBC uses a driver to translate the application's data queries ODBC, just like JDBC in Java, allows consistent client access regardless of which database management Open DataBase Connectivity (ODBC) is a standard database access method developed by the SQL Access group in 1992. Configuring the Data Source Name (DSN) 7.2.1.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |