Forum OpenACS Q&A: porting acs sql to mssql7.0
definitions to mssql 7.0. Can anyone send to me (or point me to) the
changes that were made to acs to support postgres? For instance, I
expect that decode (a non-standard sql construct) does not work on
postgres. Any help would be appreciated. Thanks.
What I think would be best for you to do is wait until ACS 4 comes out. We are waiting for ACS 4 so we can port it to PostgreSQL and it's going to be much better to port it because of the new aD database API.
Porting to MS-SQL now would be a waste of time and effort, unless you want to stay with ACS 3.2.2 (or 3.2.3) forever and lose the delicious goodies in ACS 4.
If I had access to a Win2K (or NT) box I could write some documentation on how to get it up and running on that environment. All you need is get PostgreSQL and AOLserver running on NT, then get OpenACS installed and be happy.