Remote Database Access

calamonius has asked for the wisdom of the Perl Monks concerning the following question:

I've got a MSSQL (I know boo hiss, but it's what I have to work with) database on a Win2k box that I'd like to be able to update from one of the linux boxes on my LAN, rather than running Win32Perl on IIS.

How do I specify a remote server using this style of function call:

DBI->connect('DBI:driver:database','username','password');
??????????????????????????????????????????????????

Edit - footpad, Sun Nov 18 07:02:23 2001 (UTC).

Comment on Remote Database Access Download Code

Replies are listed 'Best First'.
Re: Remote Database Access by hopes (Friar) on Nov 18, 2001 at 08:49 UTC
Hi, from DBI documentation Examples of $data_source values are: dbi:DriverName:database_name dbi:DriverName:database_name@hostname:port dbi:DriverName:database=database_name;host=hostname;port=port Hope this helps Hopes	[reply]