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
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 New to SQL - Connection question...

Author  Topic 

E-ball
Starting Member

1 Post

Posted - 2004-09-14 : 12:45:38
Forgive my ignorance, for I am completely new to SQL. My co-worker copied the .odbc and .mdf files from a client's computer, and has asked me to give him some kind of .csv or other spreadsheet containing the data within these files. I have downloaded and installed SQL Server Express Beta 2005, and don't have a clue as to what I'm doing, and can't connect to this database. I've searched for some kind of tool or utility that would open the files, but I've yet to have any luck. The only thing I've got to connect to one so far was Visual Basic Express Beta 2005, and it would only connect to one file, and the data in it was not what I needed. Can someone be so kind as to point me in the right direction?

Thanks in advance,

E-ball the newbie

chadmat
The Chadinator

1974 Posts

Posted - 2004-09-14 : 13:24:41
You can try attaching the .mdf file with sp_attach_single_file_db. This may or may not work depending on if the .mdf was detached properly. But that is the first thing I would try.

-Chad


http://www.clrsoft.com

Software built for the Common Language Runtime.
Go to Top of Page
   

- Advertisement -