ODBC -- call failed

[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

 

[MH]

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.

 

[kris]

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.