Save to external MSSQL....Any updates to make this work?

I've been trying (it seems like forever) to make the save to external database work with MSSQL. I have php configured correctly and can connect with raw php code while testing, but when I enter the exact same variables into the DB Save fields, I get a Failed To Connect error. I've seen older posts regarding this, and the responses in the forums have been quick, but the call to action has been crickets and there seems to be no movement or just dead silence.

I can save to the MySQL database just fine, but our corporation has a company database built on MSSQL and I need the form data to be captured to that server and appropriate database. I've matched up the form field for field, only I can't make a simple connection via Chronoforms to complete the task.

Hi mmaack,

If you add a Debugger you should see the Query being created by ChronoForms. IIRC there are some differences in MSSQL that mean that the MySQL query that ChronoForms uses to get the table structure fails.

Alternatively if you have it working in PHP then use a Custom Code action and add your PHP there.

Bob

I've been thinking along the same lines since I can write code to query the MSSQL successfully. I'm working on a custom script and will see where that takes me.

Thanks for the response.

Mark