Unix Technical Forum

Help! Problem with linked server

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


Go Back   Unix Technical Forum > Database Server Software > Microsoft SQL Server > MS SQL ODBC

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-27-2008, 08:23 PM
Roman
 
Posts: n/a
Default Help! Problem with linked server

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!
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:27 AM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com