sql server programming: Hi

Sori, but how is possible to open a DBF file with MSDE.

The server MSDE is already instaled, but I d'ont know how atache the
Teste.mdb file?

Is necessary to run same script?

Please urgent.

H.S.

Sory. Is MDF file!

Ok!

H.S.



"H.S." <tata@tata.pt> escreveu na mensagem
news:newscache$0wldsh$fz4$1@newsfront4.netvisao.pt...
[quoted text, click to view]

Hi

Check out http://support.microsoft.com/default.aspx?scid=kb;EN-US;224071 if
you have a log file as well. If you only have the data file type
sp_attach_single_file_db See http://tinyurl.com/2o9p8

You can do this from osql

John
[quoted text, click to view]

hi H.S.
"H.S." <tata@tata.pt> ha scritto nel messaggio
news:newscache$0wldsh$fz4$1@newsfront4.netvisao.pt...
[quoted text, click to view]
you can actually not open a SQL Server database this way... a SQL Database
is a logical entity composed by physical entities too... usually a .Mdf data
file and a .Ldf transaction log file at least..
those files have to be mapped in a logical entity in the SQL Server
workspace... this process is known as "attach" ...
in order to attach existing detached SQL Server/MSDE database to a MSDE
instance, you have to run the system stored procedure sp_attach_db with the
syntax
EXEC master..sp_attach_db 'database_name' ,
@filename1 = 'physical_position_of_the_MDF_file' ,
@filename2 = 'physical_position_of_the_LDF_file'

up to 16 filenames can be provided.... you can have a look at the system
stored procedure sp_attach_db syntax and synopsis in Books On Line, not
provided with MSDE but freely available for downloat at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp ..

in order to execute that statement, you have to use oSql.exe, the command
line tool provided with MSDE.. please have a look at
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003 for further
info about using oSql.exe...

for your convenience, you can have a look at a free prj of mines, at the
link following my sign., which provides a user interface similar to
Enterprise Manager that includes this feature too...
further graphical tools for MSDE can be found at
http://www.microsoft.com/sql/msde/partners/default.asp and at
http://www.aspfaq.com/show.asp?id=2442
hth
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.5.0 - DbaMgr ver 0.51.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply

Hi.

OK. But where do I write the script text? In the MSDE setup? If ok, it is
necessary to install new MSDE with this new script?

Thanks

H.S.

Hi

You will need to include the installation of MSDE as part of your own setup,
this will also have to include the unpacking of your DBF file and the
subsequent attachment. The attachment can be done by running osql. There is
some information on the MSDE web site regarding how to use the merge modules
and integrate it into your own setup
http://www.microsoft.com/sql/msde/techinfo/reskit.asp

John
[quoted text, click to view]