Linked Server Connection Problem

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Linked Server Connection Problem

Author

Topic

Chubbly Geezer
Starting Member

8 Posts

Posted - 2005-08-02 : 06:25:32

Hi

I have some code that I am testing to read data from a FoxPro file.
I have copied the FoxPro file locally to test.
I have created a linked server that points to this file. Enterprise manager
correctly shows the tables available.
Works fine.!

However, when I create another linked server pointing towards the network
files, enterprise manager shows no available tables and my code returns an
error stating that the table does not exist.

I have checked the security permissions on the network drive/directories and
I appear to have full access. I can indeed move, delete etc these files.

I can successfully set up a linked server to an Excel file which resides in the same directory as the problem FoxPro files.

I have the most up to date VFPOLEDB.DLL file.

Any ideas please .?

Thanks

KLang23
Posting Yak Master

115 Posts

Posted - 2005-08-02 : 12:56:04

Hi,

Make sure that the account the SQL serice(s) are using have privileges to the data.

Chubbly Geezer
Starting Member

8 Posts

Posted - 2005-08-02 : 13:02:25

It does..

Kristen
Test

22859 Posts

Posted - 2005-08-02 : 14:02:46

Can you post the relevant bits of (leaving out any passwords etc.):

EXEC master.dbo.sp_linkedservers

just in case we can spot something that is goofy

Kristen

Chubbly Geezer
Starting Member

8 Posts

Posted - 2005-08-03 : 05:22:34

Have set the server up manually with the following settings:

Linked Server: OPERA_N
Provider name: VFPOLEDB (Microsoft OLE DB Provider For Visual FoxPro)
Data Source: \\acc_server2\accounts\operaii\data\comp_n.dbc

Security: 'Be made without using a security context' is checked

Server Options: 'Data Access' is checked, 'Use Remote Collaction' is checked

This I think equates to:
EXEC sp_addlinkedserver @server='OPERA_N', @srvproduct='', @provider='VFPOLEDB', @datasrc='e:\operaii\data\Comp_N.dbc'

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources