Hitting ODBC-system DSN from Stored Procedure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » Hitting ODBC-system DSN from Stored Procedure...

Hitting ODBC-system DSN from Stored Procedure

Rate Topic

Display Mode

Topic Options

Author

Message

edstalke

Posted Tuesday, May 13, 2008 8:52 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 6:42 AM
Points: 118, Visits: 504

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

GSquared

Posted Tuesday, May 13, 2008 3:11 PM

SSCoach

Group: General Forum Members
Last Login: 2 days ago @ 1:45 PM
Points: 15,442, Visits: 9,572

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 »

Permissions