This sounds a bit tricky for SQL Server as the Database is centrally located. The only path you can change is for the Database Files i.e. .mdf and .ldf You can attach or detach the database files. I am not sure how you can change the default path when you create the Database programmatically thought I know how to create the Database Programmatically. The files will automatically go to:
C:\Program Files\Microsoft SQL Server\MSSQL\Data May be there is someone out there who knows how to do it. For generating the Database programmatically, you can have a module in your program which checks if the SQL Server Exists, if it does not exist, then it should be create. This does not need to be done when you are creating Packaging and Deployment. It can be done when you run your application and be executed when you run your MDI Form. For any clarification or code just contact me. Regards, Peter MUGOH -----Original Message----- From: star star [mailto:[EMAIL PROTECTED] Sent: Friday, December 31, 2004 11:20 AM To: [EMAIL PROTECTED] Subject: [Visual Basic 6 programming] how to generate DB automatically when installation? Hi... i'm a newbie in VB i am making an application wih VB6 & SQL server7. I want to install this application to another computer. In that computer, the first screen to display is the screen contain the path to put the database (as user wish), after that the application has to generate database automaticcally.This screen just appear ONCE - when the first time user install this application. The problem : i don't know how to make this. Can anyone help me,please!? Thanx before... --------------------------------- Do you Yahoo!? Yahoo! Mail - You care about security. So do we. [Non-text portions of this message have been removed] Yahoo! Groups Links ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/k7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To reply to this message, go to: http://groups.yahoo.com/group/visualbasic6programming/post?act=reply&messageNum=18604 Please do not reply to this message via email. More information here: http://help.yahoo.com/help/us/groups/messages/messages-23.html <*> To visit your group on the web, go to: http://groups.yahoo.com/group/visualbasic6programming/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
