Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Hitting ODBC-system DSN from Stored Procedure Expand / Collapse
Author
Message
Posted Tuesday, May 13, 2008 8:52 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 1:38 PM
Points: 118, Visits: 563

I have an transactional application that was built long before SQL server, the only way I know to retrieve data from this app is ODBC - System DNS. Currently, I can retrieve using SSIS and msQuery. I would like to skip SSIS and have everything inside Stored procedure. Can I retrieve data using ODBC-System DSN inside of Stored procedure?
Post #499691
Posted Tuesday, May 13, 2008 3:11 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 10:04 AM
Points: 15,442, Visits: 9,590
Yes. You can either set up a linked server, or use openrowset.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #500011
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse