To get the Test button to work, you also have to add the driver to the
classpath for the admin server (and restart the admin server).
HTH
Randy Nielsen
Allaire Corp.
-----Original Message-----
From: Piotrowski, Brian [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, November 14, 2000 2:06 PM
To: JRun-Talk
Subject: SQL Server, IIS 5.0 and JRUN - JDBC-ODBC drivers
Hi Folks,
I'm having some problems interfacing with our SQL Server, and I'm wondering
if anyone can help?
I have successfully set an ODBC connection to one of our databases on our
SQL 7.0 server. JRUN and IIS 5.0 are working fine together. The problem I
am having is getting the JRUN server to talk to the ODBC connection I set
up.
I downloaded a copy of an JDBC-ODBC driver called JTURBO. It currently sits
on our server's C: drive in C:\JTURBO-420\. I added this to the classpath
of the default server, and added this information in as the jdbc source:
Name: dupontdb (the DSN of my ODBC connection)
Display name: dupont
Driver: com.ashna.jturbo.driver.Driver
URL Name: jdbc:JTurbo:dupontdb
I then save it and go back to the JDBC menu. When I click TEST, I get the
error "No valid JDBC driver is specified". Can someone point out my
(obvious?) error!??!
Here are my two lines in the classpath list:
/JTurbo4-20/com/ashna/jturbo/driver (I added this one to see if it would
solve the error - it didn't).
/JTurbo4-20
I have stopped and started the JRUN server, but it didn't make any
difference (I thought I might need to do this to have it update its
classpath).
Thanks in advance,
Brian.
-----------------------------------
Brian Piotrowski
Developer / Network Administrator
Moneyramp.com
(705) 475-9531
www.moneyramp.com
-----------------------------------
----------------------------------------------------------------------------
--
Archives: http://www.egroups.com/group/jrun-interest/
Unsubscribe:
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe'
in the body.
------------------------------------------------------------------------------
Archives: http://www.egroups.com/group/jrun-interest/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/jrun_talk
or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the
body.
