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:00November 23rd, 2011|Computers, Documentation, Microsoft, ODBC, Oracle, Windows|Comments Off on ODBC: Save your password in the Registry

Using MySQL with ASP.NET

========= QUESTION --------- Can you use the free and popular open source database system, MySQL when coding with ASP.NET, rather than the expensive Microsoft SQL Server database system?   ========= ANSWER --------- Yes - see REF   ========= EXAMPLES ---------   ========= APPLIES TO / KEY WORDS --------- mysql MSSQL VB C# Web CodingCode   [...]

By |2017-12-01T23:47:36+00:00September 29th, 2011|ASP.NET, Computers, Documentation, Microsoft, MySQL|Comments Off on Using MySQL with ASP.NET

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:00September 19th, 2011|Computers, Documentation, Microsoft, ODBC, Oracle|Comments Off on Can you ping a TNS Name?

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:00September 13th, 2011|Computers, Documentation, Microsoft, ODBC, Windows|Comments Off on ODBC Error: The setup routines for the X ODBC Driver could not be loaded
Go to Top