RE: AppleScript to ODBC?
RE: AppleScript to ODBC?
- Subject: RE: AppleScript to ODBC?
- From: "David Fekke" <email@hidden>
- Date: Mon, 12 Feb 2001 09:42:06 -0500
Ric,
There is a piece of software that I have been looking at called MacSQL
Monitor. It has an AppleScript rating of 5 stars. The web site for this
product is at
http://www.rtlabs.com/macsql/. It allows direct ODBC access.
>
-----Original Message-----
>
Message: 4
>
Date: Mon, 12 Feb 2001 09:53:42 +1100
>
Subject: AppleScript to ODBC?
>
From: Ric Phillips <email@hidden>
>
To: <email@hidden>
>
>
New to this list - so sorry if this is an oft' asked question....
>
>
Is there a simple way (OSAX, or something else) of communicating with an
>
ODBC database from Apple Script?
>
>
I've searched some archives and found some methods that rely on ODBC client
>
components in third party software such as File Maker or Excel that can be
>
driven from AS - but these rely on the client environment having the app.
>
>
I can get information out of a DB using ASP to process the SQL and the
>
Download URL addition to pick up the data. This is better than the above
>
because I have greater control over the server environment than the client.
>
>
I would, however, prefer not to have a third layer at all. Also, the above
>
method can not load the data directly into any Apple Script object or
>
variable, and requires some intermediary file handling on the client
>
machine.
>
>
The more complex a process is the greater the likelihood for bugs - so I
>
thought I'd ask if a more direct access method is available.
>
>
Thanks in advance for any suggestions.
>
>
Ric Phillips
>
>
Computer Laboratory Support Officer
>
Faculty of Humanities and Social Sciences
>
La Trobe University
>
9479 2792