>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 >