----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files.  Don't make us guess your problem!!!
----------------------------------------------------------------

I have seen this ODBC error come up in other environments... it usually
refers to a cursor problem, sometimes related to the ODBC driver
configuration... if close cursors on commit is set, then you must make sure
you do not try to re-use an open cursor after the commit.  Most ODBC drivers
allow you to turn this off, or set keep cursors open after commit.

- Greg

-----Original Message-----
From: Steve Mente [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 01, 2000 11:52 AM
To: '[EMAIL PROTECTED]'
Subject: Function Sequence Error


----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files.  Don't make us guess your problem!!!
----------------------------------------------------------------

I have just completed configuring Apache 1.3.11 / JServ 1.1/ GNUJSP 1.0 on
an NT 4.0 server.  I am opening connections to a SQL database and doing
simple SELECTS and INSERTS using servlets and JSP pages. My problem is that
I keep receiving error.  The strange thing is that the database connection
works fine 1 time and then the next time pops up this error.  I had similar
results trying to use JRun.  Do I have an issue with my code, the database
driver, configuration, or some combination of these?  Any help would be
greatly appreciated.

Steve Mente
Metrix, Inc. 
[EMAIL PROTECTED]

java.sql.SQLException: [Microsoft][ODBC Driver Manager] Function sequence
error
        at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:4089)
        at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:4246)
        at sun.jdbc.odbc.JdbcOdbc.SQLColAttributesString(JdbcOdbc.java:752)
        at
sun.jdbc.odbc.JdbcOdbcResultSetMetaData.getColAttributeString(JdbcOdbcResult
SetMetaData.java:702)
        at
sun.jdbc.odbc.JdbcOdbcResultSetMetaData.getColumnName(JdbcOdbcResultSetMetaD
ata.java:361)
        at
sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(JdbcOdbcResultSet.java, Compiled
Code)
        at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java,
Compiled Code)
        at com.metrix.simple.DbRequest.getRequest(DbRequest.java, Compiled
Code)
        at jsp___2frid_2ejsp._jspService(jsp___2frid_2ejsp.java:72)
        at org.gjt.jsp.HttpJspPageImpl.service(HttpJspPageImpl.java:75)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
        at org.gjt.jsp.JspServlet$Page.process(JspServlet.java, Compiled
Code)
        at org.gjt.jsp.JspServlet.service(JspServlet.java:284)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
        at
org.apache.jserv.JServConnection.processRequest(JServConnection.java:314)
        at org.apache.jserv.JServConnection.run(JServConnection.java:188)
        at java.lang.Thread.run(Thread.java:479)


--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Archives and Other:  <http://java.apache.org/main/mail.html>
Problems?:           [EMAIL PROTECTED]


--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Archives and Other:  <http://java.apache.org/main/mail.html>
Problems?:           [EMAIL PROTECTED]

Reply via email to