Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    Egypt
    Posts
    61

    Unanswered: How to get data from MS SQL Server from linux machine?

    hi all,

    i need to collect data from 60 SQL server into one big DB2 server using mulit threaded C program under linux, just wonder if anyone have tried to make a program under linux to get data from MS SQL Server under windows.

    i need to code in C under linux, connect to SQL server and DB2 server (which i know how to do it)


    what i understand so far we need on clinet side (linux machine)

    1. ODBC software ( there is open source unixODBC)

    2. MS SQL Deiver under linux (i checked open link)

    does anyone has experince in such stuff ?

    i need a start point

    any suggestions ?
    hany heggy,
    IBM certified Professional, AIX system support
    www.melodyhits.tv

  2. #2
    Join Date
    Jan 2004
    Location
    Egypt
    Posts
    61
    hi all,

    i spend two days working on that, so i decided to inform you that it finally work !

    if anyone want to Copy/Move Data from SQL Server under Windows to DB2 Server under UNIX/Linux, u can do that follwoing:

    1. dowload tryial version of openlink software and install it(www.openlinksw.com)

    2. download GNU SDK for opensoft ODBC driver ( it contains Sample C code to use ODBC DSN)

    3. start work with the C function to get data from the DAMN SQL Server


    BTW,

    This ODBC software works for different UNIX (AIX,SUN....) and linux too (just choose the envirnoment before u download)

    enjoy yr time
    Last edited by hanyheggy; 03-12-04 at 22:09.
    hany heggy,
    IBM certified Professional, AIX system support
    www.melodyhits.tv

Posting Permissions

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