Re: SQL database and applescript?
Re: SQL database and applescript?
- Subject: Re: SQL database and applescript?
- From: Caleb Strockbine <email@hidden>
- Date: Mon, 1 Apr 2002 16:11:03 -0500
On Sunday, March 31, 2002, at 11:14 AM, Simon Topliss wrote:
Consider this a complete and utter begging email. I'd sell my
grandmother
for an OSAX that can get SQL data from MS SQL 2000 Server without the
need
for some relatively expensive middleware like MacSQL. This is a massive
project for us this year. We are still looking for some sort of
solution for
OS9 and OSX to enable us to get data from a SQL Server 2000 box into our
Adobe Illustrator artworks. This will run on about 80 macs so cost is a
major factor.
Perhaps you should take a look, if you haven't already, at REALbasic.
Applications developed with RB can connect to MS SQL Server as well
as many other databases. You'll need the Professional version to do real
work with databases, but you can download the demo for free and use
small numbers of records. I guess in your situation you'd build an app
that gets data from SQL Server and sends it to Illustrator, or just
makes it
available to AppleScript scripts. In that case, you'll only need one copy
of REALbasic, since there's no royalty on the apps you build with RB.
http://www.realsoftware.com
At the moment, the most cost effective solution is XML-RPC or SOAP as
we run
all the intranet, internet and databases on the very nasty MS Back
Office.
Mainly because PC developers are easier to find and employ in the North
of
England. Although I'm trying to push them towards a more mac compatible
solution from their end MySQL/PHP/Apache running on OSX.
You'll probably meet with less resistance if you push more for tools that
use open standards and don't worry too much about what platform those
tools run on. MySQL, PHP, and Apache are probably just as Mac-friendly
when
run on Solaris or Windows as they are when run on OS X.
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.