March 8, 2006 at 12:36 pm
we currenlty have a core system that lives on openvms, we have a dharma gateway that we use to get data via dts from this system into sql server.
i need to set up the dharma gateway or this openvms as a linked server so that instead of dts packages running we can just connect to this odbc(dharma gateway) and query it.
has anyone worked with this odbc driver(dharma)? we no longer have the support for it, as the company that owns the core system, no longer has contact with the vendor that designed this dharma gateway. HELP
[font="Comic Sans MS"][/font]It is what it is.
March 9, 2006 at 7:01 am
I don't know anything about dharma interfaces, but I have had to pull data from an RMS datasource on a VMS box before. The product I used was from Connx Solutions http://www.connx.com/. If I remmeber correctly it was fairly inexspensive and privided a robust ODBC connectin to our data source.
I remmember having some difficulties setting up Linked servers with it as well, and basically I wasn't sending the correct connection string. Once I got that straightened out everything was fine.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply