Hello All,
I'm new to applescript. I've a stored procedure in SQL server that generates a uniqque Jobnumber. I need to run this stored procedure from applescript and display the new job number to the user. How can I achieve this using Applescript? Is there any other alternative? Any suggestion/inputs are welcome.
Thanks
iMac, Mac OS X (10.5)
Ahh, when you said 'SQL server', I didn't realize you meant a remote Microsoft SQL Server.. that does complicate things a little.
In order to call SQL Server from your Mac you're going to need an ODBC driver. There are a couple of them (commercial) that might work, or you could try the JDBC approach via Java (using AppleScript to invoke your Java connection). The specifics of this, though are way beyond me.
Any help on this is greatly appreciated.
There's no simple, direct MySQL interface within AppleScript - that is, you can't (easily) connect to your database directly and execute the stored procedure.
The commonest solution to this is to use the command line mysql interface via do shell script.
set myData to (do shell script "/usr/local/mysql/bin/mysql -u USERNAME -pPASSWORD -e '<SQL statement here>'")
There's a lengthy discussion, including examples, at http://macscripter.net/viewtopic.php?id=24721
Camelot,
The discussion you pointed mainly deals with connecting to locally hosted MySQL server from Applescript. I need to connect to Microsoft SQL Server hosted on a server from applescript. Is there any other way/third party application that will allow me to embed my stored procedure in applescript?
Thanks
Applescript to run SQL Server stored procedure on Mac
