Access and MSDE

[Joe]

Hi

I have the following problem.

There is a computer running MSDE. This computer has a MDF file.

I'm trying to get this external data. When I use ODBC option in the Get Data
Dialog, I have to create a new DSN and I have to choose SQL Driver.

When this is set, I have to provide the Server Name.

There is no Server.

How can I import this data?

Where can I learn about this process?

Thanks

Joe

 

[Rick Brandt]

Hi

I have the following problem.

There is a computer running MSDE. This computer has a MDF file.

I'm trying to get this external data. When I use ODBC option in the
Get Data Dialog, I have to create a new DSN and I have to choose SQL
Driver.
When this is set, I have to provide the Server Name.

There is no Server.

How can I import this data?

Where can I learn about this process?

SQL Server data has to be "served". You cannot get at it from the file
directly,

 

[Tony Toews [MVP]]

There is a computer running MSDE. This computer has a MDF file.

AFAIK you can't touch, or don't want to, an MDF file not using SQL
Server/MSDE.

I'm trying to get this external data. When I use ODBC option in the Get Data
Dialog, I have to create a new DSN and I have to choose SQL Driver.

When this is set, I have to provide the Server Name.

There is no Server.

I'm no expert on SQL Server/MSDE but you should be able to put in the
computer name as found in Control Panel >> System >> Computer Name tab

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[boblarson]

As Rick has said, you must have an actual SQL Server installation in order to
get data. You cannot use an MDF file directly.

--
Bob Larson
Access World Forums Administrator

Tutorials at http://www.btabdevelopment.com

__________________________________

 

[Stefan Hoffmann]

hi Joe,

There is a computer running MSDE. This computer has a MDF file.

First check the services (services.msc) for the MSDE service, if it is
running then download

http://www.microsoft.com/downloads/...AE-4BD1-4E3D-94B8-5A0F62BF7796&displaylang=en

This tool needs some .NET libraries as well.

You need this tool to discover the name of your MSDE SQL Server. This
can be (local) or (local)\<instanceName>.

With this name you can create an ODBC (odbcad32.exe) using the SQL
Server driver.

Problem: You need to know either the SQL Server security credentials or
your MSDE must run in Windows authentication mode.


mfG
--> stefan <--