Re: connecting to remote MSSQL server from DBI

On Mon, Jun 11, 2007 at 07:11:52AM -0700, Alex Teslik wrote:
Remote connections are done with Gofer:

http://search.cpan.org/~timb/DBI-1.56/lib/DBD/Gofer.pm

Just to completeness I should add that if you need transactions
or are handling very large result sets (relative to available memory)
then DBD::Proxy is a better fit.

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.

Since Jordan is familar with using DBD::ODBC I'd suggest that,
or DBD::Sybase+FreeTDS, are worth exploring on the Mac.
(Though I've no experience with either on the Mac.)

The

Tim.

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
.

Relevant Pages

  • Re: Connect Powerbook G4 (OS X 10.4.10) to SBS2003
    ... I was able to make the VPN connection from the Powerbook, ... This is probably due because I am not logged into the server from ... Also on this machine is a version of MS Office for Mac ...
    (microsoft.public.windows.server.sbs)
  • Re: Mac file names too long??
    ... > Thank you for posting in SBS newsgroup. ... > networking settings on the MAC; modify the directory service options; ... > some settings on the SBS server need to be changed. ... > I. Check the TCP/IP properties of the MAC client. ...
    (microsoft.public.windows.server.sbs)
  • Re: MacSrv Event ID 12061 Errors
    ... Connections can be slept on a per connection basis - the Mac client may or ... monitor tool on the server and looking at the time stamps of the traffic ... Mac clients will prefer afp over TCP/IP if the server supports it. ...
    (microsoft.public.win2000.macintosh)
  • Re: Cannot enable OWA on SBS Standard SP1
    ... include any and all Mac machines. ... is not looking to the server for DNS. ... Server ipconfig: ... Ethernet adapter Server Local Area Connection: ...
    (microsoft.public.windows.server.sbs)
  • Re: Mac OS X users cannot connect to shared drives on SBS
    ... To connect MAC OSX computers to SBS 2003 network, ... Services for Macintosh on SBS 2003 server to provide file and printer ...
    (microsoft.public.windows.server.sbs)