Specifying Database url in datasource

[Ashutosh Shinde]

Hello everyone,
I am working on Websphere version 5.0. I am trying to connect to a Lotus Database. However, I am unable to locate the place where I can set the database URL along with the user name and the password while creating the datasource. Any pointers in this regard would be most helpful. Thanks in advance.

-- Ashutosh

[david dhavan]

there are 3 steps to it.
1. create a JDBC Driver.
- specify implementation class.
(If your driver is not listed you can add your own custom driver with an implementation class provided by vendor.)
2. create a DataSource.
3. Click on custom properties. You can now add all the properties as specified by the vendor in the key-value form one by one.
4. Click Apply-Ok and then at the end save master configuration for that to take effect.
Hope this helps
David

[Scott Duncan]

data source should be set up on the box as well

[Kevin Black]

Hi, David and William,
I am having problem in create a database connection to Access DB using WSAD 4.03. And when I see your post, I think maybe I can use the same way for Lotus to Access DB.

Question:
When you say: "create a JDBC Driver.
- specify implementation class.
(If your driver is not listed you can add your own custom driver with an implementation class provided by vendor.)", MS-Access driver is not listed, so, which driver should I use?

2. create a DataSource.
I can only create a datasource after I setup the driver. What happen if I don't have a driver, can I still setup this.
Thanks for your help!
Kevin

[Scott Duncan]

OK Kevin,
When I say make sure the datasource is set up on the box, I mean do you have a datasource instance configured on your machine? If you go to the ODBC Data Source Administrator (Start->settings->contol Panel->ODBC Data Sources). Here, you will see under the drivers tab Driver do Microsoft Access (*.mdb) if MS Access is installed. This ODBC Data Source Administrator is where you need to set up your datasource for MS Access. As far as connection pooling goes, you are wasting your time unless you can find a proprietary JDBC driver as Kyle mentioned in the other thread.
[ February 04, 2003: Message edited by: William Duncan ]

[Ashutosh Shinde]

Hello everyone,
Thanks everyone. I could connect to SQL server with the inbuilt driver provided by Websphere. My main aim was to connect to Lotus (-- this is how I started with the exercise before moving to SQL Server). However, since the Driver that I have (Lotus Driver for JDBC) does not implement the ConnectionPoolDataSource interface,, I was not able to connect to the database using the datasource! Is anyone aware of a JDBC driver for Lotus that implements the interface ? Thanks..
-- Ashutosh