Connect to ODBC Datasource in Query Analyzer

Question

Viewing 4 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Sergiy SSC Guru Points: 110209 More actions · Answer 1

Did you try OPENQUERY, OPENROWSET?

_____________
Code for TallyGenerator

JuanBob SSCertifiable Points: 5059 More actions · Answer 2

Thank you Sergiy. I came to post my resolution as using OPENQUERY and saw your post. Thanks a lot!

JuanBob SSCertifiable Points: 5059 More actions · Answer 3

Now for the second part of my challenge. How should I be able to INSERT into a table associated with the Linked Server?

Again, I can get this to work in DTS, but I need to be able to do this within a Stored Procedure.

Thanks!!

JuanBob SSCertifiable Points: 5059 More actions · Answer 4

I believe I have this figured out. I had to find the right combination to access the schema on the source.