Forgot your password?
typodupeerror
Apple Businesses

Using ODBC in Jaguar? 16

Posted by Cliff
from the unraveling-the-arcane dept.
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?"
This discussion has been archived. No new comments can be posted.

Using ODBC in Jaguar?

Comments Filter:
  • The answer. (Score:1, Informative)

    by /dev/trash (182850)
    ODBC Jaguar [google.com]
    • Hate to tell you, but I did that exact same search. You'll find 20 news articles that say *Wow they decided to include ODBC in Jaguar* and no details. It's all fluff. I wouldn't have submitted to Slashdot if I hadn't done a lot of research first
  • I've seen screen shots with man pages in the console. Why not try that?
  • by bdash (598142)
    A good place to starting looking is at iODBC [iodbc.org]. They provide an SDK with the necessary headers and library to get started. OpenLink [openlinksw.com] provides ODBC drivers for various database engines, as well as a 'Cross-Platform ODBC SDK'.
  • Check out Mac SQL (Score:3, Informative)

    by Corvus9 (300802) on Monday October 07, 2002 @01:48AM (#4401005)
    There is a Mac OS X SQL front end called Mac SQL available from RunTime Labs [rtlabs.com] that includes ODBC drivers for mSQL, mySQL, and Sybase. I believe Metro Technologies [metrotechnologies.com] has Mac OS X ODBC drivers for Oracle.

    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.

  • 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]
    "OpenLink has a full complement of Drivers for use on Mac OS X, including Jaguar. Single-Tier drivers supporting connections to MySQL, MS SQL Server, Sybase, Oracle, PostgreSQL, Virtuoso, and the Generic Multi-Tier driver, are all available for download now.


    They all come with the OpenLink ODBC Administrator (a/k/a the iODBC Administrator), and the Aqua-Frameworks implementation of iODBC. Other OEM and third-party drivers will become available in the future, I'm sure.

    Apple ships the Darwin-level iODBC components, at this time, with a rudimentary ODBC Administrator -- only capable of keyword-value pair DSN configuration. This is a proof-of-concept application, while the OpenLink ODBC Administrator is a mature application, capable of delivering driver-specific configuration panels, based on Setup Libraries shipped with the Drivers."

    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.

  • Marc Liyanage's one-click postgreSQL [entropy.ch] comes with some html docs for ODBC setup and config. Use the defaults and they're dropped in
    /usr/local/pgsql/doc/html/
  • Check out the iODBC.org website [iodbc.org] and the OpenLink Software website [openlinksw.com].

    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

"An open mind has but one disadvantage: it collects dirt." -- a saying at RPI

Working...