By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,045 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,045 IT Pros & Developers. It's quick & easy.

ODBC error - linking to oracle

P: n/a
High there everyone,

I have inherited a database with an odbc table (linking to an oracle
database) , we have recently updated our operating environment to
windows 2000 (access 2000). since then everytime i try to add a
record to the linked table i get the following error ODBC call failed
sqlerrm(tablename)(#-391)

I have found out that the sqlerrm table in oracle is an error table
but I haven't been able to find out what is causing the error. I am
wondering if its permission based - but thats just a theory.

anyone got any ideas?

:)
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Have you tried verifying the Oracle ODBC connection within your ODBC Data
Sources? Control panel -> Administrative Tools -> Data Sources (ODBC)

regards,
Mark Day.

"Michael" <we****@hotmail.com> wrote in message
news:af**************************@posting.google.c om...
High there everyone,

I have inherited a database with an odbc table (linking to an oracle
database) , we have recently updated our operating environment to
windows 2000 (access 2000). since then everytime i try to add a
record to the linked table i get the following error ODBC call failed
sqlerrm(tablename)(#-391)

I have found out that the sqlerrm table in oracle is an error table
but I haven't been able to find out what is causing the error. I am
wondering if its permission based - but thats just a theory.

anyone got any ideas?

:)

Nov 13 '05 #2

P: n/a
Thanks Mark,

Yes I have tried that and it is fine. I think the error message is
due to null fields or incorrect data being supplied to the table but
can't find any information to confirm my suspicion.

:)
Any other help would be appreciated!

"Mark Day" <mark.day@NO_SPAM_solortec.co.uk> wrote in message news:<41***********************@reader.news.newnet .co.uk>...
Have you tried verifying the Oracle ODBC connection within your ODBC Data
Sources? Control panel -> Administrative Tools -> Data Sources (ODBC)

regards,
Mark Day.

"Michael" <we****@hotmail.com> wrote in message
news:af**************************@posting.google.c om...
High there everyone,

I have inherited a database with an odbc table (linking to an oracle
database) , we have recently updated our operating environment to
windows 2000 (access 2000). since then everytime i try to add a
record to the linked table i get the following error ODBC call failed
sqlerrm(tablename)(#-391)

I have found out that the sqlerrm table in oracle is an error table
but I haven't been able to find out what is causing the error. I am
wondering if its permission based - but thats just a theory.

anyone got any ideas?

:)

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.