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