sql server odbc: how to mapped the ms access db data to ms sql server -- sql server odbc

Re: how to mapped the ms access db data to ms sql server

Sue Hoegemeier
2/14/2005 8:48:18 AM

You can create a linked server to an Access database. For
more information, check books online for Linked Servers.
If your asp page just needs data in Access, why not have the
page get the data from Access rather than going from SQL
Server and then to Access? You aren't limited to a single
data source in your application and going at the data source
directly would likely be more efficient.

-Sue

On Mon, 14 Feb 2005 08:41:07 +0800, "cEciLlE"
[quoted text, click to view]

Re: how to mapped the ms access db data to ms sql server

Sue Hoegemeier
2/15/2005 6:49:53 AM

Use SQL Server for the data source in your connection
string. Then you'd access the SQL Server data as you would
normally.
You'd access the data for a linked server just as you would
the data in SQL Server. For a linked server, you can
reference the data source with a 4 part name or use the
distributed query functions such as Openquery. Using the 4
part name is probably easier to get started with.
For Access, the four part name would be something like:
SELECT *
FROM NameOfAccessDB...NameOfTable

-Sue

On Tue, 15 Feb 2005 12:12:37 +0800, "cEciLlE"
[quoted text, click to view]

Re: how to mapped the ms access db data to ms sql server

cEciLlE
2/15/2005 8:02:45 AM

thanks for the reply. i will research on the linked servers.

Re: how to mapped the ms access db data to ms sql server

cEciLlE
2/15/2005 12:12:37 PM

I have setup my linked server. and the connection is ok.
but how can i programmatically use the ms sql in my asp.net page?

thanks

Re: how to mapped the ms access db data to ms sql server

cEciLlE
2/16/2005 7:33:53 AM

wow..thank you very much...:)

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server odbc group.