| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> ODBC problems
Hi,
I am faced with the task to make Access97 running on Windows
NT 4.0 access an Oracle DB running on Windows NT 4.0 and
later switch that system to an Oracle running on an UNIX
machine.
For our test system I have set up the Oracle Workgroup database Server 7.1 from the Personal Oracle 2000 CD. I have installed SQL*Net 2.1 and the ODBC-driver from Oracle's free download page.
When I try to connect to the database using Oracle's ODBC test program I get the following error message:
SQLSTATE: S1000
Native Error Code 65535
Driver Message:[Oracle][ODBC Oracle Driver][Oracle
OCI]ORA-00001: unique constraint [%sm%s] violated
Any ideas what might cause this error message? If I supply a wrong password or user name I get the appropriate error messages. Therefore the system generally seems to be up and running. The system accepts my login and then somehow generates that violation. Probably while trying to write my login data into some system tables.
Mit freundlichen Gruessen, / With best regards, Paul Hoepping
 |
 |