This is a discussion on Help! Problem with linked server within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> I have SQL Server 2000 running on Windows 2000 machine which is configured to be a part of Novell ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| I have SQL Server 2000 running on Windows 2000 machine which is configured to be a part of Novell network (IPX). I need to add a linked server for .dbf files. So, I create a system DSN, pointing to local catalog with .dbf files, using dBASE driver. Then I create a linked server and set it's provider to OLEDB for ODBC and driver to my system DSN, I just made. Then I open tables node of my linked server and see there tables (actually .dbf files). The problem is- if I point my system DSN to a network catalog, not local, then I can also create linked server on that DSN and expand it's tables node with no error messages, but it's empty- I don't see any tables there! |