Returning SQL Query data

Got a problem you cannot solve? Try here.
mtaber
Posts: 13
Joined: Mon Mar 19, 2007 7:12 pm

Returning SQL Query data

Postby mtaber » Tue Mar 20, 2007 5:26 pm

How would I go about running a SQL query against SQL Server and accessing the data from within InstallAware?

What I'm trying to do is develop an installer that is aware of the databases that exist in the SQL Server such that when pointed to a SQL Server instance, it runs sp_databases to query for the existing databases and then display their names in a drop down list or something similar. The user can choose to create a new database, or if the database already exists, simply attach the application to an existing database, but I need to know if the database exists in order to offer them that option.

There are other things I want to do, but basically, I want to be able to parse the rows and columns that come out of a SQL query and act on those results within the installer. Any ideas?

Return to “Technical Support”

Who is online

Users browsing this forum: No registered users and 31 guests