Install MSDE from Delphi

I can install MSDE from command prompt or batch file, but
I can not install it from delphi, using
shellexecute/winexec calling the batch or setup file with
parameter.
I have not problem executing other executable file from
delphi using function above.
the msde is hanging on the progress of remaining
installation for 15 sec. the progress bar doesn't move on
that point.
other question,
how can I uninstall msde from program ?
any body can help?
thanks,
sebastian.
hi Sebastian,
"sebastian" <contactus@.ikiapik.com> ha scritto nel messaggio
news:13e101c47b98$27d4a7f0$a601280a@.phx.gbl...
> I can install MSDE from command prompt or batch file, but
> I can not install it from delphi, using
> shellexecute/winexec calling the batch or setup file with
> parameter.
> I have not problem executing other executable file from
> delphi using function above.
> the msde is hanging on the progress of remaining
> installation for 15 sec. the progress bar doesn't move on
> that point.
> other question,
> how can I uninstall msde from program ?
please add the /L*v "c:\..\Log.txt" command line parameter in order to
inspect the resulting log file..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

Install an mdf file

Can anyone give me the command line text to install an mdf file? I have a file called contacts.mdf from a Microsoft book and need to install it to MSDE in order to complete the examples in the book.

Thanks in advance.NOt sure if this will work in MSDE, but try sp_attach_db

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ae-az_52oy.asp

Actually, it looks like it will work. Look at step 2 here:

http://support.microsoft.com/kb/q231923/|||Thanks, Chrisrock. I finally got it to work using sp_attach_db.

install

i have downloaded MSDE sql ad I have extract it...

but now I can't install it with the command prompt

Is windows xp home edition a problem?Start the MSDE Service:

You need to start the new instance in order to establish a connection to it. If you specified an instance name during installation then the default service name is MSSQLServer$<InstanceName> where <InstanceName> is the instance name you specified during installation. Example: The service name would be MSSQLServer$Matrix if you specified the instance name to be Matrix during installation. If no instance name was specified the the default service name is simply MSSQLServer.

--> I don't find the MSDE Service: is that caused by HOme Edition?

Inserting XML values

" Insert Into...Value" seems to be the command for inserting new data into an XML Doc. I have also seen people using "Insert...Value" without the "Into" keyword. Is there a difference between "Insert" and "Insert Into"?

There is no difference. 'INTO' is optional keyword for INSERT ... VALUES() statement. It's not only for insert xml value, but for all other sql types.|||thank you :-)

inserting text > 65535

hi,
i want to insert text of size > 65535 in a text column of sql-server. I'm presently using mcp command to do this, but this utility doesn't allow these long files, and work well upto 65 kb files.
is there a way out.
thanks in advanceThis error had been noted back in Version 4.2 of SQL, see technet article
BUG: BCP Cannot Copy Text/Image Data > 64K from SQL Server (Q111921) (http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q111921)

Try setting the packet size on BCP (flag -a) to the max which is 65535|||That doesn't work... I set the size 100000. When I inserted small files that were loaded smoothly. But for bigger files it says max packaet size is 65k.

I rephrase my problem again:::::
=====================
I'm working with sql server.
I need to load large xml files in the databse, fragment it into the
tables.
(1) I don't know a way to load file with the help of script that can load
text value of > 65k. I'm presently doing with the help of "mcp" command.
But this has got size limitation. So how do u load big file in some of the
"text" field of a table.
(2) I need to do fragmentation of this file. But I cannot declare text
type variable in the procedure. I am able to parse files of upto 8000
characters, but how do I do it if I have a document > 8000 char stored in
a "text" field. I just don't know how to call sp_xml_preparedocument with
a text attribute. I think u cannot say something like
sp_xml_preparedocument @.idoc out,(select textfield from doctable)
where idoc and textfield are integer and text respectively.