Wednesday, March 28, 2012

Link SQL Server To Intersystem's Cache Database

Using ODBC, I can link to a Cache database using MS Access. I have tried to do the same with SQL Server 2000, but all I can do is copy tables, which I don't want to do. Is there a way to link SQL Server to Cache? The DB is read-only.

Cache is the DB for an Eclipsys Patient Accounting System used at the hospital where I work.

There are two ways to do it:

1. use ODBC + OLE DB Provider for ODBC you can create a linked server from SQL 2k to Cache

2. or if Cache supports its own OLE DB Provider, then you can directly use the OLE DB Provider to create a linked server to Cache

HTH.

sql

No comments:

Post a Comment