"Adaptive Server不可用或不存在".从PHP连接到SQL Server时出错

本文介绍了"Adaptive Server不可用或不存在".从PHP连接到SQL Server时出错的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我正在尝试使用unixODBC和FreeTDS从Mac连接到我的Mac上的SQL Server 2005数据库，正如我概述的.但是，当我尝试使用相同的设置连接到另一个DB时，会得到:

I'm attempting to connect to a SQL Server 2005 DB from my Mac using unixODBC and FreeTDS as I have outlined here. However, when I try to connect in to a different DB using the same setup, I get:

Connection Failed:[FreeTDS][SQL Server]Unable to connect: Adaptive Server is unavailable or does not exist.

这是我的freetds.conf设置:

Here is my freetds.conf setup:

[my_db]
host = 12.34.56.789
port = 1433
tds version = 8.0

这是我的odbc.ini:

And here is my odbc.ini:

[my_dsn]
Driver = /opt/local/lib/libtdsodbc.so
Description = My Database
Trace = no
Servername = my_db
Database = MyDB

[ODBC Data Sources]
my_dsn = FreeTDS

我仍然可以连接到我在这台计算机上设置的另一个数据库(在上面链接的博客文章中进行了介绍)，因此，我很确定该错误不在Mac端.我已在服务器上验证我使用的IP地址和端口正确.对可能是什么问题以及是否在服务器端有任何想法?

I am still able to connect to the other DB I set up on this computer (described in my blog post linked above), so I'm pretty sure that the error isn't on the Mac end. I've verified on the server that I'm using the correct IP address and port. Any thoughts on what could be the problem, and if it's on the server end?

推荐答案

1.查看有关SQL Server的信息

tsql -LH SERVER_IP_ADDRESS

locale is "C"
locale charset is "646"
ServerName TITAN
InstanceName MSSQLSERVER
IsClustered No
Version 8.00.194
tcp 1433
np \\TITAN\pipe\sql\query

2.设置您的freetds.conf

tsql -C
freetds.conf directory: /usr/local/etc

[TITAN]
host = SERVER_IP_ADDRESS
port = 1433
tds version = 7.2

3试试

tsql -S TITAN -U user -P password

或

 'dsn' => 'dblib:host=TITAN:1433;dbname=YOURDBNAME',

另请参见 http://www.freetds.org/userguide/confirminstall.htm (示例3-5.)

这篇关于"Adaptive Server不可用或不存在".从PHP连接到SQL Server时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

adaptive