Hi Jeff - Wonderful - Nice find. Thanks a lot
-Girish Talluru
On Wed, Sep 5, 2012 at 4:43 PM, Jeff Burcher <jeff@xxxxxxxxxxxxxxx> 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
> 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
>
>
