ODBC: Save your password in the Registry

========= QUESTION --------- Can you save your ODBC user and password in the registry to avoid having to re-enter your password every time you connect to the database?   ========= ANSWER --------- Yes - though it seems to work better in older versions of Oracle than newer ones. Open your Registry Editor (Run, RegEdit) Navigate [...]

By | 2017-12-01T23:47:35+00:00 November 23rd, 2011|Computers, Documentation, Microsoft, ODBC, Oracle, Windows|0 Comments

Can you ping a TNS Name?

========= QUESTION --------- I use ODBC connections to link to Oracle databases. These connections use a TNS Name in their Service Name field. Can I simply PING these TNS Names as a simple connectivity test to the database?   ========= ANSWER --------- Yes  At the COMMAND PROMPT, type: TNSPING (SPACE and then the SERVICE NAME [...]

By | 2017-12-01T23:47:37+00:00 September 19th, 2011|Computers, Documentation, Microsoft, ODBC, Oracle|0 Comments

ODBC Error: The setup routines for the X ODBC Driver could not be loaded

========= QUESTION --------- When attempting to ADD or EDIT an ODBC connection from the ODBC Data Source Administrator in Windows, I receive the following error: Microsoft ODBC Administrator The setup routines for the X ODBC Driver could not be loaded due to system error code 126: The specified module could not be found. (C:......dll).   [...]

By | 2017-12-01T23:47:37+00:00 September 13th, 2011|Computers, Documentation, Microsoft, ODBC, Windows|0 Comments