Re: [PHP] MS SQL server connection problem.

2012-09-05 Thread Serge Fonville 
Hi,

why do I need a native client or ODBC driver when I already got this driver
 installed in my system.


You need the Native Client on top of the PHP driver.
The PHP driver implements functions that enable PHP to talk  to SQL Server
through  the Native Client.

HTH

Kind regards/met vriendelijke groet,

Serge Fonville

http://www.sergefonville.nl

Convince Microsoft!
They need to add TRUNCATE PARTITION in SQL Server
https://connect.microsoft.com/SQLServer/feedback/details/417926/truncate-partition-of-partitioned-table



2012/9/5 Girish Talluru girish.dev1...@gmail.com

 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

RE: [PHP] MS SQL server connection problem.

2012-09-05 Thread Jeff Burcher 
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
j...@allredmetal.com

 -Original Message-
 From: Girish Talluru [mailto:girish.dev1...@gmail.com]
 Sent: Wednesday, September 05, 2012 5:57 AM
 To: php-general@lists.php.net
 Cc: rahu...@radiare.co.in
 Subject: [PHP] 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

Re: [PHP] MS SQL server connection problem.

2012-09-05 Thread Girish Talluru 
Hi Jeff - Wonderful - Nice find. Thanks a lot

-Girish Talluru

On Wed, Sep 5, 2012 at 4:43 PM, Jeff Burcher j...@allredmetal.com wrote:

 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
 j...@allredmetal.com

  -Original Message-
  From: Girish Talluru [mailto:girish.dev1...@gmail.com]
  Sent: Wednesday, September 05, 2012 5:57 AM
  To: php-general@lists.php.net
  Cc: rahu...@radiare.co.in
  Subject: [PHP] 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

RE: [PHP] MS SQL server connection problem.

2012-09-05 Thread Andrew Ballard 
On Sep 5, 2012 7:14 AM, Jeff Burcher j...@allredmetal.com wrote:

 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

ODBC may work for you, but it has issues if you need to work with text
longer than 4k if I recall.

The SQLSRV library really is the way to go. Just make sure you have the
correct SQL client library installed and use the SQL for PHP driver that
matches your PHP installation. (Threaded, non-threaded, etc.)

Andrew