Home > Article > Backend Development > php Call to undefined function mssql_connect()_PHP教程
php tutorial mssql connection Call to undefined function mssql_connect()
Now I want to connect to MSSQL2000 and import MSSQL data into MYSQL, but I found that the link to MSSQL is not available,
Tip Call to undefined function mssql_connect()
Steps done:
1:php.ini
The semicolon in front of extension = php_mssql.dll has been removed
2:
Copied php_mssql.dll to the ext directory. The ext directory is the extension_dir directory. php_mssql.dll was not found in PHP5. It was copied from the previous PHP4. I don’t know if there is a version problem.
3: Modified it and copied php_mssql.dll to the system32 directory and also copied it to the windows directory
Analysis method
1:php.ini
The semicolon in front of extension = php_mssql.dll has been removed
Correct, must be done
2:
Copied php_mssql.dll to the ext directory. The ext directory is the extension_dir directory. php_mssql.dll was not found in PHP5. It was copied from the previous PHP4. I don’t know if there is a version problem.
It should be possible
3: Modified it. Copied php_mssql.dll to the system32 directory and also copied it to the windows directory
There’s no need to do this, it’s okay to do it
The crucial step was not done!
Place ntwdblib.dll in your system’s search path
Upgrade Sql Server 2000 to SP4, otherwise php can pass mssql_connect but cannot connect to port 1433 of sql server