Mac ODBC connection to MSSQL on Windows Server

[Len Morgan]

Mark,

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.

len

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
> applications?
> And what other learning resources are there on such things?
>
> Regards,
> Mark Stuart
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution
>
>
>