Re: connecting to remote MSSQL server from DBI

I would look to see if there is a direct - and I think there is - MS SQL driver for DBI, which means you can bypass the ODBC piece all together.

Within your perl programs, after calling DBI, you should be able to directly run your SQL commands(including the initial connection call) to the MS SQL server.

Apache 1.x is kind of old, if it works for what you're doing great, but would look to use 2.+ .

On Mon, 11 Jun 2007, 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


--
Louis Gonzales
louis.gonzales@xxxxxxxxxxxxxx
http://www.linuxlouis.net

.

Relevant Pages

  • Re: Connection issues between .Net framwok and SQl Express 2005
    ... You will no longer need the database MDF file name in the connection string. ... simply attach the ASPNETDB.mdf to SQL Server permenantly, ... as USER INSTANCE on existing SQL Server Express, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Performance of ODBC
    ... if you have a software firewall; forward 1433/1434 to your server ... I've now created my own server with SQL Server 2005 Express, ... glitch concerns the Upsizing Wizard. ... I originally set up my ODBC connection via ...
    (microsoft.public.access.adp.sqlserver)
  • SQL 2005 Express and VS .Net 2003 wizard error More options
    ... Open the server explorer panel ... Go to the Provider tab and select SQL NAtive Client (DON'T use oledb ... Go back to the Connection tab and carry on setting up the connection ... I have installed Visual Studio 2005 Professional and then Visual Studio ...
    (microsoft.public.sqlserver)
  • Re: Timeout problem with SS2K, VS03
    ... I noticed calls in sql profiler: ... This is the server side debug stored procedure. ... a timeout issue that I cannot identify the source of. ... transaction is committed and the connection is closed cleanly and all ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cannot connect to SQL Express on 2003 Machine from XP machine
    ... listening on UDP 1434 using netstat -abn, ... And i double checked the connection string, and i did have it the right ... But I have another 2000 server that I can connect to fine, ... I am trying to connect from an XP SP2 machine remotely to a SQL Express ...
    (microsoft.public.sqlserver.connect)