link server problem

[Sunny]

Here is our setup:

We have hundereds of servers/workstations on our network
MyComp is my workstation on network.
FoxData is the server where my FoxPro application and data stored.
SQLDev is the servername (computer name) where I have installed SQL server
2000 for development
SQLProd is the servername where I have installed SQL server 2000 and hosting
production databases.

I have created map on SQLDev box to FoxData as U: drive, and on SQL server I
created link server for foxpro dbc file located on U: (FoxData server) using
vfpoledb driver. It works fine SQLDev box and I can view all tables in dbc
file and I can also query.

Now I open enterprise manager on MyComp (my workstation) and can see the
linked server but when I try to see all tables, it gives me error: 7303
Could not initialize data source object of OLE DB provider 'VFPOLEDB'.

What am I doing wrong here? Can anyone please explain?

Thanks.

[Sunny]

Thank CJ, but it did not help. I have dowloded latest version of OLE DB and
alos as I said earlier it just works fine on SQL box but dows not work on my
work station.

"CJ" <C...@discussions.microsoft.com> wrote in message
news:0E8FFA99-2DA8-4804...@microsoft.com...
> try looking here:
> http://msdn.microsoft.com/en-us/library/aa226395(SQL.80).aspx
>
> and also check that you have the latest set of vfp ole db drivers
> http://www.microsoft.com/downloads/details.aspx?familyid=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en

[Sunny]

But it works fine on server box, so user rights should not be issue or am I
missing anything?

"CJ" <C...@discussions.microsoft.com> wrote in message

news:6E07C514-6CAB-4C57...@microsoft.com...
> only other thing i can think of is a user rights issue... and check all
> the
> security settings too..
>
> i can get a list of fox tables in the enterprise manager although its
> rather
> slow...
>
>