|
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.
|
- Re: database connectivity Derek Akers
- Re: database connectivity Shayne Hughes
- RE: database connectivity Holmes, George (TWIi London)
- Re: database connectivity Derek Akers
- RE: database connectivity Holmes, George (TWIi London)
