----- Original Message -----
Sent: Thursday, August 31, 2000 7:52
AM
Subject: database connectivity
I am having a problem connecting to a database for some
reason. I am using MS SQL server 7 and have obtained the proper driver
(SPRINTA2000) and set up the ODBC data source, however Console has a problem
displaying the tables of the DB. I have tried it this way and using the
generic JDBC:ODBC driver. the two versions of data-sources I have tried
are attached. With the generic driver, I have not found anywhere where
the data source's name is specified for connection, and with the SPRINTA2000
driver, I am having access problems still... would anyone be willing to
walk me through this one?
<data-source
name="Default
data-source"
class="com.evermind.sql.ConnectionDataSource"
location="jdbc/DefaultDS"
pooled-location="jdbc/DefaultPooledDS"
xa-location="jdbc/xa/DefaultXADS"
ejb-location="jdbc/DefaultEJBDS"
url="jdbc:inetdae:localhost?database=dBTest"
-> dBTest is the name of the ODBC
datasource
connection-driver="com.inet.tds.TdsDriver"
username="[dB
Username]"
password="[dB Password]"/>
The generic is the same, but with JDBC:ODBC:EJB in the URL
and the generic driver for connection-driver.
derek Akers.
