"Chubbly Geezer" wrote:

> 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.
>
> Any ideas why I cannot connect in enterprise manager.?
>
> Thanks

"Chubbly Geezer" wrote:

> 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.
>
> Any ideas why I cannot connect in enterprise manager.?
>
> Thanks

"Mike Epprecht (SQL MVP)" wrote:

> Hi
>
> Does the account that SQL Server and Agent run under have permission on the
> remote share and files?
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
>
>
> "Chubbly Geezer" wrote:
>
> > 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.
> >
> > Any ideas why I cannot connect in enterprise manager.?
> >
> > Thanks

"Chubbly Geezer" wrote:

> Both services were running under local system.  Have changed to my login but
> still no joy.
>
> Also in linked server security options I have tried changing them to login
> as myself but no luck.
>
> The following 2 lines of code ALSO return table data:
> EXEC sp_tables_ex @table_server='OPERA_SERVER'
> EXEC sp_columns_ex @table_server='OPERA_SERVER', @table_name='ssale'
>
>
> "Mike Epprecht (SQL MVP)" wrote:
>
> > Hi
> >
> > Does the account that SQL Server and Agent run under have permission on the
> > remote share and files?
> >
> > Regards
> > --------------------------------
> > Mike Epprecht, Microsoft SQL Server MVP
> > Zurich, Switzerland
> >
> > MVP Program: http://www.microsoft.com/mvp
> >
> > Blog: http://www.msmvps.com/epprecht/
> >
> >
> >
> > "Chubbly Geezer" wrote:
> >
> > > 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.
> > >
> > > Any ideas why I cannot connect in enterprise manager.?
> > >
> > > Thanks