Unable to load dynamic library mssql.dll

[noister]

hi,

i got this error when i uncomment the php_mssql in php.ini file. coz ill be connecting to mssql database express in my project.

based on research, ntwdblib.dll is required... so i downloaded the said file and put both under /sys32 and under /xampp... but still xampp didnt work properly.

hope someone can share and bring solution to this.

thanks,

noister

[JonB]

Read this topic - look down to post #6

viewtopic.php?f=16&t=49670

Good Luck

[noister]

please help, im stuck here. almost a week problem haven't found a solution yet.

i have xampp 1.7.4 and connect mssql 2005 express.

here's the common things i did.

1. php_mssql.dll in php.ini already uncomment and placed the file in xampp/php/ext, restart apache is done.
2. ntwdblib.dll (latest) already placed in system32 also in xampp/php, server has already reset.
3. also in mssql, enabled tcp/ip connections and already granted user.

when i try to load my php code it says "Fatal error: Call to undefined function mssql_connect() in C:\xampp\htdocs\mobiletrack\system\loaddata.php on line 5"

Please help what to do next, other than what i did above.

noister

[EDIT by Altrea: related Topics merged]

[hackattack142]

Does it show up on your phpinfo() page?

[noister]

it appears in Configure Command =

Code: Select all

cscript /nologo configure.js "--enable-snapshot-build" "--disable-isapi" "--enable-debug-pack" "--disable-isapi" "--without-mssql" "--without-pdo-mssql" "--without-pi3web" "--

[noister]

any help here?

Noister

[hackattack142]

If you notice, that configure statement says "without" mssql. The mssql driver was discontinued some time ago and is no longer maintained as far as I am aware. It might be better to go with sqlsrv which is maintained by Microsoft. It should provide similar functionality. You will need to get the SQLSRV20.exe from http://www.microsoft.com/en-us/download ... x?id=20098 (Not the SQLSRV30.exe available on the same page as it is no longer compatible with your OS) and the Microsoft SQL Server 2008 Native Client from http://www.microsoft.com/en-us/download ... x?id=16177 (Not the SQL Server 2012 Native Client as it is no longer compatible with your OS). From the SQLSRV20.exe, you would put php_sqlsrv_53_ts_vc6.dll and php_pdo_sqlsrv_53_ts_vc6.dll in your PHP ext folder, add them to your PHP.ini file, and check that they appear in your phpinfo() when you start Apache.