Re: Anyone using ODBC Driver for DB/2 (HIS) with SQL Server 7.0
This is a discussion on Re: Anyone using ODBC Driver for DB/2 (HIS) with SQL Server 7.0 within the MS SQL ODBC forums, part of the Microsoft SQL Server category; --> Katyan , If you want to keep using StarSQL, you can contact StarQuest directly to eliminate the license limit ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 08:14 PM
| ||||
| ||||
 Re: Anyone using ODBC Driver for DB/2 (HIS) with SQL Server 7.0 Katyan , If you want to keep using StarSQL, you can contact StarQuest directly to eliminate the license limit : www.starquest.com Bob "Katyan Raoch" <ts@maritime.co.tt> wrote in message news:<0da301c35128$16f82a10$a401280a@phx.gbl>... > Are there any known issues between SQL Server 7.0 and ODBC > for DB/2?. > > I am running SNA version 3.0 and currently testing HIS. I > am trying to import tables from a DB/2 Database on an > AS400. I have configure the Microsoft ODBC Driver for > DB/2 as my Data Source. > > On SNA 3.0 I used STARSQL (but this has license limits, > thus the change to HIS.) Anyway, when I try to import a > table using HIS, I receive the following error msg " Error > at Destination for Row number xxxx Arithmetic overflow > error converting numeric to data type numeric". The job > I'm creating creates the tables so table does not exist > outside of the import job. > > I can copy tables between servers without error but not > between the AS400 and the server. I cannot figure out > what could be wrong. Any help would be appreciated.      |
Linear Mode
