Exec a stor.proc. that includes a query to a linked Access db

[Daniel]

I have a stored procedure in SQL Server 2005 Express. It includes a
distributed query that pulls from a table in a local SQL Server
database, and combines this with some data in a remote Access
database. I have that Access db referenced in SQL Server Express as a
linked server, and have had no trouble querying against it from with
SQL Server Mgmt Studio.

However, when calling the sp from within VB Express, the server always
returns an error that the linked server could not be found and I need
to run sp_addlinkedserver (which I've already done) to register it.

Is this a security issue, or a restriction of using the Express
editions of SQL Server and/or VB 2005, or something else. I've tried
executing the sp in code and through the IDE. Neither works.

Thanks,
Daniel

 

[Cor Ligthert [MVP]]

Daniel,

Your message sounds strange for me, can I assume that you have both servers
connected using a connection string and using normal AdoNet and SQL language
code to get your information.

http://www.connectionstrings.com/

Cor