Re: connecting mssql 2005

Here is a config from one of our apps that connects to an MSSQL 2008 server (the server is setup to use port 3306, but it is MSSQL):

        public $mssqlServer = array(

                'datasource' => 'Datasources.Database/Mssql',

                'persistent' => false,

                'host' => 'host.host',

                'port'=>'3306',

                'login' => 'DBUser',

                'password' => '**********',

                'database' => 'database_name',

                'prefix' => '',

        );

On Thursday, June 6, 2013 5:39:49 AM UTC-4, Nikunj Amipara wrote:

i already had , mssql server 2005 i upgraded it though to 2008 still same error.. this is my config

public $test = array(

'datasource' => 'Database/Sqlserver',

'persistent' => false,

'host' => '192.168.97.10',

//'port' => '3306',

'login' => 'igurutest',

'password' => 'test',

'database' => 'test',

'prefix' => '',

//'encoding' => 'utf8',

); 

On Thu, Jun 6, 2013 at 2:12 PM, abhijit kakade <abhik...@gmail.com> wrote:

Install sql server express edition 2008 on system .. Its a freeware from microsoft .. That will solve this problem

On Jun 6, 2013 11:52 AM, "Nikunj Amipara" <nikami...@gmail.com> wrote:

hi,

I am trying to connect to remote database which is on mssql server and i am getting fallowing error can any one help? 

tried to google this problem but nothing seems to work.

A Database connection using "Sqlserver" was missing or unable to connect. 

The database server returned this error: SQLSTATE[IMSSP]: This extension requires the Microsoft SQL Server 2012 Native Client ODBC Driver to communicate with SQL Server. Access the following URL to download the Microsoft SQL Server 2012 Native Client ODBC driver for x86: http://go.microsoft.com/fwlink/?LinkId=163712 

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+u...@googlegroups.com.

To post to this group, send email to cake...@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to a topic in the Google Groups "CakePHP" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/cake-php/cxs2w2MGgXc/unsubscribe?hl=en.
To unsubscribe from this group and all its topics, send an email to cake-php+u...@googlegroups.com.
To post to this group, send email to cake...@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
 
 

--

                                                                                                                               ..Nikunj.

      (nikami...@gmail.com)
(nik_a...@yahoo.in)
(nikam...@facebook.com)
(amipara...@daiict.ac.in)

--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
 
---
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email to cake-php+unsubscribe@googlegroups.com.
To post to this group, send email to cake-php@googlegroups.com.
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.