Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 deploying SQL Server on to a CD

Author  Topic 

redbull8vodka
Starting Member

1 Post

Posted - 2005-09-02 : 03:36:01
Hi Well this is my first post on this forum, in fact I have not even used SQL Server yet!

My question is.... I have been asked to produce an application which will be a VB6 application with an SQL Server database behind it. I would like to be able to put the application along with the database on to a CD and run them directly from the CD once it is distributed. So the question I guess is can this be done with SQL Server i.e. can a table be exported in a format which will allow it to be queried in a standalone fashion? Maybe I have not explained myself properly but I welcome any questions which will help clarify my problem.

Thanks Red

nr
SQLTeam MVY

12543 Posts

Posted - 2005-09-02 : 08:15:42
To access sql server you need sql server installed on the machine.
You can install msde progromatically as it is a free version.
Once that is installed (which includes creating the system databases on disk) you can access databases on removable media like CD's.

You might find it easier to use access.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -