MSDE on CD

Is it possible to run MSDE from a CD ROM? What I want to
do is create a system using the SQL Server. First, I want
to create a process using DTS to import a text file into
SQL Server. Then from there write a program in VB to
manipulate that data from the sql server. I want to run
all this from a CD-ROM. Is this possible? What would I
need to run the app from the CD? Would the client need to
install any files to run the sql server or vb app? ANy
and all help would be appreciated.
Mike
hi Mike,
"Mike" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:1123001c4166a$f6c84140$a001280a@.phx.gbl...
> Is it possible to run MSDE from a CD ROM? What I want to
> do is create a system using the SQL Server. First, I want
> to create a process using DTS to import a text file into
> SQL Server. Then from there write a program in VB to
> manipulate that data from the sql server. I want to run
> all this from a CD-ROM. Is this possible? What would I
> need to run the app from the CD? Would the client need to
> install any files to run the sql server or vb app? ANy
> and all help would be appreciated.
> Mike
SQL Server must be installed on a pc in order to run it... it can be
installed remotely and you can connect from a remote client, but it must be
installed somewhere on the LAN... you can partially store the databases on
CD (please have a look at
http://msdn.microsoft.com/library/de...es_03_92hx.asp)
but the core engine and all system stuffs must be installed..
VB apps also require all VB runtime and dependencies to be locally
installed... you can then run your app from a CD, but all related VB stuffs
have to be installed and properly registered...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply