Hi

We have a UNIX server running a factory management system (CS3) which links
to PCs through an ODBC program (Easysoft). We want to install an MSDE
database server so that we can create our own database tables in conjunction
with the UNIX server.

1. Can we use the Easysoft ODBC program to link the MSDE server to the UNIX
server, and if so, how?

2. Can me make it so that any linked tables on the MSDE server that reside
on the UNIX server can be seen by PC users running an Access front end
linking to the MSDE server? (ie, a 3rd party view, without linking the PC to
the UNIX server).

Regards

Tom

Hi AAVFIT,

Haven't tried this combination but can't see why you shouldn't be able to,
in concept. As long as you can configure the OLE DB Provider for ODBC to see
the Easysoft ODBC source, you should be able to use sp_addlinkedserver to
add it. My guess is you'd have to have it set up as a System Data Source (ie
not a user one) to get this to work as otherwise the MSDE service wouldn't
be able to see it.

So I think the steps would be:

1. Set up a System Data Source (using the Easysoft ODBC program). (Make sure
it works, using Excel or similar)
2. Use sp_addlinkedserver to add a linked server using the OLEDB provider
for ODBC and point it to the System Data Source.

Good luck !!!

HTH,

--
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com

[quoted text, click to view]