ubuntu odbc mysql,尝试在ubuntu中使用RODBC连接到ODBC服务器

最新推荐文章于 2021-05-23 16:51:39 发布

转载最新推荐文章于 2021-05-23 16:51:39 发布 · 208 阅读

文章标签：

在Centos 5.8上遇到[RODBC]ERROR: state01000, code0的问题？博主分享了通过FreeTDS驱动成功连接到MSSQL Server的经验。安装步骤包括配置FreeTDS驱动、编辑odbcinst.ini文件，并提供了连接字符串示例。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

I am getting the error:

[RODBC] ERROR: state 01000, code 0, message [unixODBC][Driver Manager]Can't open lib 'SQL Server' : file not found

2: In odbcDriverConnect("driver={SQL Server};server=*******;database=****;trusted_connection=true") :

ODBC connection failed

Can anyone provide detailed instructions on installing the driver for ODBC in order for it to work with RODBC?

Note: I am trying to connect to an MSSQL Server

解决方案

Here at my job, we use Centos 5.8. When I need to connect to our MS-SQL servers, I use FreeTDS drivers. I talk a bit more about it here: https://stackoverflow.com/a/10196098/1332389, including the packages and dependencies that I installed.

A sample connection string might look like this:

data_odbc

Server=dataserver1\\instancename(default: master);

Port=1433;

Database=database_01;

Uid=data_mgmt;

Pwd=placeholder")

We configured our odbcinst.ini file (in /etc/) to say:

# FreeTDS Drivers

# Manual setup, used for MS SQL

[FreeTDS]

Description = FreeTDS for MSSQL

# 32 bit

Driver = /usr/lib/libtdsodbc.so

Setup = /usr/lib/libtdsS.so

# 64 bit

Driver64 = /usr/lib64/libtdsodbc.so

Setup64 = /usr/lib64/libtdsS.so

FileUsage = 1

I've had no issues since getting it set up. Hope this helps - I can try and answer if you have more questions.