Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2001
    Posts
    24

    Unanswered: How do I access a mdf-file directly?

    Hello!

    I want to access a sql server file without having sql server installed on my laptop. How can I do this? Can you give me an example please because I'm new with it.
    Thx a lot!

    Tom

  2. #2
    Join Date
    Dec 2001
    Location
    Toronto, Canada
    Posts
    335
    I don't think this can be done. The closes you can get is to do a minimial installation, use the Personal Desktop edition. I don't think there is any tool our COM object that will allow one to open the file and read throuigh it.

    If you need to analyse some data or tables you could export the data to MS Access, Excel or flat files.

  3. #3
    Join Date
    Oct 2001
    Location
    England
    Posts
    426
    You will need to install either msde (I think) or sql server then you can do a sp_attach_single_file_db to access the database.

  4. #4
    Join Date
    Nov 2001
    Posts
    36
    I dont think that you would be able to do it.
    But as suggested previously, you can try minimal installation and then get the data out in the format that you want.

    Thanks

  5. #5
    Join Date
    Dec 2001
    Location
    chennai
    Posts
    21

    Try MSDE

    hii
    i think there is a microsoft desktop engine which minimally installs the components required by SQL. Try that that. i dont have info on that at the moment . will try to get u
    K.Ramakrishnan
    Chennai

  6. #6
    Join Date
    Dec 2001
    Location
    chennai
    Posts
    21

    MSDE

    hii
    Install MSDE which comes in the office 2000 Cd and Use SQL DMO object and attach it to the instance of MSDE. Try , it should work

    K.Ramakrishnan
    Chennai

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •