Results 1 to 2 of 2

Thread: Link Informix to SQL server

  1. #1
    Join Date
    Oct 2006
    Posts
    1

    Link Informix to SQL server

    Hi,

    I am considdering to link a Informix database (running on SCO Unix) to a SQL Server 2005. Only problem is ... I have no idea how to do this! The reason I'm attempring this is to try and see if it would fix a problem I'm experiencing when using Reporting Services to generate reports from a Informix data source. I've been told that setting up a linked server might fix the problem. If anyone could perhabs guide me through setting up the linked server I would be very grateful! The ODBC credentials for setting up a connection to the Informix DB as follows:

    Servername : pal_tli
    Hostname : server_name
    Service : pal_ser
    Protocal : sesoctcp
    Database : db_name
    Username : user_name
    Password : pword


  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    You need install Informix client on RS machine and create odbc dsn that points to Informix db. Use that dsn as data source to write report.

Posting Permissions

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