Professional Web Applications Themes

odbc driver - IBM DB2

I have been trying to transfer some data from db2 to SQL Server and have come up with a couple of issues. If I use the IBM ODBC or OLEDB drivers for db2 they transfer data without errors but convert all numeric fields to 0. I've tried pumping into different data types on SQL Server (decimal, numeric, etc.) but always get 0 values. The MS Oledb driver seems to work moving all data with correct values succesfully but seems rather slow. I tmight be that it is slower because it moves actual numbers not all 0s, so I'd like to ...

  1. #1

    Default odbc driver

    I have been trying to transfer some data from db2 to SQL Server and
    have come up with a couple of issues. If I use the IBM ODBC or OLEDB
    drivers for db2 they transfer data without errors but convert all
    numeric fields to 0. I've tried pumping into different data types on
    SQL Server (decimal, numeric, etc.) but always get 0 values. The MS
    Oledb driver seems to work moving all data with correct values
    succesfully but seems rather slow. I tmight be that it is slower
    because it moves actual numbers not all 0s, so I'd like to compare it
    to the IBM drivers if there's a way to get them to actually work.

    The zero problem occurs both through DTS data pumps and simple queries
    made through query yzer to a linked db2 server. I know theres also
    third party drivers but would like to test these two out first, unless
    enough people tell me it's a no-brainer to use ACME db2 drivers...
    Thanks for any help.
    JA Guest

  2. #2

    Default Re: odbc driver

    Using the IBM ODBC driver should work. Use the MS OLEDB over ODBC driver to
    access DB2, and the MS OLEDB driver for SQL Server to access MS SQL. You
    should then have no problems unless you're using decimal data that SQL
    Server doesn't support: DB2 has proper BCD, SQL Server doesn't.

    "JA" <com> wrote in message
    news:google.com... 


    Mark Guest

  3. #3

    Default Re: odbc driver

    StarQuest has a DB2 to SQL Server tion software which includes
    their DB2 driver (StarSQL) :
    http://www.starquest.com/Productfolder/infosqdr.html

    I believe it used to be sold by Microsoft and was designed
    specifically for SQL Server.

    Bob

    com (JA) wrote in message news:<google.com>... 
    DB2 Guest

Similar Threads

  1. Replies: 1
    Last Post: October 21st, 06:44 PM
  2. TPS - Topspeed's ODBC Driver
    By mark.richardson in forum Coldfusion Database Access
    Replies: 0
    Last Post: May 20th, 08:33 AM
  3. Replies: 4
    Last Post: July 2nd, 01:11 PM
  4. Replies: 1
    Last Post: December 13th, 02:59 AM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139