使用Perl脚本连接到远程计算机的Sql Server数据库 [英] Connecting to the Sql Server database of a remote machine using Perl script

问题描述

我正在尝试连接到远程机器的sql server数据库并使用Perl Script获取一些信息。

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已修改如下，以便连接到远程机器的sql server

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='10.1.8.95'
    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...

推荐答案

dsn = ' DBI：ODBC： Driver = {SQL Server}';
my

dsn = 'DBI:ODBC:Driver={SQL Server}'; my

host = ' MyPC\SQL';
my

host = 'MyPC\SQL'; my

数据库 = databasename';
my

database = 'databasename'; my

这篇关于使用Perl脚本连接到远程计算机的Sql Server数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！