Mac ODBC connection to MSSQL on Windows Server
len-morgan at crcom.net
Thu Nov 19 22:01:46 CST 2009
If you've got a functional ODBC driver on the MAC it should work just
like it was on Windows. At the wire level, it's just talking on sockets.
As far as using it in a revLet, it appears all of us that have this need
are, shall we say, screwed. You will have to have some sort of .cgi
process on a server somewhere that will be able to talk ODBC to the
database server and use sockets to talk to the revLet(s). It can be a
simple as passing the parameters you were going to pass to the revDB
call along with the name of the routine (as text) and then excute this
on the cgi end to talk to the "real" database. It's quick and dirty but
should be easy to get up and running. You can make it more robust later
if there's a hurry to get something done.
Better yet, get after runRev to give us someway to communicate with
databases from revLets and the problem will be solved.
Mark Stuart wrote:
> Hi all,
> A colleague of mine wants to build a revWeb internet application that
> accesses data from a MSSQL Server on a Windows server. He wants to
> deploy this application as a cross platform application.
> How would he go about that, as the application has the
> revOpenDatabase("odbc"...) in the scripts?
> And if using on ODBC connection on a Mac, the MSSQL ODBC driver has to
> be installed and a DSN defined as well, right?
> I've been building Windows deployed applications, and don't know what to
> tell him.
> Are there any ODBC MSSQL connection tutorials for cross platform
> And what other learning resources are there on such things?
> Mark Stuart
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the use-livecode