Re: connecting to remote MSSQL server from DBI
- From: alex@xxxxxxxxxxxxxx (Alex Teslik)
- Date: Mon, 11 Jun 2007 07:11:52 -0700
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
.
- Follow-Ups:
- Re: connecting to remote MSSQL server from DBI
- From: Tim Bunce
- Re: connecting to remote MSSQL server from DBI
- References:
- connecting to remote MSSQL server from DBI
- From: Jordan Mueller
- connecting to remote MSSQL server from DBI
- Prev by Date: Re: connecting to remote MSSQL server from DBI
- Next by Date: DBI install problem
- Previous by thread: Re: connecting to remote MSSQL server from DBI
- Next by thread: Re: connecting to remote MSSQL server from DBI
- Index(es):
Relevant Pages
|
|
