473,418 Members | 2,174 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

home > topics > microsoft sql server > questions > access tables from different server

Join Bytes to post your question to a community of 473,418 software developers and data experts.

access tables from different server

137 100+
dear all,
i have two servers and my software is in one of those servers. both the servers have databases : db1 and db2.

i tried the following query :
Expand|Select|Wrap|Line Numbers
  1. select * from server2.db2.dbo.tblname
from server1. it shows the error

Msg 7202, Level 11, State 2, Line 1

Could not find server 'server2' in sysservers. Execute sp_addlinkedserver to add the server to sysservers.

what shall i do.i need both servers.

TIA
Jun 8 '10 #1
1 1385
ck9663
2,878 Expert 2GB
Have you link server2 yet? Here, read this

Happy Coding!!!

~~ CK
Jun 8 '10 #2

Sign in to post your reply or Sign up for a free account.

Similar topics

1
what level of server access is required in order to view tables with Server Explorer?
by: Bennett Haselton | last post by:
I want to get an ASP.Net hosting account with my ISP, and I'm trying to find out what level of access to the server is requried in order for me to view the server in Server Explorer in Visual...
.NET Framework
10
Linking access tables?
by: Job Lot | last post by:
Is there any way to programmatically link access tables using vb.net
.NET Framework
4
Using Access with SQL Server
by: meyvn77 | last post by:
Background: I'm new at SQL Server (no experience, zip, nada) but getting pretty good with developing applications in Access(VBA) and in VB using ADO.... Currently I use access to and GIS...
Microsoft SQL Server
1
access tables and web forms in asp
by: sparks | last post by:
Using web forms for data entry / querying and storing the data in MS-Access tables. Presumably anything that works for this would not be limited to MS-Access, but other DBMS’s as well. am I...
Microsoft Access / VBA
15
tranferring data from Access to SQL Server Express
by: Marcus | last post by:
I created a VB.Net 1.1 application that iterates through all the tables in any basic Access 2000 database passed to it and generates the same table structure in a SQL Server Express database. The...
Visual Basic .NET
5
General advice needed regarding MS Access, MS SQL Server, MySQL/PostgreSQL
by: Ted | last post by:
I am working on two versions of an application, one of which will be a windows forms application (which will need to be redistributable) and the other will be a web application. I have MS Visual...
Microsoft SQL Server
15
Using DTS to migrate Access ot SQL Server
by: Wes Groleau | last post by:
When I try to import from Access, the DTS wizard only allows me to import tables and queries. OK, I'm not surprised the "macros" and reports don't come over. But it executes each query, and...
Microsoft SQL Server
1
Access Tables to Excel Worksheet Export
by: smaczylo | last post by:
Hello, I've recently been asked to work with Microsoft Access, and while I feel quite comfortable with Excel, I'm at a complete loss with databases. If someone could help me with this issue I'm...
Microsoft Access / VBA
2
about importing access tables..
by: drek01 | last post by:
hi i am trying to import access tables into my backend database( current database) which is sql server. i created file browser which browse access database from harddrive and places all the tables...
Microsoft Access / VBA
5
Tool to compare two databases (one Access, one SQL Server)
by: teddysnips | last post by:
I have upsized a client's application from Access BE/FE to Access FE/ SQL Server. All is fine with initial testing, and they want to run the systems in parallel prior to going live. The MD, who...
Microsoft Access / VBA
0
Migrating Website to Cloud - Emmanuel Katto
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
General
0
BarryA
Navigating the Data Structures and Algorithms (DSA)
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
Algorithms / Advanced Math
0
Changing the language in Windows 10
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
Windows Server
0
Oralloy
Problem With Comparison Operator <=> in G++
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
C / C++
0
jinu1996
Maximizing Business Potential: The Nexus of Website Design and Digital Marketing
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
Online Marketing
0
The easy way to turn off automatic updates for Windows 10/11
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
Windows Server
0
agi2029
AI Job Threat for Devs
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
Career Advice
0
isladogs
Access Europe - Using VBA to create a class based on a table - Wed 1 May
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
Microsoft Access / VBA
0
Couldn’t get equations in html when convert word .docx file to html file in C#.
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
C# / C Sharp

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.

BYTES.COM © 2024
About Bytes
Terms Of Use
Privacy Policy
Sitemap
Advertise on Bytes:
Post a Job
Sponsored Posts
Platinum & Gold Sponsors
Hire Now!