Application error of Oracle 8i on xp with Delphi5.0 as front end

[Sherly]

Respect members of the newsgroup
Iam runnining my application using delphi5 & oracle 8i
as back end .My application runs fine on win98/nt/2000
but it gives an error opeinig some of the tables. And
the error that come is
"GENERAL SQL ERROR ORACLE ODBC. RESTRICTED DATA TYPE
ATTRIBUTE VIOLATION" .
If i drop the table and create it , it run fine for one
time use then again same error message appears on reuse.
I have used ODBC connection for connecting to Oracle.

Please give a solution so that my application will run
smoothly on xp.

Regards
From Al-ROMAN TECHNOLOGIES
(Sherly Dinesh)

 

[Rob Schneider]

Respect members of the newsgroup
Iam runnining my application using delphi5 & oracle 8i
as back end .My application runs fine on win98/nt/2000
but it gives an error opeinig some of the tables. And
the error that come is
"GENERAL SQL ERROR ORACLE ODBC. RESTRICTED DATA TYPE
ATTRIBUTE VIOLATION" .
If i drop the table and create it , it run fine for one
time use then again same error message appears on reuse.
I have used ODBC connection for connecting to Oracle.

Please give a solution so that my application will run
smoothly on xp.

Regards
From Al-ROMAN TECHNOLOGIES
(Sherly Dinesh)

Probably best if you re-post this in the odbc group,
microsoft.public.data.odbc as the problem is probably related to the
odbc driver. It could be it's "buggy". do you have an option to try an
ODBC driver for Oracle from another vendor?