Hi friends...
I am using Wamp with PHP 5.3 and want to connect with SQL Server 2005 but not successful. I also tried it with PHP 5.2.8 but it still not working.
I google it and found some solutions but not successsful yet.
Can anyone give me detailed guide (step by step) that how i can connect PHP with Sql Server 2005???
Thanks in advance...
ankit.pandey3 -8 Junior Poster in Training
pritaeas 2,194 ¯\_(ツ)_/¯ Moderator Featured Poster
Have you enabled the mssql extension in the php.ini ? In wamp it is disabled by default.
ankit.pandey3 -8 Junior Poster in Training
Have you enabled the mssql extension in the php.ini ? In wamp it is disabled by default.
I already did following things:0
. Settings related to your php.ini file:
a) search the variable mssql.secure_connection in your php.ini file and put it to on mode if its off
b) remove comment from the dll extention php_mssql.dll (i.e. remove the ; from the front of the extention )
2. Settings related to the dll files.
download a file name ntwdblib.dll from the internet. you can download it from here or can search on internet for that. copy the downloaded dll to the apache/bin directory and for IIS copy it to the php extention directory (if path not known can be found in php.ini for variable extension_dir)
also you need to have your php_mssql.dll in your php extension directory. if its not present please download it and copy it to the default php extension directory.
3. restart all your services (i.e. php and apache or iis) and you can use the script given below to connect to your SQL Server.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.