Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Linked server to acces DB file Expand / Collapse
Author
Message
Posted Monday, June 22, 2009 8:55 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 23, 2009 1:06 AM
Points: 2, Visits: 4
Hi all, please help if anyone can, I am sure here are masters :) i create linked server to access file in which I have localtalbes, linked tables to oracle dband linked tables to SQL DB, I can query all locals and SQL talbes from this linked server but when I try to query

"SELECT * FROM TEST1...VASO_LOAN_UPDATES"
where "VASO_LOAN_UPDATES" is linked table to oracle DB

I receive error

"Msg 7306, Level 16, State 2, Line 1 Cannot open the table "VASO_LOAN_UPDATES" from OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "TEST1". The specified table or view does not exist or contains errors."

how can I fix it? Tnx advance
Post #739462
Posted Monday, June 22, 2009 9:27 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 9:56 AM
Points: 31,035, Visits: 15,461
First, I think you need to use the four part naming, not ....

Second, are you sure the credentials used for the linked server can access that item?







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #739506
Posted Tuesday, June 23, 2009 1:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, June 23, 2009 1:06 AM
Points: 2, Visits: 4
how can I use four part naming in case of link from access file, and all this tables are accessible from access
Post #739935
Posted Tuesday, June 23, 2009 8:52 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 9:56 AM
Points: 31,035, Visits: 15,461
OK, I'm confused, are you writing the query in Access?

It's not clear what linked servers you have, and where you are querying. If the tables are in Access, then you would use the ... instead.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #740257
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse