tag:blogger.com,1999:blog-7442072150765022610.post6437657256294068707..comments2023-11-16T23:12:55.172+05:30Comments on Hiren's Technical Blog: Connect with Microsoft Sql server from PHP in xamppHiren Davehttp://www.blogger.com/profile/03332234242233370508noreply@blogger.comBlogger31125tag:blogger.com,1999:blog-7442072150765022610.post-36626030965693821332014-09-25T15:18:17.240+05:302014-09-25T15:18:17.240+05:30PHP Startup:Unable to load dynamic library
'C:...PHP Startup:Unable to load dynamic library<br />'C:\xampp\php\ext\php_sqlsvr_53_nts_vc9.dll' - The specific module could not be found. This message shown. My xampp version xampp 1.8.1. Please give me a solution Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-39385659938086231872014-09-10T12:37:47.534+05:302014-09-10T12:37:47.534+05:30Hi, can i use mssql_connect() with this sqlsrv.Hi, can i use mssql_connect() with this sqlsrv.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-32448244356621594742014-05-23T21:36:22.233+05:302014-05-23T21:36:22.233+05:30coolcoolAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-37330515306442272922014-05-14T14:04:44.485+05:302014-05-14T14:04:44.485+05:30i have been trying for 3 days !!
and you save my l...i have been trying for 3 days !!<br />and you save my life :-)<br />thank you very much.<br /><br />i am not sure about my the problem, but i used WAMP instead of XAMPP. After reading your article, I use XAMPP.... and it works !!andridarmawanhttps://www.blogger.com/profile/10275694140118864610noreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-84771243700902956262014-01-22T18:19:01.710+05:302014-01-22T18:19:01.710+05:30I got the same error as AnonymousSeptember 3, 2013...I got the same error as AnonymousSeptember 3, 2013 at 3:34 PM. Can you please help me?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-51841836481904809532014-01-08T15:06:53.738+05:302014-01-08T15:06:53.738+05:30thanks dear, got connected in one go.thanks dear, got connected in one go.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-82487156344305751622013-11-05T19:11:12.010+05:302013-11-05T19:11:12.010+05:30Thank You. It's Work...Thank You. It's Work...Newshttps://www.blogger.com/profile/16579936885014759052noreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-4855490106569202712013-09-03T15:34:12.478+05:302013-09-03T15:34:12.478+05:30Hi,
I followed all the steps and getting followin...Hi,<br /><br />I followed all the steps and getting following error. <br /><br />Array ( [0] => Array ( [0] => IMSSP [SQLSTATE] => IMSSP [1] => -49 [code] => -49 [2] => This extension requires the Microsoft SQL Server 2012 Native Client. Access the following URL to download the Microsoft SQL Server 2012 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712 [message] => This extension requires the Microsoft SQL Server 2012 Native Client. Access the following URL to download the Microsoft SQL Server 2012 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712 ) [1] => Array ( [0] => IM002 [SQLSTATE] => IM002 [1] => 0 [code] => 0 [2] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified [message] => [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified ) ) <br /><br /><br />Any help would be appreciated.<br /><br />Thanks,<br /><br />XYZAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-36243177666996656822013-07-03T22:47:38.269+05:302013-07-03T22:47:38.269+05:30hi i have just installed xampp and started the apa...hi i have just installed xampp and started the apache and its running but the mysql service is not running it doesnt start and this is what i see in the details:<br /><br /><br />Attempting to start MySQL service...<br />18:06:29 [mysql] Problem detected!<br />18:06:29 [mysql] Port 3306 in use by ""C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.5\my.ini" MySQL"!<br />18:06:29 [mysql] MySQL WILL NOT start without the configured ports free!<br />18:06:29 [mysql] You need to uninstall/disable/reconfigure the blocking application<br />18:06:29 [mysql] or reconfigure MySQL and the Control Panel to listen on a different port<br /><br />Yanzihttps://www.blogger.com/profile/08960534598857547453noreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-22801186541389371902013-06-21T14:32:20.885+05:302013-06-21T14:32:20.885+05:30Hi, thank you for this tutorial.
I've to add ...Hi, thank you for this tutorial.<br /><br />I've to add some things. If you are using PHP 5.4, the files are different. <br /><br />You have to download the SQLSRV30.EXE, uncompress it and copy to the ext/ folder the following files:<br /><br />php_pdo_sqlsrv_54_ts.dll<br />php_sqlsrv_54_ts.dll<br /><br />Then, add the following lines to the php.ini in the extensions section:<br /><br />extension=php_sqlsrv_54_ts.dll<br />extension=php_pdo_sqlsrv_54_ts.dll Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-2703826620845381062013-05-27T11:37:48.933+05:302013-05-27T11:37:48.933+05:30Hi I did the procedure give above but in my XAMPP ...Hi I did the procedure give above but in my XAMPP i.e, localhost/info.php .... I dont find the SQLSRV instead it shows no value now how to rectify the error am using MS SQLSERVER 2012Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-61777354483434233662013-04-12T18:42:49.173+05:302013-04-12T18:42:49.173+05:30Great my friend.
I find for many days for solution...Great my friend.<br />I find for many days for solutions on compatibility drivers to work with PHP 5.4, apache, SQLITE integrated with MSSQL or SQLSRV.<br />At this page was unique place where i found the solution, simple, clean, and exact. Very very thanks!!!!!!!Paulo Salgadohttps://www.blogger.com/profile/15932692081862421553noreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-24450086657445682542013-03-20T12:40:01.229+05:302013-03-20T12:40:01.229+05:30hi....i need sql server connection with android ec...hi....i need sql server connection with android eclipse...Kindly give me the code so that i can learn it<br />deepikahttps://www.blogger.com/profile/02534113971258200207noreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-48878712418511650722013-02-21T10:29:45.385+05:302013-02-21T10:29:45.385+05:30Download SQL Server 2008 R2 Native Client from
h...Download SQL Server 2008 R2 Native Client from <br /><br />http://www.microsoft.com/en-in/download/confirmation.aspx?id=16978Anonymoushttps://www.blogger.com/profile/01073674332693436793noreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-91384511602096125512012-12-17T02:54:58.208+05:302012-12-17T02:54:58.208+05:30thank's men .. it works !!thank's men .. it works !!Lelanie https://www.blogger.com/profile/09451427628447144941noreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-77046345421064989902012-12-03T20:21:57.995+05:302012-12-03T20:21:57.995+05:30thanks dude!!!!!!!thanks dude!!!!!!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-85753392850969254972012-11-09T14:27:47.152+05:302012-11-09T14:27:47.152+05:30@Anonymous: i got this message
"This extensi...@Anonymous: i got this message <br />"This extension requires either the Microsoft SQL Server 2008 Native Client (SP1 or later) or the Microsoft SQL Server 2008 R2 Native Client ODBC Driver to communicate with SQL Server."Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-59102055216870016652012-11-07T00:27:10.435+05:302012-11-07T00:27:10.435+05:30Thanks Hiren for this page, it's helped me get...Thanks Hiren for this page, it's helped me get SQL Server 2005 working with XAMPP.<br /><br />I'm using:<br />Win XP w/ SP3<br />XAMPP 1.80<br />PHP Version 5.4.4<br />SQL Server 2005 w/SP4<br /><br />For me, the Microsoft drivers listed in Hiren's post above didn't work.<br /><br />(Excerpt from my php.ini)...<br /><br />; Drivers that work are here: http://downloads.php.net/pierre<br />;<br />; http://downloads.php.net/pierre/sqlsrv-5.4-ts-snap.zip<br />; sqlsrv-5.4-ts-snap.zip (2011-11-27 07:20 -0800)<br />; MD5 (sqlsrv-5.4-ts-snap.zip) = 3f885a897171d3a230ed16bf82fec5b9<br />;<br />extension=php_sqlsrv.dll<br />extension=php_pdo_sqlsrv.dl<br /><br />Setup is working now with these drivers.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-69423169485719421692012-11-06T20:45:41.550+05:302012-11-06T20:45:41.550+05:30I have installed SQLSRV20.EXE for my Win XP and MS...I have installed SQLSRV20.EXE for my Win XP and MS SQL 2008 R2 in the ext directory. I can not find php.dll file anywhere. Modified the php.ini file as instructed. When I restart Apache it gives error saying php.ini file not found (something of this sort).<br /><br />Can anybody please help me.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-52485338134400826552012-10-15T04:59:40.668+05:302012-10-15T04:59:40.668+05:30Thanks Hiren; very very much. It works. :)Thanks Hiren; very very much. It works. :)Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-25964723708949299512012-10-11T08:21:05.687+05:302012-10-11T08:21:05.687+05:30i get an error when i want to connect server...thi...i get an error when i want to connect server...this is an error :<br /><br />"Unable to connect.<br /><br />Array<br />(<br /> [0] => Array<br /> (<br /> [0] => 28000<br /> [SQLSTATE] => 28000<br /> [1] => 18456<br /> [code] => 18456<br /> [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.<br /> [message] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.<br /> )<br /><br /> [1] => Array<br /> (<br /> [0] => 28000<br /> [SQLSTATE] => 28000<br /> [1] => 18456<br /> [code] => 18456<br /> [2] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.<br /> [message] => [Microsoft][SQL Server Native Client 10.0][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.<br /> )<br /><br />)<br />"<br />Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-13344892831832710372012-09-05T19:21:24.169+05:302012-09-05T19:21:24.169+05:30it will be in php folder of xampp installation. Yo...it will be in php folder of xampp installation. You must load new extensions by specifying names in php.ini file.Hiren Davehttps://www.blogger.com/profile/03332234242233370508noreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-67893351372119219942012-08-30T19:40:36.837+05:302012-08-30T19:40:36.837+05:30sorry....but i can't find "php.ini" ...sorry....but i can't find "php.ini" file ?<br />and i don't understand what's this paragraph mean:<br />"Now we have to load files that we added recently. Open the php ini file and add entry in the area of dynamic extensions as follow." ?<br />thanks in advance,,Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-896516730491348612012-08-14T21:16:30.133+05:302012-08-14T21:16:30.133+05:30getting as undefined sqlsrv_connect() function...
...getting as undefined sqlsrv_connect() function...<br />please help me in solving this...Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-7442072150765022610.post-60393111269207380892012-07-31T15:44:48.801+05:302012-07-31T15:44:48.801+05:30i got an error This extension requires the Microso...i got an error This extension requires the Microsoft SQL Server 2012 Native Client. Access the following URL to download the Microsoft SQL Server 2012 Native Client ODBC driver for x86 ....<br /><br />any idea???Anonymousnoreply@blogger.com