SQL Server 2008 driver for CakePHP?

2010-06-22 Thread gbudiman
I've the weirdest development environment I can think of: IIS, SQL
Server 2008, and PHP. I'm not going with ASP.NET or Silverlight, so
please don't direct me there. I've had trouble setting up CakePHP
configuration for SQL Server 2008 database.

This is my configuration (CakePHP):
class DATABASE_CONFIG {
var $default = array(
'driver' = 'mssql',
'persistent' = true,
'host' = '',
'database' = '...',
'prefix' = ''
);
}
And the welcome page will only output Your database configuration
file is present. and white page afterwards. CSS is not loaded, and
help content after that is not displayed. If I changed 'driver' =
'mysql', CSS is loaded, help content appeared. (URL rewriting works
fine, it's not the problem)

Normally, connection string on old school PHP development is:
$serverName = '(local)';
$connectionInfo = array(Database = ...);
$connectionResource = sqlsrv_connect($serverName, $connectionInfo);
And it works fine. (Yes, that's the new php_sqlsrv.dll driver, not the
old php_mssql.dll)
How do we fix this on CakePHP?

Thanks

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: SQL Server 2008 driver for CakePHP?

2010-06-22 Thread Carlos Lavin
Well, you pretty much need to write a new dbo that implements the new SQL
Server connections. If you look around in google there's this unfinished dbo
driver with still quite a few opportunity areas, but I guess it's better
than starting from scratch

2010/6/22 gbudiman wahy...@gmail.com

 I've the weirdest development environment I can think of: IIS, SQL
 Server 2008, and PHP. I'm not going with ASP.NET or Silverlight, so
 please don't direct me there. I've had trouble setting up CakePHP
 configuration for SQL Server 2008 database.

 This is my configuration (CakePHP):
 class DATABASE_CONFIG {
var $default = array(
'driver' = 'mssql',
'persistent' = true,
'host' = '',
'database' = '...',
'prefix' = ''
);
 }
 And the welcome page will only output Your database configuration
 file is present. and white page afterwards. CSS is not loaded, and
 help content after that is not displayed. If I changed 'driver' =
 'mysql', CSS is loaded, help content appeared. (URL rewriting works
 fine, it's not the problem)

 Normally, connection string on old school PHP development is:
 $serverName = '(local)';
 $connectionInfo = array(Database = ...);
 $connectionResource = sqlsrv_connect($serverName, $connectionInfo);
 And it works fine. (Yes, that's the new php_sqlsrv.dll driver, not the
 old php_mssql.dll)
 How do we fix this on CakePHP?

 Thanks

 Check out the new CakePHP Questions site http://cakeqs.org and help others
 with their CakePHP related questions.

 You received this message because you are subscribed to the Google Groups
 CakePHP group.
 To post to this group, send email to cake-php@googlegroups.com
 To unsubscribe from this group, send email to
 cake-php+unsubscr...@googlegroups.comcake-php%2bunsubscr...@googlegroups.comFor
  more options, visit this group at
 http://groups.google.com/group/cake-php?hl=en




-- 
-Carlos

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: SQL Server 2008 driver for CakePHP?

2010-06-22 Thread Carlos Lavin
Another problem I've come across using IIS with cake is that IIS has
problems when using : in your urls, so you'll probably need to change that
in cakephp's libs if you intend to use it for params

2010/6/22 Carlos Lavin carloslavi...@gmail.com

 Well, you pretty much need to write a new dbo that implements the new SQL
 Server connections. If you look around in google there's this unfinished dbo
 driver with still quite a few opportunity areas, but I guess it's better
 than starting from scratch

 2010/6/22 gbudiman wahy...@gmail.com

 I've the weirdest development environment I can think of: IIS, SQL
 Server 2008, and PHP. I'm not going with ASP.NET or Silverlight, so
 please don't direct me there. I've had trouble setting up CakePHP
 configuration for SQL Server 2008 database.

 This is my configuration (CakePHP):
 class DATABASE_CONFIG {
var $default = array(
'driver' = 'mssql',
'persistent' = true,
'host' = '',
'database' = '...',
'prefix' = ''
);
 }
 And the welcome page will only output Your database configuration
 file is present. and white page afterwards. CSS is not loaded, and
 help content after that is not displayed. If I changed 'driver' =
 'mysql', CSS is loaded, help content appeared. (URL rewriting works
 fine, it's not the problem)

 Normally, connection string on old school PHP development is:
 $serverName = '(local)';
 $connectionInfo = array(Database = ...);
 $connectionResource = sqlsrv_connect($serverName, $connectionInfo);
 And it works fine. (Yes, that's the new php_sqlsrv.dll driver, not the
 old php_mssql.dll)
 How do we fix this on CakePHP?

 Thanks

 Check out the new CakePHP Questions site http://cakeqs.org and help
 others with their CakePHP related questions.

 You received this message because you are subscribed to the Google Groups
 CakePHP group.
 To post to this group, send email to cake-php@googlegroups.com
 To unsubscribe from this group, send email to
 cake-php+unsubscr...@googlegroups.comcake-php%2bunsubscr...@googlegroups.comFor
  more options, visit this group at
 http://groups.google.com/group/cake-php?hl=en




 --
 -Carlos




-- 
-Carlos

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
CakePHP group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en