I'm trialling AI currently. I've tried creating a project from our existing WIX environment and am having some success, I certainly prefer working with AI than I do with WIX!
But, I have a problem with the database script.
no matter what functional script I provide, the installer always reports a SQL script error.
Today I have created a package with just the in-built SQLServerConnectionDLG dialogue and the resulting SQL connection config. I added a single script with a single line:
CREATE DATABASE [MyDatabase]
and this fails.
I can browse the SQL server list fine and I can test my connectivity to SQL, but no matter what scripts I provide the installer fails.
I've attached my basic installer to this message if anyone can help?