Oracle odbc manager3/22/2023 ![]() ![]() I guess QlikView Desktop is wise enough to understand that DBNM.WORLD is same as DBNM, but QMC is more rigid. Reran it in QMC and it reloaded successfully there too. Reran the app in desktop and it reloaded successfully. ![]() ![]() WORLD to the TNS Service Name clicked Test Connection and it connected successfully. I went back to ODBC Data Source Administrator, manually typed in. I opened up tnsnames file and saw that the name is actually DBNM.WORLD - same as in the connect script. WORLD (as in BDNM.WORLD), but in ODBC Data Source Administrator, the TNS Service Name was showing up as DBNM. In the connect string in the script I had the name of the data source contain. Thanks for the help! Point 2 had the solution. Have any of you completed a setup on a server that got QMC to play well with Oracle ODBC connection? Is there something that I need to set up in QMC to get it to run an app with a connect string to Oracle DB? To add clarity, I did absolutely nothing in QMC so if there are some steps that I need to take in QMC to get it to reload an app with Oracle DB connect string, would you please let me know? Now at this point, I'm thinking there something that needs to be set up in QMC that I'm not familiar with. Slim chance, but possible." I kick off the app in QMC and it fails. I'm thinking, "ok, maybe QMC had a hiccup and failed randomly. ![]() I opened the app in QlikView Desktop (all this is done on the server with server's credentials) reload the app, it runs fine, pulls the data in without any issues. Ran the same query as in QlikView script and Toad produced the results exactly as I expected. Then I set up a task in QMC thinking all will continue to go fine and dandy, I kick off the refresh of the app in QMC and it fails with the error above. I installed Toad for Oracle software to check that I was able to connect to the database with some software other than QlikView and I connected without any issues. I was a happy camper at this point, thinking I got this, Oracle client is installed, I can run the app using server's credentials, all is good. On the server, I went ahead and downloaded Oracle Database 11g client, set up environmental variables, and added ODBC connection in ODBC Data Source Administrator. I was logged on to server using server’s credentials, reload the app using QlikView Desktop, the app connects and pulls the data without any issues. I had to start from scratch when it comes to installing Oracle client on the server. Here's a full story of what I've done so far to help zero in on the issue. The app runs fine on the server when I run it in QlikView Desktop but when I kick it off in QMC, I get this error:Ĭonnector connect error: SQL#f - SqlState: 08004, ErrorCode: 12154, ErrorMsg: ORA-12154: TNS:could not resolve the connect identifier specified ServerName = ///Īnd now I can access Oracle's DB.I'm struggling getting an app that has a connect string that connects to Oracle database to run in QMC. I believe this way is correct because the script adds a bunch of configurations that are not obvious at first. With that, the script configured /etc/odbcinst.ini with the correct driver, and /etc/odbc.ini with most configurations. usr/lib/oracle/21/client64/bin/odbc_update_ini.sh "/" "/usr/lib/oracle/21/client64/lib" "oracle"Īrg1 - / = default directory for ODBC Driver Manager (root)Īrg2 - /usr/lib/oracle/21/client64/lib = default library directoryĪrg3 - oracle = any name you wish for the Driver name (used in DSN config) I found what I believe is the correct procedure to configure Oracle's ODBC while using odbc_update_ini.sh script.Īfter installing ODBC driver manager and Oracle's driver, by default we must start Oracle's script in the following manner. I could not find meaninful information about this issue for now. # Check whether Driver Manager is installed or not # cat /usr/lib/oracle/21/client64/bin/odbc_update_ini.sh It seems there should be an $ODBCDM_Home environment variable set, but it does not exist, and Oracle's guide does not instruct us on how to set it. # /usr/lib/oracle/21/client64/bin/odbc_update_ini.sh "/usr/local" It happens that this script cannot find the INI file. usr/lib/oracle/21/client64/bin/odbc_update_ini.shįor that, I should input the as the first argument. Then, the guide suggests to configure ODBC with the odbc_update_ini.sh script. # odbcinst -jįILE DATA SOURCES.: /etc/ODBCDataSources Odbcinst shows the driver defaults correctly. # dnf install unixODBC oracle-instantclient-sqlplus oracle-instantclient-odbc I'm trying to configure an ODBC connection for an Oracle DB using unixODBC drivers.įirst, I successfully installed the ODBC client and driver. ![]()
0 Comments
Leave a Reply.AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |