Re: Cake php connection with MS Sql Server 2000

I haven't seen anyone ever comment that they actually figured out how
to make this work. We attempted it, but there were all kinds of
problems. First, trying to find a driver for linux that would allow
us to make a connection through cake to SQL Server was a huge
problem. We could manually make connections, but couldn't get cake to
connect.

Second, the queries that cake was generating weren't really compatible
with SQL Server. The only solution for this that I know of is to
write your own queries. Which kind of defeats the purpose of all the
auto magicness.

We ended up writing some custom code that would sync data across our
databases. What a pain! It's the only way we knew how to get the
data we needed from SQL Server though. If possible I would suggest
just moving your data to mysql and starting there. it will probably
save you a lot of pain and headache. In our case we couldn't do that
because we're still using a legacy app that requires SQL Server.

Good luck! If you figure it out, I would love to see everything that
you had to do to get it to work, including linux driver configurations
and everything. I'm sure other people would find it useful.

On May 28, 11:59 pm, manohar <manohar...@gmail.com> wrote:
> hi,
>
>  When I am trying to connect with MS Sql Sever 2000 database, it
> shows
>
> Notice (1024): Please change the value of 'Security.salt' in app/
> config/core.php to a salt value specific to your application [CORE\cake
> \libs\debugger.php, line 556]
>
> Your tmp directory is writable.
>
> The FileEngine is being used for caching. To change the config edit
> APP/config/core.php
>
> Your database configuration file is present.
>
> Cake is NOT able to connect to the database.
>
> Any help would be greatly appreciated!
>
> --Manohar
> manohar...@gmail.com
--~--~---------~--~----~------------~-------~--~----~
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+unsubscribe@googlegroups.com
For more options, visit this group at http://groups.google.com/group/cake-php?hl=en
-~----------~----~----~----~------~----~------~--~---