dcsimg
Results 1 to 3 of 3

Thread: I Want To Add SQL Server 2005 Express To Setup Factory

  1. #1

    Thread Starter
    Member
    Join Date
    Jul 2012
    Posts
    41

    I Want To Add SQL Server 2005 Express To Setup Factory

    I have limited knowledge with MS SQL Server 2005 Express Edition however i have rewritten my application to use it as a data source rather than MS Access 2000. the problem is in my install package. what i desire is for my installer to detect the presence of MS SQL Server or any of the free versions of SQL server that microsoft has and if it finds it, then create my database and fields along with the required username and password. if MS SQL server isn't found then my installer should install MS SQL Server 2005 Express Edition and create the database, fields and username/password. I'm not really needing an "application", but simply an installer answer. I already have the application and the installer for that. i just need the code necessary to detect and or install sql server and my database. the installer software i use is indigo rose setup factory 7 which has it's own scripting engine based on the popular LUA language.

    what i would like is for someone to create an installer package with any generic simple application like "hello world" and include the database requirements i'm looking for. or, if it can be done without any actual application in the install then great. of course it would be nice if it was done in setup factory, however anything i could get and use in setup factory will work. the database you use can just be a few fields, something simple. i just need the basic idea and code for this and can modify myself. I plan to include sql server 2005 express edition in my application setup.

    Thanks!

  2. #2
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    32,378

    Re: I Want To Add SQL Server 2005 Express To Setup Factory

    Well you failed to mention what installer you're using.


    If you're using the Click-Once method...
    Go to your project properties screen (select the project in the Solution Explorer and press Alt+Enter to open it) ... select the "Publish" tab... click the Prerequisites button... find the proper version of SQL Server you want to have included... select any others as needed, then select what kind of installation option do you want... OK. Save. Done....


    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  3. #3
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    12,894

    Re: I Want To Add SQL Server 2005 Express To Setup Factory

    Well since you are using Setup factory [which has nothing at all to do with VB] your question should not be in the VB6 section.

    I'm not sure you are even allowed to include SQL Express in your install package and I do not use Setup Factory so have no idea how you would need to script it to do what you ask.

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width