Creating a new Driver/DataSource in Visual Administrator

[Former Member]

Hello,

I have been struggling to create a Data Source for a SQL Server DB in Visual Admin. I did the following.

1) Created a new Driver MSSQL, added to it msutil.jar, mssqlserver.jar and msbase.jar.

2) Created a new data source gave it a name, description

- Selected the MSSQL driver which I just created

- JDBC Version 1.x

- Driver class:

com.microsoft.jdbc.sqlserver.SQLServerDriver.class

- Database URL:

jdbc:microsoft:sqlserver://xxx.xxx.xx.xx:1433;databaseName=TestDB

3)Tried both Open SQL and Vendor SQL as database engines.

4) Gave the appropriate user id and password

With the above configuration when I entered a SQL Statement in the 'DB Initialization' tab and executed it, I got a SQL Server Driver Class not found exception.

My second configuration was to use the JDBC Version 2.0

with the following settings:

1) Use the same MSSQL driver which I created

2) JDBC Version 2.0

3) Object Factory: com.microsoft.jdbcx.sqlServer.SQLServerDataSourceFactory

4) DataSource Type: ConnectionPoolDataSource

5) CPDS classname: com.microsoft.jdbcx.sqlServer.SQLServerDataSource

6) Gave the required key, values in the 'Additional' Tab

7) Chose Vendor SQL as the SQL Engine.

With the second configuration I can connect and talk to the database.

Why would I not be able to connect to the DB in my first configuration? Are there any other configuration steps I am missing for using the JDBC 1.0?

Thanks,

Asheesh

[Former Member]

Hi Asheesh,

just put com.microsoft.jdbc.sqlserver.SQLServerDriver in the Driver Class instead of com.microsoft.jdbc.sqlserver.SQLServerDriver.class

[darrell_merryweather]

If you are trying to create a new DBPool then you can use the OSS note 706216. This describes the method of adding the connection pools using the commands in the telnet console

I hope this helps

D

[Former Member]

Hello Darrell,

I am not sure what a DBPool is... but I am trying to configure a new JDBC Connector service for a SQL Server Data Source(within the visual administrator utility). Any help on this topic is appreciated.

Thanks,

Asheesh