ChronoForms with MS SQL

Hi,

I have to migrate a Joomla 2.5 + ChronoForms system from MySQL to MS SQL 2008. Joomla itself works fine, but I can't install ChronoForms (latest V4) due to MS SQL syntax errors during installation, tables are not created.

Same with ChronoConnect.

Any help would be appreciated to get it work.

Thanks... Bela

Hi Bela,

Sorry, I try to avoid MS SQL and Windows Server as far as possible and have no experience with them :-( There is nothing very clever in the SQL that ChronoForms uses, You can see and edit the queries in /administrator/components/com_chronoforms/install.chronoforms.sql

Bob

Hi Bob

I understand your position. However Joomla itself works fine with MS SQL so sooner or later addons must. I'm porting it now to MS SQL. One issue is a difference in data types but ut can be managed. Where the code fails typically is the LIMIT clause in WHERE queries which is causing a 'Syntax error'. LIMIT n can be replaced with SELECT TOP n but LIMIT n,m requeries more changes in code.

I like ChronoForms and at the moment looks more efficient to port it to MS than look for another forms apps or write my own.

I will let you know the result.

Regards... Bela

Hi bela,

Thanks for the info.

Hopefully Max will be able to use your learning in a future release.

Bob

I have ChronoForms working with Joomla 2.5 and MS SQL-2008. There are few bugs, but I can install component, create, edit and execute forms, create tables, etc. What is missing is the conversation of 'LIMIT n,m'.

It is promissing.

hi,

I'm having the same problem with Sql Server...
..Can you tell me what you did to get it working?

thanks,

Nick