Re: Witango-Talk: JDBC in OS X Dev Studio

[Robert Garcia]

There are two ways to create a JDBC datasource. You can edit the jdbc.ini file manually in your /library/preferences/witango/ folder. However, it is much easier to right click the JDBC folder and choose New JDBC. At this point, the values entered depend entirely on your JDBC driver (except for name). Each driver has a different value for the driver class, and each usually has a slightly different syntax for the url. You must read the documentation.

After you successfully enter the info, don't hit test, it doesn't seem to work right for me yet, just hit OK, and try to expand (load) the new JDBC source. If the tables load, it worked. If you now open the jdbc.ini file in your preferences folder, you will see that it has been edited for you.

With my driver, I include all info in the URL, except for the user and password.

Robert.

On Friday, July 11, 2003, at 05:58 PM, Steve Smith wrote:

I wanted to try playing around with JDBC data sources, but when I went to create a new data source in the Dev Studio, JDBC was grayed out. I downloaded and installed the new Dev Studio (5.0.9) but they are grayed out there too.

I also noticed that I have a folder inside of the Dev Studio folder called 'Install' which contains a JDBC.ini file and a file called environment.plist. Is this a proper configuration and if not, where do these files belong?

Please let me know.

Thanks,

Steve Smith

Oakbridge Information Solutions
Office: (519) 624-4388
GTA: (416) 606-3885
Fax: (519) 624-3353
Cell: (416) 606-3885
Email: [EMAIL PROTECTED]
Web: http://www.oakbridge.ca

--

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/