Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
coco ue
Starting Member
3 Posts |
 Posted - 2005-12-02 : 06:20:34
|
| Hi to all,can anyone tell who to configure a Linked Server in Sql Server 2000;Provider Name:?;Product Name ?;Data Sources ?;Provider String ?;Location ?;Catalog?.In this Condition : I have a FoxPro 2.61 for DOS named file1.dbf ,locate in \\nt_serv\Dir1\sa |
|
|
coco ue
Starting Member
3 Posts |
Posted - 2005-12-02 : 06:27:14
|
| I need something like a wizard to configure this Link.My sql server have IP:10.1.1.1and my nt_serv:10.1.1.3 |
 |
|
|
Sameer Raval
Starting Member
4 Posts |
Posted - 2005-12-02 : 16:46:24
|
| Here is the example how I connect Goldmine server as linked server in MyServer withname ServerGoldMine. In this case I am using sql server as linked server, but similarly you should be able to do with foxpro. In your case in General tab Server Type use other datasource and select appropriate data source. Go To Enterprise ManagerGeneral --> DataSource --> GOLDMINESRV [ name of server you wish to link]Security --> Linked Server --> 'ServerGoldMine' [give name to linked server] --> Right Click to Go to Propertie--> Security tab Choice Be Made using this Security Context Login : sameertest Pw : sameertest--> Server Option Tab Choose Data Access RPC RPC OUT ----- this selection is req. to run sp from remote server Use Remote CollationConnection Timeout 0 Query Timeout 0Note : Create Sql Server Account sameertest in GoldMine Give Server Role of Security Administrator[without this other query may work but Backup/Restore fails without this right]Give Owner Access to the Databases in Goldmine to be queriedSameer Raval |
|
|
|
coco ue
Starting Member
3 Posts |
Posted - 2005-12-05 : 01:54:06
|
| ok good; any ideea about to how to configure this :data source:?; provider string:?; location:?;catalog?;in General option tab? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2005-12-05 : 02:34:54
|
| try this :Provider name = Microsoft OLE DB Provider for Visual Fox Pro<Product name leave blank>Data source = \\nt_serv\Dir1\sa<Provider string leave blank><Location leave blank><Catalog leave blank>you can download the OLE DB Provider from [url]http://www.microsoft.com/downloads/details.aspx?FamilyId=0F43EB58-7A94-4AE1-A59E-965869CB3BC9&displaylang=en[/url]-----------------[KH] |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-12-05 : 03:02:31
|
| Will this help you?www.ConnectionStrings.comMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
how configure a Linked Server?