----------------------------------------------------------------
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!!!
----------------------------------------------------------------
The jdbc-ocbc driver is known to be buggy. You may solve this problem but you'll find
others. (Sun's site now refers to it as a
proof of concept only) I have used the freetds jdbc driver with decent results (but
again some problems but at least these are being
worked on and if you have more time than cash there are things in it you can fix
yourself)
We just purchased the una jdbc driver from http://www.inetsoftware.de
The enterprise license (any machines/uses on one site) is only $800. The drivers seem
pretty solid.
They have a one machine intranet license too for only $120. Also the usual 30 day
trial version.
HTH
***********************************************************
Brett Knights 626-432-5767 work
[EMAIL PROTECTED] 626-355-1017 home
***********************************************************
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> Steve Mente
> 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(JdbcOdbc
> ResultSetMetaD
> ata.java:361)
> at
> sun.jdbc.odbc.JdbcOdbcResultSet.findColumn(JdbcOdbcResultSet.j
> ava, 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(JServConnectio
> n.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]
