Click here to Skip to main content
11,802,389 members (30,609 online)
Rate this: bad
Please Sign up or sign in to vote.
See more: Perl SQL-Server
i am trying to connect to the sql server database of remote machine and fetch some information using Perl Script.
use DBI;
 y $dsn = 'DBI:ODBC:Driver={SQL Server}';
my $host = 'MyPC\SQL';
my $database = 'databasename';
my $user = 'username';
my $auth = 'password';
my $dbh = DBI->connect("$dsn;Server=$host;Database=$database;$user;$auth") || die "Database connection not made:: $DBI::errstr";
i have modified this as follows, inorder to connect to the sql server of remote machine

use DBI;
    my $dsn = 'DBI:ODBC:Driver={SQL Server}';
    my $host = 'MyPC\SQL';
    my $database = 'databasename';
    my $user = 'username';
    my $auth = 'password';
    my $hostIP=''
    my $dbh = DBI->connect("$dsn;Server=$host;Database=$database;host=$hostIP;$user;$auth") ||die "Database connection not made:: $DBI::errstr";

but i am getting an error saying that connection string is wrong.
can anyone please help me...
Posted 6-Jun-13 20:47pm

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1


Please Change your connect call as shown below.
my $dbh = DBI->connect("$dsn;Server=$hostIP;Database=$database;",$user,$auth) ||die "Database connection not made:: $DBI::errstr";
More help can be found in this document.


This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 475
1 KrunalRohit 366
2 F-ES Sitecore 295
3 Afzaal Ahmad Zeeshan 230
4 CHill60 220
0 OriginalGriff 2,950
1 Maciej Los 1,910
2 KrunalRohit 1,862
3 CPallini 1,645
4 Richard MacCutchan 1,157

Advertise | Privacy | Mobile
Web02 | 2.8.151002.1 | Last Updated 7 Jun 2013
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100