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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

using sp_addlinkedserver

Status
Not open for further replies.
oakpark5

oakpark5

Programmer
Sep 2, 2004
81
US
Alright, i've been trying to set up a new linked server, on SQL SERVER 2000. I want to update foxpro tables. Some are the same machine as the SQL server and the others are on another machine. I'm a little lost on what i need to enter for the variables for the sp_addlinkedserver. I know @server is the name, but what OLEDB should i use for FoxPro? What about variables for @datasrc, i'm assuming data source? I kept on getting an error when i tried to run it. Any help would be great. Thanks in advance!!!

Software Engineer
Team Lead
damn bill gates, he has everything
 
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
756
Mike Lewis
Mike Lewis
Auguy
  • Locked
  • Question
Using UDF In Select, Bad Idea? 2
Replies
3
Views
428
Auguy
Auguy
Niki_S
  • Locked
  • Question
Create view using two databases
Replies
4
Views
471
Chris Miller
Chris Miller
EM1107
  • Locked
  • Question
Copy folder and content using SQL Server TSQL.
Replies
6
Views
610
RobertPhillips
RobertPhillips
Cpreston
  • Locked
  • Question
Go back a Year using year and Month fields 3
2 3
Replies
40
Views
2K
JeffModen
JeffModen

Part and Inventory Search

Sponsor

Back
Top