Using ODBC in Jaguar? 16
dmayle asks: "I've decided to do some Mac-based database development, and, since Apple was kind enough to include ODBC Administrator, I decided to use that as a starting point. The only problem is, there doesn't seem to be ANY documentation anywhere about it. I know that PostgreSQL for Mac includes an ODBC driver, but again, I can's seem to find out any docs on how to use it... Are there any developers using this tool out there, and where did you learn how to do it?"
Re:ODBC == Microsoft (Score:3, Informative)
Sorry I don't have any more about ODBC for OS/X, but since it's unix-like, it's got a 95% chance of being UNIXODBC or iODBC. It's also undoubtadely documented on apple's developer site, which is probably why you can't find any documentation anywhere else.
Re:ODBC == Microsoft (Score:1, Informative)
The answer. (Score:1, Informative)
Re:The answer. (Score:1)
man pages? (Score:1)
iODBC (Score:1)
Re:New hardware on apple.com? (Score:1)
Check out Mac SQL (Score:3, Informative)
The person to ask about this is Marc Lilback; he wrote the ODBC stuff for OS X; his web site at www.lilback.com [lilback.com] has drivers, sample code, and ports, but I believe he charges for this. Mac SQL databases are his livelihood.
Proof of Concept (Score:1)
From the about tab in the ODBC Administrator application, I saw that they were using iodbc librarys. A quick search of the web boards at iodbc.org turned up this from an iODBC developer:
http://www.iodbc.org/wwwboard/messages/1423.html [iodbc.org]So maybe he's right and the OSX app is just a proof of concept. The interface looks very similar to the ODBC interface on windows. If you have experience with windows ODBC, you might be able to get the mac one working.
This comes with some docs... (Score:1)
[i]ODBC on Jaguar (Score:1)
The ODBC components in Jaguar (and Darwin) are based on the open-source iODBC project, supported, coordinated, and maintained by OpenLink Software.
The ODBC Administrator supplied by Apple is a very basic application, capable only of assisting the knowledgeable user in keyword-value pair editing and creation of DSNs.
The OpenLink ODBC Administrator, a/k/a the iODBC Administrator, is installed with all OpenLink Single-Tier and Multi-Tier Drivers for ODBC. This Administrator handles Setup libraries, and provides full GUI dialogs for DSN configuration when the Drivers have been built for such.
Full user documentation is in progress, and developer documentation is available now from the iODBC.org site. Free support for both may be found through the iODBC.org web forum, or through the OpenLink Support pages. You can also chose to write directly to <technical.support@openlinksw.com> [mailto].
Enjoy,
Ted Thibodeau Jr Consultant OpenLink Software