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

  • Thread starter Thread starter Daniel
  • Start date Start date
D

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
 
Back
Top