Remote connections are done with Gofer: http://search.cpan.org/~timb/DBI-1.56/lib/DBD/Gofer.pm
The MacOSX box uses DBD::Gofer to talk to the DBI process over http on the win32 box, which is accessing the MS SQL using the DBD::ODBC. I never used this, but thats my understanding. See the docs. Personally, just for speed alone I would only do this as a last resort. If your DB can be migrated to SQLite you may have a much easier time of things since SQLite runs on most platforms and is bundled in the DBD. Alex On Mon, 11 Jun 2007 09:34:38 -0400, Jordan Mueller wrote > Hello, > > I have a general question and wonder if anyone here may have some > advice on where to start before I try putting together a solution. > > Here is the situation: > > Webserver: MAC OS X server running Apache 1.x > DB: On a remote server running MS SQL server > > How do I set up a connection to this data base using DBI? When I > have been writing perl scripts on win32 web servers, I set up a DSN > (Data source name) on the web server that is an ODBC connection to > the database server and then connect using DBI::ODBC. > > Is there a corollary to this on a MAC OS X server? Or should I go about > connecting in a different way. > > Sorry for the general nature of this question. I tried looking > aroun don the net first and I really could find anything for this > specific situation. > > Thanks, > > Jordan
