We’re moving our forums to a new platform.

You can still browse and search existing topics, but you can no longer create new topics or post replies.

For questions, technical issues, or feature requests, please don’t hesitate to contact our support team at support@advancedinstaller.com.

Thank you for your understanding!

gj1118
Posts: 4
Joined: Thu Mar 07, 2013 5:54 pm

Cannot Run SQL Scripts

Hi ,

I am trying to execute a sql script that will create a MsSql Database (There are other things that this script will do , but that's later). However when I try to run the installer, the script is not executed and the installer fails with the message that it cannot find the datasource .

For your kind reference I have attached the aip file alongwith this post.

I have one more feature request. Can you please allow support for ADO.NET compatible assemblies as well so that I don't have to use ODBC ? I mean the user could simply mention in the connection string the provider . The user could install the provider (if its needed) as a step in the installer.

Please suggest..

Thanks and Regards
Gagan Janjua
Attachments
VantiveDatabase.aip
DatabaseInstaller.aip
(27.83 KiB) Downloaded 416 times
gj1118
Posts: 4
Joined: Thu Mar 07, 2013 5:54 pm

Re: Cannot Run SQL Scripts

anybody :?:
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Cannot Run SQL Scripts

Hello Gagan,
I am trying to execute a sql script that will create a MsSql Database (There are other things that this script will do , but that's later). However when I try to run the installer, the script is not executed and the installer fails with the message that it cannot find the datasource .

For your kind reference I have attached the aip file alongwith this post.
I'm not sure why this happens. Can you please test the SQL connection and make sure that the connection string parameters are correct?
I have one more feature request. Can you please allow support for ADO.NET compatible assemblies as well so that I don't have to use ODBC ? I mean the user could simply mention in the connection string the provider . The user could install the provider (if its needed) as a step in the installer.
Indeed, we don't have ADO.NET support. We'll consider this in a future version, but since yours is the only request implementing it has very low priority. Thank you for your suggestion. However, in order to achieve what you want you can develop your own custom action.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
gj1118
Posts: 4
Joined: Thu Mar 07, 2013 5:54 pm

Re: Cannot Run SQL Scripts

Thanks the link works . my connection string was not well formed.
Daniel
Posts: 8283
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Cannot Run SQL Scripts

You're welcome. I'm glad you got this working.

All the best,
Daniel
Daniel Radu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube

Return to “Building Installers”