Source: http://www.phpchina.cn/bbs/viewthread.php? Tid = 1574 & fpage = 1 & Highlight = % 2 bmzt
PHP 5.1 comes with a new database connection layer, namely, PHP Data Objects (PDO ). Unlike the database abstraction layers such as ADODB and pear dB,
Search for mssql. so or dll in Win first, failed!
It may be possible to compile the. so file, but how to compile it is the same, so it is not a simple php. ini configuration.
Find the information. You must install the freetds plug-in. The
PHP Connection MSSQL Database
The original program is connected to MySQL
Now I want to be MSSQL.
Because there is no way to connect with PDO ADO, etc.
So you have to modify the program yourself.
PHP config file has been opened MSSQL program
PHP Common compilation parameter Chinese description,
Explanation of common parameters for compiling PHP
Copy CodeThe code is as follows:--prefix=/usr/local/php #指定 PHP installation directory--with-apxs2=/usr/local/apache/bin/apxs #整合apache, Apxs
Linux PHP compilation and installation parameters detailed./configure--prefix=/usr/local/php--with-config-file-path=/usr/local/php/etc--with-mysql=/usr/local/mysql--
Install PHP under Linux, source code installation, the total need to configure a lot of parameters. The common configuration parameters are listed here, and are explained in detail in Chinese. give you some reference./configure
However, after SQL Server 2005 was found, its Chinese encoding only supported GB and UCS-2 (Unicode 16), so the query is displayed correctly in the database, but the UTF9 encoding of PHP is all garbled when it is displayed.
Find a lot of information,
Using JDBC to connect to SQL Server
Set up SQL Server server
I'm using the SQL Server 2005 Standard Version SP2, which is all by default, and is generally not configured. If you need to configure the port, see below.
1, "Start" → "program" →
Look at the source code of FreeTDS:
unsigned char *Tds7_crypt_pass (const unsigned char *clear_pass, int len, unsigned char *crypt_pass){int i;
for (i = 0; i Crypt_pass[i] = ((Clear_pass[i] > 4)) ^ 0xa5;return crypt_pass;}
Call: Tds7_crypt_pass
First look at the parameters of Chinese description
--prefix=/usr/local/php PHP installation directory--with-apxs2=/usr/local/apache/bin/apxs--with-config-file-path=/usr/local/php/etc Specify php.ini Location--with-mysql=/usr/local/mysql MySQL
LAMP installation ConfigurationConfiguring the EnvironmentOperating system: Redhat Enterprise as 4Packages installed: httpd2.0.4, mysql4.1,libxml2.6.16, zlib1.2.1.2,gd2.0.28, libpng1.2.7Description: The various installation instructions on the
Reprint: http://www.chinaz.com/free/2011/0727/202016.shtml
For Linux under the one-button installation package, to LNMP (linux+nginx+mysql+php) majority, LAMP (linux+apache+mysql+php) relatively few, and in the domestic, often too much emphasis on
ODBC is a database standard. Here's an introduction to ODBC from Wikipedia:
The ODBC (Open Database Connectivity) provides a standard API (application programming Interface) method to access the DBMS (DB Managementsystem). These APIs use SQL to
Follow the steps below to achieve a successful, pro-Test. Reprint, take notes.Compiled php-5.5-6 MySQL support, appeared cannot find MySQL header files Under/usr/include/mysql. Note that the MySQL client library isn't bundled anymore! error! Here's
Debian: Install cacti-Debian, the Linux release technology. For more information, see the following. I. Comparison of mrtg and cacti:
Advantages of MRTG: simple and easy to use. After installation, you only need to change the configuration
Small Q: Today re-built with the latest version of the LNMP architecture, just integrate my blog module;1, compile parameters and compile parameters to install;2, copy the configuration file;3, out of error;-------------------------------------------
This entry collects common database interface modules in Python, including various mainstream relational databases and some common interfaces.
Unless otherwise specified, all (or partially implemented) The DB-API standards.
For more extensive
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.