heathramos2
IS-IT--Management
I created a link to a table but when I try to open the link, I get a ODBC error (ODBC -- call failed. [Oracle][odbc]Invalid datetime format. (#0)
More information:
-created link in Access 2000 database
-I can access other tables in Access to that same Oracle database using the same DSN
-I get the same error on other desktops
-I can log onto sqlplus and access that table without any issues
I assume there is a field with some data in it that Access can't translate across odbc but Oracle (and sqlplus) can but not sure what to look for.
More information:
-created link in Access 2000 database
-I can access other tables in Access to that same Oracle database using the same DSN
-I get the same error on other desktops
-I can log onto sqlplus and access that table without any issues
I assume there is a field with some data in it that Access can't translate across odbc but Oracle (and sqlplus) can but not sure what to look for.
