dms
Posts: 164
Joined: Tue Aug 28, 2007 7:11 am
Location: UK

Database connection wizzard

I'm not sure if this has been requested before because I may not have used the right criteria for seraching this forum, but if it has I apologise for repeating it and if it hasn't then all well and good.

Are there any plans to add a databse connection wizzard to AI, so that during an installation an end user to point to a real database on their system and thus be certain that they have a genuine, working connection string.

This would be an incredibly useful feature, especially if it could be configured in such a way to allow for either native sql connections or ODBC connections.

Almost any data driven application that one develops always leaves you with the problem of ensuring that connection strings on development machines that you work on do not take priority over connection strings that may exist for your end user. Being able to establish these during the installation routine would be so much easier.

Dom
Cosmin
Posts: 5797
Joined: Tue Jul 10, 2007 6:39 pm
Contact: Website

Hi,

About 90% of what you need is already supported by Advanced Installer. In order to do this, you can use the "SQLConnectionDlg" dialog in the "Dialogs" page and the Test SQL connection How-To in the help:
http://www.advancedinstaller.com/user-g ... ction.html

The "SQLConnectionDlg" dialog allows the user to enter the information for the SQL connection and the custom action allows you to test the information entered by the user.

However, we have on our TODO list a feature which will allow the user to select a SQL server from the target computer. Also, the fields used by the SQL connection will be populated automatically according to the selected server.

Regards,
Cosmin
Cosmin Pirvu - Advanced Installer Team
Follow us: Twitter - Facebook - YouTube
dms
Posts: 164
Joined: Tue Aug 28, 2007 7:11 am
Location: UK

Cosmin

However, we have on our TODO list a feature which will allow the user to select a SQL server from the target computer. Also, the fields used by the SQL connection will be populated automatically according to the selected server.


That's great news, any idea what time frame you have in mind for that?

Dom
gabriel
Posts: 15
Joined: Mon Mar 17, 2008 3:39 pm
Location: Craiova
Contact: Yahoo Messenger

Hi,

We are sorry, but we can not give you an ETA for this feature. However we have increased its priority so rest assured it will be implemented sooner than later.

In the mean time, i suggest following Cosmin's advice on how to solve your problem.

Regards,
Ovidiu

Ovidiu Blejdea
Advanced Instaler Team
http://www.advancedinstaller.com
sanket007hzb
Posts: 1
Joined: Thu May 16, 2013 12:22 pm

Re: Database connection wizzard

Hello AI Team,

I need to pass the database strings by hardcoding it in AI trial edition for SQL Server 2005, I don't intend to enter connection details, like server name, port no. etc, when the installer runs. Is it possible to achieve this?

Thanks in advance!

Sanket
Daniel
Posts: 8276
Joined: Mon Apr 02, 2012 1:11 pm
Contact: Website

Re: Database connection wizzard

Hello Sanket and welcome to Advanced Installer forums,

Thank you for your interest in Advanced Installer.

In order to achieve this you can simply add and configure an SQL connection from our "SQL Scripts" page. Please take a look on our Configure most common SQL connections articles.

If you have any questions let us know.

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

Return to “Feature Requests”