我正在尝试在我的服务器上建立需要ssl的ODBC连接。这是我的odbc.ini
RemoteConn= MySQL Unicode
[RemoteConn]
Driver = /usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so
Description = RemoteConn Connection
SERVER = the remote IP Address
Database = Remote DB Name
USER = Remote DB USer
Password = Remote DB Pass
s
我正在尝试设置FreeTDS以连接到Ubuntu14.04和FreeTDS 4.2中的mssql服务器
但是,由于未知的原因,osql无法读取Servername设置。如果我使用isql,它就能工作。但是,我的程序使用odbc.ini设置。
我做错什么了?
我的odbc.ini;
[ODBC Data Sources]
Test = My Test Server
[mssql]
Description = My Test Server
Driver = FreeTDS
Trace = No
TDS_Version = 4.2
Servername = mssql
命令
我安装了unixODBC和MySql ODBC驱动程序,但是无法连接ODBC DNS。
isql -v myodbc_mysql_dsn
我得到了这个错误:
Cannot connect to ODBC DSN:
[SQL ERROR]:[IM002][0][[unixODBC][Driver Manager]Data source name not found, and no default driver specified]|
我的配置如下所示:
cat /etc/odbc.ini
[myodbc_mysql_dsn]
Description = test
Driver = My
我正在尝试使用perl脚本连接到mssql数据库。
我的代码如下:
#!/home/fds/freeware/perl/bin/perl
use DBI;
my $user = "username";
my $pass = "password";
my $server = "server_name";
my $database_name = "db";
my $DSN = "driver={SQL Server};server=$server;database=$database_name;uid=$user;pwd
我正在使用perl 5.10.1,我当前的服务器(centos 6.3)。每当我执行Perl程序时,我都会得到以下错误:
install_driver(ODBC) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/ODBC/ODBC.so'
for module DBD::ODBC: libodbc.so.1: cannot open shared object file: No such file or
directory at /usr/lib64/perl5/DynaLoader.pm line 200.
当
每当我试图运行Perl程序时遇到错误,我就卡住了。
install_driver(ODBC) failed: Can't load '/usr/local/lib64/perl5/auto/DBD/ODBC/ODBC.so' for module DBD::ODBC: libodbc.so.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/DynaLoader.pm line 200.
at (eval 4) line 3
Compilation faile