For future reference to someone with the same problem. while using the driver adodb, you should use connect odbc_mssql for SQL Server
On 4 Feb, 10:33, hellfish <[EMAIL PROTECTED]> wrote: > Hi, > > I'm having a bit of a problem using SQL Server Database as data > storage. > > My setup: > > Cakephp 1.1 > SQL Server 2005 > ADOdb library in the vendors folder > > my current connection: > driver = adodb > connect = odbc > > The connection is made (I spend a few days figuring the right way to > do this) but the queries are not made correctly. The app worked fine > using an identical structure in MySQL but with SQL Server I get an > invalid argument supplied for foreach() in line 223 of the cake\libs > \model\dbo\dbo_adodb.php > > This results in having a query like SELECT 0 FROM "table"... > > Has anyone experienced this problem? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Cake PHP" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/cake-php?hl=en -~----------~----~----~----~------~----~------~--~---
