![]() |
|
首页 │ Apache │ Linux│ Java│ MySQL│ 注册│帮助 | |||
实习单位上有个比较老版本的MSSQL(应该是MSSQL 7以前的吧)
想连上去试试
[php]
<?php
$server = new PDO("odbc
river={SQL Server};Server=100.100.100.13:1433;Database=master;Uid=sa
wd=123;");
?>
[/php]
连接的结果是:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[08001] SQ
DriverConnect: 1231 [Microsoft][ODBC SQL Server Driver]客户无法建立连接' in D:\
.php:2
Stack trace:
#0 D:\1.php(2): PDO->__construct('odbc
river={SQ...')
#1 {main}
thrown in D:\1.php on line 2
而使用
[php]<?php
$server = new PDO("MSSQL: host=100.100.100.13;dbname=master;",'sa','123');
?>[/php]
的话更差,返回说SQL服务器不存在(手册上也 说WINDOWS拥护不能用这种方式)
ADO的结果是:
[php]
<?php
$conn = new COM("ADODB.Connection") or die("Cannot start ADO");
$conn->Open("Provider=SQLOLEDB; Data Source=100.100.100.13;
Initial Catalog=masters; User ID=sa; Password=123");
?>[/php]
结果是:
Fatal error: Uncaught exception 'com_exception' with message 'Source: Microsoft
OLE DB Provider for SQL Server
Description: [DBNMPNTW]ConnectionOpen (CreateFile()).' in D:\D.php:5
Stack trace:
#0 D:\D.php(5): com->Open('Provider=SQLOLE...')
#1 {main}
thrown in D:\D.php on line 5
同时Borland BDE总是能正确的连上服务器?
PHP该怎么办?ADO?

