Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

linked Server

Status
Not open for further replies.
123alpha

123alpha

Programmer
Nov 25, 2004
4
BE
Hi,

I have a question related to linking of the tables in SQL server database from the other database.

I have tried to do so using Linked Server from MS ACCESS and it is successfully linked but I cannot see all of its rows as I do not have option to return all rows.

But when I am trying to use Linked Server for SQL server database only it works but give me this error:-

OLEDB PROVIDER 'SQLOLEDB' reported and error.

And I have one more questions Like in MS ACCESS we can link some of the tables from different databases like Access or other databases using ODBC, is that kind of thing is possible in SQL SERVER.
If yes then how?

Thanks is advance,
 
Status
Not open for further replies.

Similar threads

petart
  • Locked
  • Question
Problem Date MS SQL Server
Replies
0
Views
165
petart
petart
botatun
  • Locked
  • Question
the linked server insert data to csv in wrong order
Replies
0
Views
155
botatun
botatun
okcorral
  • Locked
  • Question
insert in to DB2 Z/vse via SQL 2005 linked server
Replies
1
Views
177
okcorral
okcorral
smsmail
  • Locked
  • Question
How to import EXCEL data into existing table in SQL Server
Replies
5
Views
302
markjoseph1232
markjoseph1232
johnb1023
  • Locked
  • Question
Date conversions between Microsoft SQL Server and Viewing in MS Access
Replies
0
Views
242
johnb1023
johnb1023

Part and Inventory Search

Sponsor

Back
Top