I'm trying to access old visual foxpro data remotely, but via a linked server inside SQL server. I have that all set up, but I don't know how to retrieve the info from another computer via ODBC.
I can see all the tables: http://puu.sh/e9WYN/b0e346d792.png
I can query data: http://puu.sh/e9X8D/e2a6010ed3.png
But when I connect to the SQL Server via ODBC (SQL Server Driver) I only see the default tables: http://puu.sh/e9XqV/fdcf963cd3.png
What am I missing? I can provide more details if needed.
Go to the complete details ...