on 08-07-2006 7:37 AM
Hi All,
We are tring to connect to MSSQLServer2000.
XI version is 3.0(SP15).
Do we have to install the driver ??
Which all drivers are vailable by default ??
We tried giving com.microsoft.jdbc.sqlserver.SQLServerDriver.
The following error is seen in adapter monitoring :-
'jdbc:microsoft:sqlserver://mysqlserver:1433;DatabaseName=tempdb'
failed: DriverManagerException: Cannot establish connection to
URL 'jdbc:microsoft:sqlserver://mysqlserver:1433;DatabaseName=tempdb'
: SAPClassNotFoundException: com.microsoft.jdbc.sqlserver.SQLServerDriver
Can anyone help.
Thanks in Advance
Chemmanz
Hi,
<i>Which all drivers are vailable by default ??</i>
No driver is available by default. You need to install the driver to any DB that you want to access.
If a driver is deployed, you will find an entry in the JDBC adapter monitoring saying AVAILABLE DRIVERS : and a list of drivers.
Regards,
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
this link tells you what are the drivers available for any database:
http://developers.sun.com/product/jdbc/drivers
There are some motre details availble on this htread:
Regards
Vijaya
Message was edited by: vijaya kumari
Hi,
To access any Database from XI, you will have to install the corresponding Driver on your XI server.
You need to deploy MSSQL server's driver.
After doing the same, you can connect using following parameters,
Driver:
com.microsoft.jdbc.sqlserver.SQLServerDriver
Connection for MS SQL Server:
jdbc:microsoft:sqlserver://<server>:1433;databaseName=<dbname>
Regards,
Bhavesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.