|
Dear Timothy,
Thanks so much for replying =)
I thought you don't have to set classpath for ODBC
driver. I thought it's all done when I set the System DSN in
ControlPanel->ODBC Administrator. And when I want to make a connection to the
DSN I just use:
Class.forName( "sun.jdbc.odbc.JdbcOdbcDriver"
).newInstance();
connDB = DriverManager.getConnection( "jdbc:odbc:FroggoDB", "sa", ""); //FroggoDB is the name of the DSN
FYI, I was able to connect to a MSAccess db. But because using MSAccess gives
me a "Cannot open anymore tables" error, I thought I should try SQL Server. But
looks like I can't even make the connection yet :(
How do I know where my SQL
Server 7.0 ODBC driver is? What type of file will it be? .jar? .exe?
.dll?
Best regards, Kim.
----- Original Message -----
Sent: Sunday, January 23, 2000 8:38
PM
Subject: Re: OFF-TOPIC: ODBC Error
dear kim,
i think your class path setting and your path
setting is wrong...
try pointing it to where your ODBC driver is..
for mi i use weblogic so it is in my weblogic bin dir..
timothy
----- Original Message -----
Sent: 23 January 2000 17:50
Subject: OFF-TOPIC: ODBC Error
Dear all,
I know I'm a bit off-topic but I'm desperate....
If anyone of you have come across this error before, I would very much
appreciate your input.
I have a JSP page that connects to a MS SQL
Server 7.0 database. When I point my browser to the JSP page, I get the
following error:
An error occurred: [Microsoft][ODBC SQL Server
Driver]Invalid Descriptor Index
java.sql.SQLException: [Microsoft][ODBC SQL
Server Driver]Invalid Descriptor Index
at
java.lang.Throwable.(Compiled Code)
at
java.lang.Exception.(Compiled Code)
at
java.sql.SQLException.(SQLException.java:43)
at
sun.jdbc.odbc.JdbcOdbc.createSQLException(Compiled Code)
at
sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:3814)
at
sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(Compiled Code)
at
sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(Compiled Code)
at
sun.jdbc.odbc.JdbcOdbcResultSet.getString(Compiled Code)
at
sun.jdbc.odbc.JdbcOdbcResultSet.getString(Compiled Code)
at
pagecompile._sigma._login_xjsp._jspService(Compiled Code)
at
newatlanta.servletexec.JSP10HttpJspPage.service(JSP10HttpJspPage.java)
at
newatlanta.servletexec.JSP10Servlet.service(JSP10Servlet.java)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
at
newatlanta.servletexec.ServletExec.processServletRequest(ServletExec.java)
at
newatlanta.servletexec.ServletExec.processServletAlias(Compiled Code)
at
newatlanta.servletexec.ServletExec.ProcessRequest(Compiled Code)
at
newatlanta.servletexec.ServletExec.ProcessRequest(ServletExec.java)
|
