Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2011
    Posts
    1

    Unanswered: MS SQL Queries on ODBC from Informix

    Hi,

    I have very little previous experience with SQL. Today my boss had me configure our Windows Server 2003 R2 with MS SQL 2008 for ODBC access to an Informix database on another server containing call center data. He'd like me to create queries that will run in MS SQL on the Informix data based on ASP and SQL queries that a previous employee wrote.

    Can anyone help me set up MS SQL to run queries on the ODBC data? Or possibly suggest a solution that makes more sense? Thank you for any input.

    David

  2. #2
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    I am thinking you want to either replicate the data to SQL Server (which would require a lot of work with SQL Server Integration Services (SSIS), or you can link directly to the data with a Linked Server. I would be a bit leery of what performance implications this is going to cause on the Informix side.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •