========= 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 [...]
========= 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 [...]
========= 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 [...]
========= 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 [...]