Also, you can directly edit the jdbc.ini file (CAREFULLY). You need some specialized info from OpenBase to do so, see below (and I don't know what that is).
Make a copy of your jdbc.ini file before you begin.
Have the editor OFF while you edit.
If the editor crashes when you re-open it (before doing anything else), you've messed up the jdbc.ini file - replace it with the copy and try again. (Always saving a copy...) If you lose the copy, delete the bad file and start over. Witango will recreate a blank jdbc.ini file for you.
If the edit went OK, the editor will open and you'll be able to see your new datasource.
Then if you cannot connect, you need to be sure that you have the path set for Witango to the location of the driver, that you have the parameters correctly set (db domain name, etc), etc...
Here are two examples - notice how different the formatting is from DB to DB type, and the differences in the DriverClass specifications and the URL.. all of these have to be just right for the DB in question. It's the same from platform to platform and I am sure OpenBase has this info posted somewhere.
ORACLE:
<DataSource ID="oracleDB">
<DSN> oracleDB </DSN>
<DriverClass>oracle.jdbc.OracleDriver</DriverClass>
<URL>jdbc:oracle:thin:@db.domain.name:9999:SID</URL>
<Properties />
</DataSource>
MySQL:
<DataSource ID="mysqlDB">
<DSN> mysqlDB </DSN>
<DriverClass>com.mysql.jdbc.Driver</DriverClass>
<URL>jdbc:mysql:/db.domain.name:3306/mysqlDB </URL>
<Properties>
<Property ID="server">
<Name>server</Name>
<Value>db.IP.address</Value>
</Property>
<Property ID="port">
<Name>port</Name>
<Value>3306</Value>
</Property>
</DataSource>
On Mar 8, 2004, at 2:59 PM, Tom Storey wrote:
I'm trying to connect Witango Studio with JDBC Driver to OpenBase. The last email I got from OpenBase said the following:
I think that makes us even then because I've never used Witango <image.tiff>
The JDBC drivers do come with OpenBase.
If you look in /Library/Java/Extensions you should see a file called
OpenBaseJDBC.jar
How to set up Witango to use JDBC drivers is not something I know how
to do and is probably something specific to Witango.
I looked in /Library/Java/Extensions for OpenBaseJDBC.jar and it was there. I started Witango Studio. I looked in DataSource menu went to NEW selected JDBC, a message came up saying "The application Witango has unexpectedly quit". I restarted Studio, try this 3 times, each time this message came up. After 2 days of back and fourth with OpenBase I've about had it. Can any of you tell me were I've gone wrong.
Thanks for your help,
--
Tom Storey
Research & Accountability
Pinellas County Schools
Largo, Fl
(727) 588-6254
[EMAIL PROTECTED]
--
The box said: "Requires Windows XP, or better."
So I bought a Macintosh with OS X…
--
