Linked Server to Data on Netware 5.1

Posted on 2003-03-17
Medium Priority
Last Modified: 2012-06-27

I have an old fox pro free table directory database which is stored on one of our novell netware 5.1 servers. This database cannot be moved and must remain on the server, I need to connect to this data from an adp project connected to an instance of SQL Server 2000. I have installed the ODBC Microsoft visual foxpro driver successfully on the sql server. I copied the free table directory to the local disk on the sql server, created an odbc connection pointing to this data and then could successfully set up a linked server to this odbc connection and connect. If i change this odbc connection or create a new one pointing to the data on the novell server I cannot connect the linked server.

I sometimes get an error message of some sort but normally just don’t get any tables returned, next time i get an error message i will post it.

I believe the problem is that sql server is not authenticating successfully on the novell server, I have tried changing the logon of the sql server and sql server agent services on the sql server machine to no avail.

I'm really stumped on this one i have asked friends and have I’ve searched the internet and found very little other than an article saying that authentication could be a problem and to check the login settings for sql servers services which I’ve done. If I had 1000 points to give I would on this as it has me completely stumped, whoever finds a way round this will be a total SQL server hero.

I’ll be very grateful for any help or information relating to my problem

Thanks in advance (creep creep)
Question by:dfarthing
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2

Accepted Solution

mrGreen earned 620 total points
ID: 8339905
why not take a quick latte break, possibly have a jaz fag
then ditch the Fox pro Database, tell them somebody stole it?

Author Comment

ID: 8339932
mrgreen thanks, i tried what you suggested and it worked fine and left me feeling quite relaxed about the whole thing t'boot. I changed my mind about IT and now work nights in a maccy d's drive though.

do you fries with that?

Expert Comment

ID: 8339957
do I get the points then?

Featured Post

Moving data to the cloud? Find out if you’re ready

Before moving to the cloud, it is important to carefully define your db needs, plan for the migration & understand prod. environment. This wp explains how to define what you need from a cloud provider, plan for the migration & what putting a cloud solution into practice entails.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Suggested Courses

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question