PHP Remote Connection MSSQL problem

Source: Internet
Author: User
Tags mssql php tutorial

Use Joomla to connect to another server's MSSQL. PHP Environment for Windows Apps Tutorial Erv (apache2.2.4,php tutorial 5.2.3)

The ";" before the following line in the php.ini Number removed.

; Extension=php_mssql.dll

Search NTWDBLIB.DLL files, typically under the C:windowssystem32 and PHP installation folder. Right-click Properties, view version, if it is 2000.80.194.0 before, need to update.

After restarting the service, we found that local MSSQL is fine and remote cannot connect. Find more than n site, the answer is basically NTWDBLIB.DLL problem. However, the connection cannot be successful at all times.

Today simply in the local test, the environment for Windows under the XAMPP1.7.0, found Apachebin also exist NTWDBLIB.DLL files, and the server Appserv in the Apache did not. Replace it with a successful connection.

Conclusion: Appserv does not support MSSQL remote connection, its Apache is simpler than xampp, and can be seen from the number of files.

PHP functions on MSSQL:

Mssql_affected_rows:??? Gets the number of columns affected by the last query.

Mssql_close:??? Closes the connection to the database tutorial.

Mssql_connect:??? Connect to the database.

Mssql_data_seek:??? Move the column pointer.

Mssql_fetch_array:??? Returns the array data.

Mssql_fetch_field:??? Gets the field information.

Mssql_fetch_object:??? Returns the class data.

Mssql_fetch_row:??? Returns the individual fields of a single column.

Mssql_field_seek:??? Configure the pointer to a field that returns a value.

Mssql_free_result:??? Release returns memory consumption.

Mssql_num_fields:??? Gets the number of returned fields.

Mssql_num_rows:??? Gets the number of returned columns.

Mssql_pconnect:??? Open the MS SQL server continuous connection.

Mssql_query:??? Send out a query string.

Mssql_result:??? Gets the results of the query.

mssql_select_db:??? Select a database.

GB2312 UTF-8 function (vice versa):

Iconv ("gb2312", "Utf-8", $text)

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.