ODBC -- call failed

  • Thread starter Thread starter Island_Dude via AccessMonster.com
  • Start date Start date
I

Island_Dude via AccessMonster.com

Hello experts,

I have some Access forms with queries linked through ODBC connection to
Oracle. Everything was working fine and all of a sudden I start getting the
following error message:

*************
ODBC -- call failed,

[Microsoft] [ODBC Driver Manager] Function sequence error (#0)

*************

Here is my platform:
Windows XP Pro, Access 2003 with SP2, Oracle8i Enterprise Edition Release 8.1.
7.4.0 in the back end.

I removed the ODBC connection then I added it again, unfortunately that
didn't help, I'm still getting the same error message.

can someone please help!

Thanks
 
ODBC errors can be caused by anything from bad data to sloppy programming.
Try a different ODBC driver and if that doesn't work try looking at your
data.

MH

PS. Try doing a web search for your error message, that may provide some
clues.
 
I see this meassage has been out there for a while but I thought I would add
my 2 cents since I do this type of importing/exporting on a daily bases.

When ever I have this problem it's usualy because of a password change or a
server name change since I'm pulling from a clustered envornment. Try
updating your ODBC connections in your PC's administrative tool>ODBC set up
in windows. Update your password or server name then re-establish your link
again.

Hope this helps someone.
 
Back
Top