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