>The servers are getting set up, but I am still having problems accessing them.
>When I try the OLEDB setup like this:
>SELECT * FROM test...temptbl
>I get this:
>OLE DB provider 'VFPOLEDB.1' reported an error. Access denied.
The account Sql Server runs under doesnt have access to the free tables directory.
>When I try the ODBC driver like this:
>SELECT * FROM test1...temptbl
>I get this:
>Invalid schema or catalog specified for provider 'MSDASQL'.
You have to use OPENQUERY().
SELECT * FROM
OPENQUERY(test1, 'Select * From mytable')
>
>What am I missing?
Make sure that account that Sql Server runs under has access to the free table directories. It's also beter to use UNC path because it doesn't requered mapping.
< snip >
--sb--