Updated! Solved!
I found the problem. I noticed in my php only testconn.php file that I
do not specify the port because connecting to the mssql via FreeTDS is
a mapping connection, the only thing you need to specify is the name
of the map you setup in the /usr/local/etc/freetds.conf file. Mine
looks like:
[wapps01]
host = 192.168.0.92
instance = SQLEXPRESS
port = 1433
client charset = UTF-8
tds version = 8.0
and my connection statement in the testconn.php file looks like:
$link = mssql_connect('wapps01', 'sa', 'casper');
The real host, port, instance etc are defined in the freetds.conf file
very much like a windows ODBC DSN.
After further inspection of the line of code dbo_mssql.php, line 144 I
noticed it was appending the port number 1433 to my server mapping
name.
I corrected the problem by adding the 'port' => '' to my database.php
default config as in:
var $default = array(
'driver' => 'mssql',
'persistent' => false,
'host' => 'wapps01',
'login' => 'sa',
'password' => 'casper',
'database' => 'ChemDry',
'encoding' => 'utf8',
'port' => ''
);
I could have also corrected the problem by adding a definition in my
freetds.conf file of [wapps01:1433]
Thank you for being my sounding board and I hope this helps someone
else in the future.
For further reading on setting up freetds for use with php on unix
accessing an mssql I followed the example given here:
http://docs.moodle.org/en/Installing_MSSQL_for_PHP
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
