I have a microsoft SQL server that I need to connect to.
It has fields that are of type 'Text' which I can not read or write to
with the dbo_mssql.php.
This is a Unix->mssql issue for data type 'Text'
There are a couple of ways to get around this. one is to load FreeTDS
which I have done.
I created a simple php file which uses the built in php mssql
functions mssql_connect, mssql_query, etc. this test file is able to
connect and query and display the data I need.
So I next setup a cakephp project with a db config as:
class DATABASE_CONFIG {
var $default = array(
'driver' => 'mssql',
'persistent' => false,
'host' => 'wapps01',
'login' => 'sa',
'password' => 'password',
'database' => 'mytestdb',
'encoding' => 'utf8'
);
}
When I visit the home page for the cake app to see if it passes all
the default test I get the following error:
Warning (2): mssql_connect() [function.mssql-connect]: Unable to
connect: Adaptive Server is unavailable or does not exist (severity 9)
[CORE/cake/libs/model/datasources/dbo/dbo_mssql.php, line 144]
Has anyone been able to connect to mssql database that uses 'text'
fields?
Has anyone been able to use FreeTDS to connect to mssql from cake.
Looking for some quantity of suggestions or ideas on how I can further
debug this problem and get to a solution.
(I'm really starting to hate microsofts lack of support for non
windows access.)
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"CakePHP" 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
-~----------~----~----~----~------~----~------~--~---
