-
connecting frm ms-sql - mdb - Tired man....
I'm working on from last 2 days and every time i'm getting the same error message, i appreciate any1 can help here.
I'm trying to connect to MDB and from query analyzer I want to run MDB tables.
1)
sp_addlinkedserver 'myserver', 'Access 97', 'Microsoft.Jet.OLEDB.4.0','C:Mag.mdb&# 39;
after i ran this it displays....
(1 row(s) affected)
(1 row(s) affected)
Server added.
2)
sp_addlinkedsrvlogin 'myserver', true, 'sa', 'dev','dev'
(0 row(s) affected)
(0 row(s) affected)
(1 row(s) affected)
3)
after that when i try to run the sql statement like
Select * from myserver..tablename
I GOT THIS ERROR MESSAGE:
Server: Msg 208, Level 16, State 1, Line 1
Invalid object name 'linkedserver..tablename'.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|