Post reply

Connect to ODBC Datasource in Query Analyzer

  • April 28, 2008 at 4:46 pm

    #72019

    I need to query an ODBC datasource that is accessible via TSQL. It is not SQL Server however.

    I have this setup as a Linked Server in SQL, and can use it within DTS and other 'All Task' wizards. I just need to use this within Query Analyzer. Unfortunately, it does not seem to accept the connection.

    In general, whether I have something setup as Linked Server or not, is there a way to connect to an ODBC source from within QA?

    Thanks in advance!!

  • April 28, 2008 at 7:04 pm

    #808096

    Did you try OPENQUERY, OPENROWSET?

    _____________
    Code for TallyGenerator

  • April 29, 2008 at 9:15 am

    #808460

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

  • April 29, 2008 at 10:26 am

    #808535

    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!!

  • April 29, 2008 at 12:41 pm

    #808615

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

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

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