Derek,
The
Sprinta driver connects directly to the SQL Server and does not utilise an
ODBC data source.
The
url string should follow this format:
url="jdbc:inetdae:futdb1?database=TheDatabase1&sql7=true"
In
this example,
futdb1 is the NetBIOS (you can use
an IP address also) of the database server
TheDatabase1 is the name of the
actual SQL Server database
sql7=true allows you to use the
(new) data-types such as text,ntext
The
# escape character must be included in the url for some reason. The
driver won't work with Orion without it (in my experience
anyway)
Hope
this helps.
George
GEORGE HOLMES
TWI Interactive
Media House
Burlington Lane
LONDON
W4
2TH
ENGLAND
TEL: +44 208 233 5631
FAX: +44 208 233 7701
CELL: +44 7968
918813
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.
