Question

我有一个用户id、密码、数据库名称和数据源详细信息。我想用Perl连接到MSSQL服务器。我只是使用了下面的片段，但我得到了一个错误。

#!/usr/bin/perl -w
use strict;

use DBI;

my $data_source = q/dbi:ODBC:192.168.3.137/;
my $user = q/bharani/;
my $password = q/123456/;

# Connect to the data source and get a handle for that connection.
my $dbh = DBI->connect($data_source, $user, $password)
    or die "Can t connect to $data_source: $DBI::errstr";

我的错误是：

DBI connect( 192.168.3.137 , bharani ,...) failed: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQL-IM002) at my sqlconnect.pl line 14
Can t connect to dbi:ODBC:192.168.3.137: [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified (SQL-IM002) at mysqlconnect.pl line 14.

SQL服务器运行在另一个系统上，我只是想连接到上面的详细信息。请告诉我，我应该在我的系统中增加DSN，还是我的程序中缺少什么？

Answer 1

连接字符串中dbi:ODBC:后面的所有内容都传递给ODBC驱动程序。对于MSSQL，请尝试以下连接字符串：

DBI->connect("dbi:ODBC:Driver={SQL Server};Server=192.168.3.137;UID=$user;PWD=$password")

您可以在connectionstrings.com

Answer 2

I am on Ubuntu (20.04) and followed the instructions to install SLQ Server in a docker container: https://learn.microsoft.com/en-us/sql/linux/quickstart-install-connect-docker?view=sql-server-ver15&pivots=cs1-bash

我根据教程创建了TestDB和Inventory表。

I installed the ODBC driver following https://learn.microsoft.com/en-us/sql/connect/odbc/linux-mac/installing-the-microsoft-odbc-driver-for-sql-server?view=sql-server-ver15

驱动程序库文件为/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.5.so.21

这样，以下脚本就成功地连接到数据库并返回表的内容：

 #!/usr/bin/perl
use strict;
use warnings;

use DBI;
my $user =  SA ;
my $password =  <YourNewStrong@Passw0rd> ;

my $dbh = DBI->connect("dbi:ODBC:Driver={/opt/microsoft/msodbcsql17/lib64/libmsodbcsql-17.5.so.2.1};Server=localhost;Database=TestDB;UID=$user;PWD=$password");

my $sth = $dbh->prepare("SELECT * FROM Inventory");
$sth->execute();

while ( my @row = $sth->fetchrow_array ) {
      print "@row
";
}

友情链接