Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2005
    Posts
    14

    Unanswered: Accesing information from an Informix database

    Hi,

    I īd like to know if there is any way to access an Informix database from sqlserver 2005.

    We are trying to build a data warehouse in SS2005, and I want to know If I could avoid the generation of hundreds of flats files from Informix and loading them into SS2005, directly recovering all information from SS2005 across any kind of migration or connection.

    Any help would be very appreciated

    Regards.

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    We access an Informix database from SQLSVR 2000 via an ODBC connection using a driver named MERANT 3.50 32-BIT INFORMIX.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  3. #3
    Join Date
    Dec 2005
    Location
    Tilburg, Netherlands
    Posts
    73
    That's the way we do it as well. ODBC connection, linked server ... start moving the data !

    Gr,
    Yveau

    > SELECT * FROM users WHERE clue > 0;
    Empty set (0.00 sec)


Posting Permissions

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