search
HomeBackend DevelopmentPHP TutorialPHP连接SQLServer2005的实现方法(附ntwdblib.dll下载)_php技巧

php连接sql2005的问题,现在整合,同时把FAQ整合上.

我前面写的教程:

连接前配置系统:

1.检查文件 php5.2.5/ntwdblib.dll 默认下面有一个,不能连接再替换.

下载正确版本的 ntwdblib.dll (2000.80.194.0),地址: http://www.jb51.net/dll/ntwdblib.dll.htmlimage

2.配置php

a、打开php.in将extension=php_mssql.dll的注释符号去掉。

image

b、打开php.in将mssql.secure_connection = Off改为on。

image

c、将php_mssql.dll拷贝到php.in中extension_dir 指定的目录或者系统system32目录下。(php_mssql.dll在php的压缩安装包中有)。

image

以上步骤完成后需要重启apache。

注意:实际使用中发现 如果通过php压缩文件手工安装php到iis下,必须重启机器而不仅仅是iis。

3.配置sqlserver 
a. 运行 SQL Server 配置管理器:SQL Server Configuration Manager,打开协议 Protocols 
b. 允许命名管道 "named pipes" 和 "tcp/ip" 
c. 右键点击 "tcp/ip",打开属性 Properties 标签 "IP addresses" 
d. 在 TCP 动态端口 "TCP Dynamic Ports" 填入 1433 
e. 重启 SQL Server

-----------------------------------------------------------------------------------------------  
4.使用以下方式连接MS SQL Server 2005: 
代码如下:

//链接数据库 
 $conn=mssql_connect('localhost','sa','123456'); 
   mssql_select_db('gu_dde',$conn); 
//query语句   
 $Query="select * from dde_top"; 
 $AdminResult=mssql_query($Query); 
//输出结果 
 $Num=mssql_num_rows($AdminResult); 
 for($i=0;$i 
   { 
 $Row=mssql_fetch_array($AdminResult); 
 echo($Row[1]); 
 echo("
"); 
   }   
?>

输入http://127.0.0.1

image

-----------------------------------------------------------------------

5.FAQ常见问题:

1报错:

Fatal error: Call to undefined function mssql_connect()

解决:

使用MSSQL_系列函数 
    要使用这两种都需要在php.ini进行设定:  
   (1)允许 DCOM,需要将php.ini中的 ;com.allow_dcom=TRUE前的分号";"去掉。 
   (2)使用MSSQL扩展,需要php.ini中的 ;extension=php_mssql.dll前的分号";"去掉。(关键)  
   (3)确认extension_dir为正确路径,以本机为例:extension_dir = "c:/AppServ5.2.6/php/ext"。  
   (4)如果仍然机器报错说找不到c:/AppServ5.2.6/php/ext/php_mssql.dll但明明存在这个文件。 
   解决方法:将php_mssql.dll,ntwdblib.dll拷贝到系统目录/system32下重启测试。。 
    (注:上面两个dll文件不在相同目录下,我的为c:/AppServ5.2.6/php/ext/php_mssql.dll;c:/AppServ5.2.6/php/ntwdblib.dll) 
    另外设置好了后记得重启服务器哦。

2.mssql_connect() Unable to connect to server

确认SQLServer2005服务器正常.检查 TCP/IP已经启用

image

同时右键查看属性:

image

已经启用是否选择是

确认服务器正确之后,再确认ntwdblib.dll 文件位置是否放到了 c:/windows/system32下

同时要保证ntwdblib.dll 这个文件的版本和sqlserver的版本对应:

下面是对应关系:

2.ntwdblib.dll 版本为 2000.2.8.0 是 对应 SqlServer2000(这个是网络查资料和猜测,没装2000)

2.ntwdblib.dll 版本为 2000.80.194.0 是 对应 SqlServer2005(这个是用实验证明可以用,本人就是用笔记本装了2005)

3.ntwdblib.dll 版本为 2000.80.2039 是 对应 SqlServer2008(这个是猜测没有装2008)

 

6.其他问题:

如果php apache Sql Server2000都在同一台机器上,访问基本没有问题了。

如果Sql Server2000和php机器是分离的,需要确认ping sqlserver所在机器的机器名能通,如过不通,修改php所在机器的/system32/drivers/etc下的hosts文件,增加一行 sqlserver所在机器的机器ip   sqlserver所在机器的机器名字。

如果还是无法访问,需要确认php所在的机器有无暗转mdac。要不索性安装一下sqlserver的客户端好了。

解决问题如下:

1.下载两个文件 php_mssql.dll 和 ntwdblib.dll

php_mssql.dll 如果这个没有复制到c:/windows/system32下,就很容易出现

 

ntwdblib2093.dll 这个文件要注意版本,不然后面搞得很郁闷.

Statement
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
PHP's Purpose: Building Dynamic WebsitesPHP's Purpose: Building Dynamic WebsitesApr 15, 2025 am 12:18 AM

PHP is used to build dynamic websites, and its core functions include: 1. Generate dynamic content and generate web pages in real time by connecting with the database; 2. Process user interaction and form submissions, verify inputs and respond to operations; 3. Manage sessions and user authentication to provide a personalized experience; 4. Optimize performance and follow best practices to improve website efficiency and security.

PHP: Handling Databases and Server-Side LogicPHP: Handling Databases and Server-Side LogicApr 15, 2025 am 12:15 AM

PHP uses MySQLi and PDO extensions to interact in database operations and server-side logic processing, and processes server-side logic through functions such as session management. 1) Use MySQLi or PDO to connect to the database and execute SQL queries. 2) Handle HTTP requests and user status through session management and other functions. 3) Use transactions to ensure the atomicity of database operations. 4) Prevent SQL injection, use exception handling and closing connections for debugging. 5) Optimize performance through indexing and cache, write highly readable code and perform error handling.

