Media Temple DV 4.0 上的 MS-SQL 连接
我真的很难过这一点。尝试在我的 mediatemple DV 4.0 服务器上使用 php 连接到 MS-SQL 数据库。
我能够使用这些说明在 DV 3.5 上运行它
http://kb.mediatemple.net/questions/233/Using+%28remote%29+MS-SQL+databases+with+PHP+on+a+%28dv%29
但同样步骤在 4.0 上不起作用。
我什至尝试安装 FreeTDS 并重新安装 64 位版本： freetds-devel-0.64-1.el5.rf.x86_64.rpm
然后我
[FreeTDS]
Description = v0.63 with protocol v8.0
Driver = /usr/lib/libtdsodbc.so.0 - changed to /usr/lib64/libtdsodbc.so.0
在这样做后进行了更改，它消除了我看到的所有错误，但我仍然看到
Warning: odbc_connect(): SQL error: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source, SQL state S1000 in SQLConnect in /var/www/vhosts/housingworks.org/httpdocs/p/dbtest.php on line 9
这是我运行测试的地方： http://www.housingworks.org/p/dbtest.php
帮助！
I'm really stumped on this on. Trying to connect to a MS-SQL database with php on my mediatemple DV 4.0 server.
I was able to get it working on our DV 3.5 using these instructions
http://kb.mediatemple.net/questions/233/Using+%28remote%29+MS-SQL+databases+with+PHP+on+a+%28dv%29
But the same steps dont work on the 4.0.
I even tried installing FreeTDS and reinstalling the 64 bit version:
freetds-devel-0.64-1.el5.rf.x86_64.rpm
and then i changed
[FreeTDS]
Description = v0.63 with protocol v8.0
Driver = /usr/lib/libtdsodbc.so.0 - changed to /usr/lib64/libtdsodbc.so.0
after i did that it go rid of all the errors I was seeing but I am still seeing
Warning: odbc_connect(): SQL error: [unixODBC][FreeTDS][SQL Server]Unable to connect to data source, SQL state S1000 in SQLConnect in /var/www/vhosts/housingworks.org/httpdocs/p/dbtest.php on line 9
this is where i am running the test: http://www.housingworks.org/p/dbtest.php
HELP!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我不能 100% 确定您为什么会收到这些错误，因为您应该能够使用该 (mt) Wiki 在我们的所有服务中连接到 MySQL。请尝试就此连接错误给我们打电话，我们的一位高级技术人员可能会为您解决问题。 (877)578-4000。
I'm not 100% sure on why you are getting these errors, as you should be able to use that (mt) Wiki to connect to MySQL throughout all of our services. Try giving us a call regarding this connection error, and one of our higher level techs may be able to get things sorted out for you. (877) 578-4000.