Oracle: ORA-01722: invalid number. (#1722)

========= QUESTION --------- When running a query from Microsoft Access against an Oracle table, I receive the following error and the query does not execute: ODBC--call failed. [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-01722: invalid number. (#1722)   ========= ANSWER --------- You are likely doing a type conversion (from text type to number type) on a database field [...]

By | 2017-12-01T23:47:29+00:00 January 31st, 2012|Access, Computers, Documentation, Microsoft, Oracle|0 Comments

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

Access: SQL Pass-Through Query against Oracle

========= QUESTION --------- When I write a regular query in Microsoft Access against a table in an Oracle Database, and then convert it to a SQL Pass-Through query, it will not run, and shows errors like the following:  --- ODBC--call failed. [Oracle][ODBC][Ora]ORA-00903: invalid table name (#903) OK     Help--- --- ODBC--call failed. [Oracle][ODBC][Ora]ORA-00396: missing expression(#936) OK    [...]

By | 2017-12-01T23:47:38+00:00 August 9th, 2011|Access, Computers, Documentation, Microsoft, Oracle|0 Comments