There are two issues to getting JDBC to working right. First get OS X to see the driver correctly. The best way to do this is take the jdbc driver and put it in the /library/java/extensions/ folder. For my DBMS, it is a single file named "pbjdbc.jar".
The second issue is the connection url and classpath. This should be in the documentation from Oracle, or in the readme from the driver. They must follow the exact syntax your driver requires. Unfortunately, the URL is implemented differently by each DBMS and is not very standard.
Your JDBC driver should have some type of command line test app to compile and run to test a connection. Test your connection to make sure it is setup correctly before attempting to use the studio.
If I had oracle, I could give you exact instructions, but I don't, so these are my instructions on how I got my DBMS to work.
Robert.
On Wednesday, July 9, 2003, at 05:07 AM, Dale Graham wrote:
Mac OS X, 10.2.6, Studio version 5.0.9, Oracle
I can see JDBC in the workspace, and I can add a JDBC datasource, but I get an "Io" error when I attempt to connect...
I have a CLASSPATH set up for the place where the Oracle JDBC driver is located
I am using Oracle's thin client (which I successfully use in connecting using SQL Grinder)
I think I am off on syntax somewhere... here's what my jdbc.ini file looks like (where server name and ports have been changed for security reasons)
I have also tried DriverClass com.oracle.jdbc.Driver but that didn't work, either
<DataSources> <DataSource ID="demodb"> <DSN>demodb</DSN> <DriverClass>oracle.jdbc.driver.OracleDriver</DriverClass> <URL>jdbc:oracle:thin://www.oracleserver.com:9999/demodb</URL> <Properties> <Property ID="server"> <Name>server</Name> <Value> www.oracleserver.com </Value> </Property> <Property ID="port"> <Name>port</Name> <Value>9999</Value> </Property> </Properties> </DataSource> </DataSources>
_______________________________________________________________________ _
TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
--
Robert Garcia President - BigHead Technology CTO - eventpix.com 2781 N Carlmont Pl Simi Valley, Ca 93065 ph: 805.522.8577 - cell: 805.501.1390 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ - http://theradmac.com/
________________________________________________________________________ TO UNSUBSCRIBE: Go to http://www.witango.com/maillist.taf
