[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
Re: [PHP] MS SQL server connection problem.
Hi Jeff - Wonderful - Nice find. Thanks a lot
-Girish Talluru
On Wed, Sep 5, 2012 at 4:43 PM, Jeff Burcher 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
>
>
[PHP] Pre-populating of a form with known info from database
Hi All, I have a form using aspx whenever user access the page based on the pre-known information of the user i need to prefill certain fields from the batabase but the challenge is i can't use the asp or touch any existing code. Any suggestions. Thanks, Girish Talluru
Re: [PHP] Risks involved in MyISAM to Innodb
Samuel, Can you please send the DBMS list address? Thanks, Girish On Fri, Sep 21, 2012 at 6:08 AM, Samuel Lopes Grigolato < samuel.grigol...@gmail.com> wrote: > I would start trying my DBMS user list. Or maybe you're afraid of impacts > on > PHP code? > > Cheers. > > -----Mensagem original- > De: Girish Talluru [mailto:girish.dev1...@gmail.com] > Enviada em: sexta-feira, 21 de setembro de 2012 10:04 > Para: php-general@lists.php.net > Assunto: [PHP] Risks involved in MyISAM to Innodb > > Hi Guys, > > I have requirement to change my production database tables which are using > myISAM and now bcoz of some changes we have to move to Innodb. > > Can anyone suggest how the plan should be and risks involve? > > Thanks, > Girish Talluru > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > >
Re: [PHP] Risks involved in MyISAM to Innodb
Thanks a lot Samuel. Appreciate your help. On Fri, Sep 21, 2012 at 6:20 AM, Samuel Lopes Grigolato < samuel.grigol...@gmail.com> wrote: > Sure, the address you’re looking for is: http://lists.mysql.com/ > > ** ** > > Good hunting =) > > ** ** > > *De:* Girish Talluru [mailto:girish.dev1...@gmail.com] > *Enviada em:* sexta-feira, 21 de setembro de 2012 10:15 > *Para:* Samuel Lopes Grigolato > *Cc:* php-general@lists.php.net > *Assunto:* Re: [PHP] Risks involved in MyISAM to Innodb > > ** ** > > Samuel, Can you please send the DBMS list address? > > ** ** > > Thanks, > > Girish > > On Fri, Sep 21, 2012 at 6:08 AM, Samuel Lopes Grigolato < > samuel.grigol...@gmail.com> wrote: > > I would start trying my DBMS user list. Or maybe you're afraid of impacts > on > PHP code? > > Cheers. > > -Mensagem original- > De: Girish Talluru [mailto:girish.dev1...@gmail.com] > Enviada em: sexta-feira, 21 de setembro de 2012 10:04 > Para: php-general@lists.php.net > Assunto: [PHP] Risks involved in MyISAM to Innodb > > > Hi Guys, > > I have requirement to change my production database tables which are using > myISAM and now bcoz of some changes we have to move to Innodb. > > Can anyone suggest how the plan should be and risks involve? > > Thanks, > Girish Talluru > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > ** ** >
