Hi,
I am relatively new as well. I tried both of those methods with no luck. I
finally had success using odbc_connect(). See below:
$conn = odbc_connect("Driver={SQL
Server};Server=$server;Database=$database;", $user, $password);
Thanks,
Jeff Burcher - IT Dept
Allred Metal Stamping
PO Box 2566
High Point, NC 27261
(336)886-5221 x229
jeff@xxxxxxxxxxxxxxx
> -----Original Message-----
> From: Girish Talluru [mailto:girish.dev1986@xxxxxxxxx]
> Sent: Wednesday, September 05, 2012 5:57 AM
> To: php-general@xxxxxxxxxxxxx
> Cc: rahul.j@xxxxxxxxxxxxx
> Subject: MS SQL server connection problem.
>
> Hi All,
>
> I'm having problem while connecting to MS SQL server from my php
> program.
>
> I tried downloading driver from Microsoft and changed php.ini file but it
is
> showing the following error.
>
> This statement I used to connect.
> $connect = mssql_connect("localhost", "PC6", "password");
>
> This is the error message I got
> Call to undefined function mssql_connect() in
> C:\wamp\www\Test\dbTest.php
>
> Then I tried other one as shown below:
>
>
> This statement I used to connect.
> $connect = sqlsrv_connect("localhost", "PC6", "password");
>
> This is the error message I got
> 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 ) )
>
> It is asking to download a native client. but i have already downloaded a
> driver at http://www.microsoft.com/en-in/download/details.aspx?id=20098
> named SQLSRV30.EXE
>
> why do I need a native client or ODBC driver when I already got this
driver
> installed in my system.
>
> Please help me out with this guys. I'm new to this.
>
> Thanks,
> Girish Talluru
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
