连接到MSSQL数据库的问题


Trouble With Connecting to MSSQL DB

我有一个Ubuntu 12.04服务器,我试图建立一个连接到MSSQL数据库。

我已经设法使用tsqlisql连接,但osql不起作用,使用PDO与PHP连接也不起作用。我将尽力提供尽可能多的信息,如果你需要更多的信息,请告诉我,我会编辑。

freetds.conf :

[MSSQL]
  host = TPSACC
  port = 54488
  tds version = 8.0

odbc.ini :

[MSSQL]
Description     = MS SQL connection to PRODUCTION database
Driver          = FreeTDS
Database        = PRODUCTION
Server          = TPSACC
UserName        = sa
Password        = pass
Trace           = No
TDS_Version     = 8.0
Port            = 54488
将odbcinst . ini >:
[FreeTDS]
Description = ODBC for Microsoft SQL
Driver      = /usr/local/lib/libtdsodbc.so
UsageCount  = 1
Threading   = 2

~> isql MSSQL sa pass

+---------------------------------------+
| Connected!                            |
|                                       |
| sql-statement                         |
| help [tablename]                      |
| quit                                  |
|                                       |
+---------------------------------------+
SQL> 

~> tsql - s该软件- u ' sa ' p '通过

locale is "en_US.UTF-8"
locale charset is "UTF-8"
using default charset "UTF-8"
1> 

~> osql - s该sa - u - p将

checking shared odbc libraries linked to isql for default directories...
strings: '': No such file
    trying /tmp/sql ... no
    trying /tmp/sql ... no
    trying /etc ... OK
checking odbc.ini files
    reading /home/toolplas/.odbc.ini
[MSSQL] not found in /home/toolplas/.odbc.ini
    reading /etc/odbc.ini
[MSSQL] found in /etc/odbc.ini
found this section:
    [MSSQL]
    Description     = MS SQL connection to PRODUCTION database
    Driver          = FreeTDS
    Database        = PRODUCTION
    Server          = TPSACC
    UserName        = sa
    Password        = pass
    Trace           = No
    TDS_Version     = 8.0
    Port            = 54488
looking for driver for DSN [MSSQL] in /etc/odbc.ini
  found driver line: "  Driver          = FreeTDS"
  driver "FreeTDS" found for [MSSQL] in odbc.ini
found driver named "FreeTDS"
"FreeTDS" is not an executable file
looking for entry named [FreeTDS] in /etc/odbcinst.ini
  found driver line: "  Driver      = /usr/local/lib/libtdsodbc.so"
  found driver /usr/local/lib/libtdsodbc.so for [FreeTDS] in odbcinst.ini
/usr/local/lib/libtdsodbc.so is an executable file
"Server" found, not using freetds.conf
Server is "TPSACC"
osql: no IP address found for "TPSACC"

在PHP中我有:

$conn = new PDO ("dblib:host=TPSACC;dbname=PRODUCTION","$username","$pw");

…或…

$conn = new PDO ("dblib:host=TPSACC;port=54488;dbname=PRODUCTION","$username","$pw");

它们都返回这个错误:

SQLSTATE[HY000] Unable to connect: Adaptive Server is unavailable or does not exist (severity 9) 

我已经被困在这里几天了,不能完全弄清楚为什么只有一半的连接实际工作。

任何和所有的帮助是真的很感激,谢谢!

编辑:这与那个问题不同,我在评论中解释过,但我会在这里重新发布:

这个问题是端口从1433更改了。我的也改变了,我修复了这个问题,端口现在是54488,自从这个改变以来,tsql和isql一直在工作。但是,它仍然不能解决osql和PHP的问题。

osql被配置中的某些东西卡住了。osql是一个调试实用程序,它只检查您的配置,然后传递给unixODBC的isql进行连接(http://linux.die.net/man/1/osql)。在odbc.ini中试试:

[MSSQL]
Driver = FreeTDS
Description = MS SQL connection to PRODUCTION database
Server = tpsacc.yourfulldomain.com
Port = 54488
TDS_Version = 7.2
Database = PRODUCTION
UserName = sa
Password = pass
Trace = No

还有,你确定这是libtdsodb .so的正确位置吗?当我用Ubuntu 14 x64(乌托邦)安装freetds-dev时,它安装到/usr/lib/x86_64-linux-gnu/odbc/libtdsodb .so;将odbcinst . ini:示例

[FreeTDS]
Description = v0.91 with protocol v7.2
Driver = /usr/lib/x86_64-linux-gnu/odbc/libtdsodbc.so

为了更好地测量,典型的freetds.conf我使用:

# A typical Microsoft server
[MSSQL]
host = tpsacc.yourfulldomain.com
port = 54488
tds version = 7.2

FreeTDS只支持大多数语言的TDS 7.2版本。虽然使用"8.0"不应该破坏任何东西,但使用7.2更好地保持一致性。如果您需要检查以供参考,我有一个带有完整配置的Vagrant盒子,在这里提供示例:https://github.com/FlipperPA/django-python3-vagrant/祝您好运!