Linked tables -- sql server odbc

Harlan Dorado
2/10/2004 6:21:43 AM

Hey,
I'm trying to link a table in an Access 2000 DB to a table in an MS SQL
Server 2000. As you might have guessed by now I'm not having any luck
with this.

This is what I've done:
I've used a file-dsn, which logs on to the SQL Server DB using the
logged on NT account. This account, which is used to log on to the
website, has sufficient permissions to view the data in the linked
table. I've also tested the dsn locally and it all works fine. Still,
when I try to execute a query from the website, which uses data from the
linked table, I get an error message saying this:

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] ODBC--connection to 'SQL
Server(local)' failed.

Does anyone have a clue?

______________
the woim toins

*** Sent via Developersdex http://www.developersdex.com ***

Mary Chipman
2/11/2004 10:16:13 AM

Instead of a DSN, you'd be better off writing code and supplying the
connection information directly through the connection string in
VBA/DAO to link tables. DSNs are notoriously difficult to support and
debug. Examples of ODBC connection strings can be found at
http://www.able-consulting.com/ADO_Conn.htm. Also, make sure that the
Windows user/group has been granted a login and permissions in the
database if you are using integrated security.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

On Tue, 10 Feb 2004 06:21:43 -0800, Harlan Dorado
[quoted text, click to view]

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 about sql server odbc

sql server odbc : Linked tables