How do you prevent SQL Injection in PHP? (Prepared statements, PDO)How do you prevent SQL Injection in PHP? (Prepared statements, PDO)Apr 15, 2025 am 12:15 AM

Using preprocessing statements and PDO in PHP can effectively prevent SQL injection attacks. 1) Use PDO to connect to the database and set the error mode. 2) Create preprocessing statements through the prepare method and pass data using placeholders and execute methods. 3) Process query results and ensure the security and performance of the code.

PHP and Python: Code Examples and ComparisonPHP and Python: Code Examples and ComparisonApr 15, 2025 am 12:07 AM

PHP and Python have their own advantages and disadvantages, and the choice depends on project needs and personal preferences. 1.PHP is suitable for rapid development and maintenance of large-scale web applications. 2. Python dominates the field of data science and machine learning.

PHP in Action: Real-World Examples and ApplicationsPHP in Action: Real-World Examples and ApplicationsApr 14, 2025 am 12:19 AM

PHP is widely used in e-commerce, content management systems and API development. 1) E-commerce: used for shopping cart function and payment processing. 2) Content management system: used for dynamic content generation and user management. 3) API development: used for RESTful API development and API security. Through performance optimization and best practices, the efficiency and maintainability of PHP applications are improved.

PHP: Creating Interactive Web Content with EasePHP: Creating Interactive Web Content with EaseApr 14, 2025 am 12:15 AM

PHP makes it easy to create interactive web content. 1) Dynamically generate content by embedding HTML and display it in real time based on user input or database data. 2) Process form submission and generate dynamic output to ensure that htmlspecialchars is used to prevent XSS. 3) Use MySQL to create a user registration system, and use password_hash and preprocessing statements to enhance security. Mastering these techniques will improve the efficiency of web development.

PHP and Python: Comparing Two Popular Programming LanguagesPHP and Python: Comparing Two Popular Programming LanguagesApr 14, 2025 am 12:13 AM

PHP and Python each have their own advantages, and choose according to project requirements. 1.PHP is suitable for web development, especially for rapid development and maintenance of websites. 2. Python is suitable for data science, machine learning and artificial intelligence, with concise syntax and suitable for beginners.

The Enduring Relevance of PHP: Is It Still Alive?The Enduring Relevance of PHP: Is It Still Alive?Apr 14, 2025 am 12:12 AM

PHP is still dynamic and still occupies an important position in the field of modern programming. 1) PHP's simplicity and powerful community support make it widely used in web development; 2) Its flexibility and stability make it outstanding in handling web forms, database operations and file processing; 3) PHP is constantly evolving and optimizing, suitable for beginners and experienced developers.

See all articles

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. Best Graphic Settings
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
R.E.P.O. How to Fix Audio if You Can't Hear Anyone
4 weeks agoBy尊渡假赌尊渡假赌尊渡假赌
WWE 2K25: How To Unlock Everything In MyRise
1 months agoBy尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

Safe Exam Browser

Safe Exam Browser

Safe Exam Browser is a secure browser environment for taking online exams securely. This software turns any computer into a secure workstation. It controls access to any utility and prevents students from using unauthorized resources.

SublimeText3 Linux new version

SublimeText3 Linux new version

SublimeText3 Linux latest version

MantisBT

MantisBT

Mantis is an easy-to-deploy web-based defect tracking tool designed to aid in product defect tracking. It requires PHP, MySQL and a web server. Check out our demo and hosting services.

WebStorm Mac version

WebStorm Mac version

Useful JavaScript development tools