How were you able to connect your intersystems Cache database to sql server.

Can you provide an example of your linked server connection string? Are you on a 64bit server....