Are you trying to use the JDBC/ODBC bridge? If it's an ODBC driver, then try
changing the URL Name to this: jdbc:odbc:dupontdb

HTH,
Patrick Quinn
Allaire Consulting

-----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.

Reply via email to