blocks|key|201527|text|PDO无法工作，或者至少没有PDO+Sybase对php的支持。在Windows上，您可以使用ODBC、PDO_SQLSRV或PDO_ODBC，这听起来可能有些奇怪，但它应该可以工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|201528|第二种选择是直接连接到Sybase+(SqlAnywhere)，但您需要安装SQL+Anywhere+PHP+Module|201529|entityMap|0|LINK|mutability|MUTABLE|url|http://php.net/manual/en/ref.pdo-sqlsrv.php|1|http://php.net/manual/en/ref.pdo-odbc.php|2|http://www.sybase.co.uk/detail?id=1019698^0|1G|A|0|1R|8|1|0|12|N|2|0^^$0|@$1|2|3|4|5|6|7|R|8|@]|9|@$A|S|B|T|1|U]|$A|V|B|W|1|X]]|C|$]]|$1|D|3|E|5|6|7|Y|8|@]|9|@$A|Z|B|10|1|11]]|C|$]]|$1|F|3|-4|5|6|7|12|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]|P|$5|I|J|K|C|$L|Q]]]]

PDO wouldn't work, or at least there is no PDO Sybase support for php. On Windows, you can use ODBC, and <a href="http://php.net/manual/en/ref.pdo-sqlsrv.php" rel="nofollow">PDO_SQLSRV</a> or <a href="http://php.net/manual/en/ref.pdo-odbc.php" rel="nofollow">PDO_ODBC</a>, it might sound weird, but it should work.

Second option and I would recommend it, is to connect directly to Sybase (SqlAnywhere), but you need to install <a href="http://www.sybase.co.uk/detail?id=1019698" rel="nofollow">SQL Anywhere PHP Module</a>

blocks|key|2832103|text|如果你使用的是Ubuntu，你可以把LD_LIBRARY_PATH放在envvars里面，它看起来像是……仍然在试图找到一种方法让它在基于RHEL的系统上运行...我不太确定我希望你能在下面设置一个系统变量|type|unstyled|depth|inlineStyleRanges|offset|length|style|BOLD|entityRanges|data|2832104|2832105|+my+computer+->+properties+->高级选项|blockquote|2832106|2832107|2832108|如果您使用的是基于apache的系统，最好在重新启动脚本中包含:apache导出LD_LIBRARY_PATH=/path/to/library/+(检查它是否加载了/etc/sysconfig/httpd，如果加载了，则在其中添加行-现在重新启动，您应该会看到一些活动)。|2832109|entityMap^0|I|F|1X|4|0|0|0|0|0|M|1F|2B|K|3G|D|0^^$0|@$1|2|3|4|5|6|7|P|8|@$9|Q|A|R|B|C]|$9|S|A|T|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|U|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|V|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|W|8|@]|D|@]|E|$]]|$1|K|3|-4|5|6|7|X|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|Y|8|@$9|Z|A|10|B|C]|$9|11|A|12|B|C]|$9|13|A|14|B|C]]|D|@]|E|$]]|$1|N|3|-4|5|6|7|15|8|@]|D|@]|E|$]]]|O|$]]

If you are using Ubuntu you can put the LD_LIBRARY_PATH inside envvars and it seems to read... still trying to find a way to get it to stick on RHEL based systems... Windows I am not too sure about I would hope you could set a system wide variable under 

<blockquote>
 my computer -> properties -> advanced options
</blockquote>

If are using RHEL based systems it might be better to include the: 
export LD_LIBRARY_PATH=/path/to/library/ in the httpd restart script (check to see if it loads /etc/sysconfig/httpd and if so add the line in there - now restart apache and you should see some activity.

blocks|key|2832196|text|您应该使用dblib而不是sybase，如下所示：|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|2832197|$dbh+=+new+PDO("dblib:host=192.168.1.xxx;dbname=[database-name]",+'[user]',+'[pass]');|code-block|syntax|javascript|2832198|entityMap^0|5|5|D|6|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@$9|N|A|O|B|C]|$9|P|A|Q|B|C]]|D|@]|E|$]]|$1|F|3|G|5|H|7|R|8|@]|D|@]|E|$I|J]]|$1|K|3|-4|5|6|7|S|8|@]|D|@]|E|$]]]|L|$]]

You should use <code>dblib</code> instead of <code>sybase</code>, like this:

<pre><code>$dbh = new PDO("dblib:host=192.168.1.xxx;dbname=[database-name]", '[user]', '[pass]');
</code></pre>

I'm trying to connect to a Sybase database with PHP5. I believe I've successfully compiled PHP with <code>PDO_DBLIB</code>, as <code>phpinfo()</code> lists <code>dblib</code> under PDO drivers, and <code>freetds</code> as the <code>pdo_dblib</code> flavour.

However, when I try to test a connection, I get an error reading: 

<blockquote>
 'PDOException' with message 'could not find driver'
</blockquote>

I'm trying to connect to a server on my LAN with this code:

<pre><code>$dbh = new PDO("sybase:host=192.168.1.xxx;dbname=[database-name]", '[user]', '[pass]');
</code></pre>

Any suggestions would be greatly appreciated!

How to connect to Sybase via PHP

数据库

服务器

Windows

Ubuntu

我正在尝试使用PHP5连接到Sybase数据库。我相信我已经成功地用PDO_DBLIB编译了PHP，因为phpinfo()在PDO驱动程序下列出了dblib，并将freetds作为pdo_dblib风格。然而，当我尝试测试一个连接时，我得到了一个错误读数：驱动程序'PDOException‘，消息为’找不到驱动程序‘我...

问如何通过PHP连接到Sybase
EN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何通过PHP连接到SybaseEN

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何通过PHP连接到Sybase
EN