Hi, all,
I am experimenting OJB against a MSSQL 2000 db. I have the following
settings in the repository.xml:
<jdbc-connection-descriptor
platform="MsSQLServer"
jdbc-level="2.0"
driver="com.microsoft.jdbc.sqlserver.SQLServerDriver"
protocol="jdbc"
subprotocol="microsoft:sqlserver://server"
dbalias="1433;Database=Test"
username="sa"
password="dev"
/>
The reason I have set it this way is because the M$ jdbc driver can only
connect to the db server using the following url
jdbc:microsoft:sqlserver://server:1433;Database=Test
If I set 'subprotocol' as "microsoft:sqlserver://server:1433" and 'dbalias'
as "Test" then the resultant url will become
jdbc:microsoft:sqlserver://server:1433:Test
and the driver will fail the connection because of invalid url.
I wonder:
1) If it is a problem with M$ jdbc driver (not conforming to the jdbc url
standard) or is it a bug with OJB (cannot properly formed a url specific to
the mssql when the platform is set to 'MsSQLServer')?
2) Matthew Baird has kindly mentioned to me that there is acutally a
alternative driver called jnet for MSSQL. What would be the proper settings
to these fields if I were to use the jnet driver? Where can i obtain more
info about this driver?
3) When I used the above setting, i can establish a connection with the
database server. However the current catalog is 'master' instead of the
'Test' database. Hence when the sql is issued to the server, the server
returns an error message: invalid object, because the table does not exist
in the master database. Did i miss something in the setup process?
Regards,
Anthony
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
