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:00January 31st, 2012|Access, Computers, Documentation, Microsoft, Oracle|Comments Off on Oracle: ORA-01722: invalid number. (#1722)

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?
Go to Top