How to run a query to ODBC connection and store results in SQL server 2005

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sqlDummy

    How to run a query to ODBC connection and store results in SQL server 2005

    I am a complete SQL noob, but have been left with a terrible task of rebuilding a report server where the previous admin was fired and left nothing for us.

    I have an ODBC connection that will accept sql queries, and the previous admin had sql server 2005 running and left us the ODBC System DSn in tact.

    what I want to do is run my query from the ODBC connection and store in server 2005. but again I have no clue...so any (relativly quick) direction would be greatly appreciated.
  • ck9663
    Recognized Expert Specialist
    • Jun 2007
    • 2878

    #2
    A little more details, pls...

    You want to run your query from where? Why do you need ODBC to connect?

    ~~ CK

    Comment

    Working...