Re: Apps for Querying MSSql with AppleScript
Re: Apps for Querying MSSql with AppleScript
- Subject: Re: Apps for Querying MSSql with AppleScript
- From: "Gary (Lists)" <email@hidden>
- Date: Fri, 24 Jun 2005 12:26:30 -0400
"Dana Hill" wrote:
> On Jun 24, 2005, at 9.16 AM, Jason Bourque wrote:
>
>> Hello,
>>
>> Does anyone have any recommendations for apps that can connect to and
>> query
>> a Microsoft SQL Databases with AppleScript? I have Mac OS X 10.4.1
>> FileMaker
>> Pro 7.
>>
>>
>> Thanks for the help.
>>
>> Jason Bourque
> Hi Jason,
>
> I am using FileMaker Pro 7 to do just this. I call a couple FM scripts from an
> AppleScript to do the communicating. Let me know if you like a few snippets...
>
> Dana Hill
Jason, I don't what FM connectors are working with _MS_ SQL, but perhaps
we'll see from Dana's snippets.
For SQL in general, I am using a free tool called "SQL4AppleScript",
which can be read about here: <http://www.yvs.eu.com/otherproducts.html>
and downloaded from here:
<http://www.yvs.eu.com/downloads/mySQL4AppleScript.sit.hqx>
There are all the typical methods for SELECT, CREATE, DROP and so forth, in
wide-open AS handlers.
Even if they are not out-of-the-box ready for MS_SQL, they may be useful
models for constructing proper handlers.
I am using MySQL on my OS X desktop and that tool allows me to integrate
with FileMaker Pro rather well -- since it's AppleScript.
In the Not Scriptable But Useful category, I have found "YourSQL" a very
useful OS X app that provides SQL front-end. Many kinds of connections can
be made, including socket connect, so you might find it a useful utility for
MSSQL.
Additionally, SQL has just released two new OS X desktop applications, one
called "MySQL Administrator" and the other "MySQL Query Browser". I have
been using them for one week -- they are in beta -- and have found them
useful as well (some quirks in the Admin tool regarding user privileges, but
nothing that could not be overcome by a config edit.)
HTH,
--
Gary
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden