Granny's Programming Pearls
"inside of every large program is a small program struggling to get out"
The moose likes JDBC and Relational Databases and the fly likes Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark ""Function sequence error!" what is it mean" Watch ""Function sequence error!" what is it mean" New topic

"Function sequence error!" what is it mean

Huzefa Zohaib
Ranch Hand

Joined: Nov 21, 2001
Posts: 40
The following Exception
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Function sequence error
is occuring on the following code.
What does this error means and why is occuring.
Joe Ess

Joined: Oct 29, 2001
Posts: 9189

What the "function sequence error" means is that the sequence of opening a statement, initalizing a result set, reading the result set (most often from beginning to end, from left to right) and releasing resources has not been performed in the proper order. I've seen this exception when someone tries to read from a result set before calling
This may be the offending code. Closing the statement also may release the result set. However, you should not rely on it and close both after you are finished with them.
[ October 06, 2003: Message edited by: Joe Ess ]

[How To Ask Questions On JavaRanch]
I agree. Here's the link:
subject: "Function sequence error!" what is it mean
It's not a secret anymore!