"Magni hansen" <mjh@farodane.fo> wrote in message
news:bbf801c3ec9e$7fb8a0e0$a501280a@phx.gbl...
> I am using DTS for import data from Navision to MS SQL DB,
> but i am getting this error when trying to import a BCD
> (15,5) into the MS SQL.
>
> Error msg: Insert error... ('Pr',DBTYPE_NUMERIC), status
> 12: Invalid status for bound data.
>
> If i change the decimal(15,5) to varchar(30), i only get "-
> " imported into 'Pr' column.

"Magni Hansen" <anonymous@discussions.microsoft.com> wrote in message
news:C9BA82FA-A628-4F2D-B5C8-176F0597107D@microsoft.com...
> The source value is Pr BCD(15,5) NOT NULL, viewing the value inside
Navision it looks like: 1.900,00
>
> The driver i am using is: C/ODBC 32 bit, 2.10.00.11
>
> I have downloaded version C/ODBC, 2.50 driver, but this was in conflict
with company server driver, so i am still using version 2.10.00.11
>
> Magni Hansen
>
> ----- Allan Mitchell wrote: -----
>
> what do the source values look like. This sounds like a driver issue
but I
> am interested to see the values
>
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.allisonmitchell.com - Expert SQL Server Consultancy.
> www.SQLDTS.com - The site for all your DTS needs.
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
>
> "Magni hansen" <mjh@farodane.fo> wrote in message
> news:bbf801c3ec9e$7fb8a0e0$a501280a@phx.gbl...
> > I am using DTS for import data from Navision to MS SQL DB,
> > but i am getting this error when trying to import a BCD
> > (15,5) into the MS SQL.
> >> Error msg: Insert error... ('Pr',DBTYPE_NUMERIC), status
> > 12: Invalid status for bound data.
> >> If i change the decimal(15,5) to varchar(30), i only get "-
> > " imported into 'Pr' column.
>
>
>

"Magni Hansen" <anonymous@discussions.microsoft.com> wrote in message
news:FE1B7591-A434-4A1C-8BD0-CE7A5A6737C7@microsoft.com...
> If i change the destination column to varchar, then it only imports a "-"
why is that so ?..
>
> I have hardcoded a ASP script, which takes out the 'Pr' column value from

>
> Have you any idea what is the best solution ?
>
> Magni Hansen
>
> ----- Allan Mitchell wrote: -----
>
> this value 1.900,00 will not go into a decimal in SQL Server.
>
>
>
> --
>
> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> www.allisonmitchell.com - Expert SQL Server Consultancy.
> www.SQLDTS.com - The site for all your DTS needs.
> I support PASS - the definitive, global community
> for SQL Server professionals - http://www.sqlpass.org
>
>
> "Magni Hansen" <anonymous@discussions.microsoft.com> wrote in message
> news:C9BA82FA-A628-4F2D-B5C8-176F0597107D@microsoft.com...
> > The source value is Pr BCD(15,5) NOT NULL, viewing the value inside
> Navision it looks like: 1.900,00
> >> The driver i am using is: C/ODBC 32 bit, 2.10.00.11
> >> I have downloaded version C/ODBC, 2.50 driver, but this was in
conflict
> with company server driver, so i am still using version 2.10.00.11
> >> Magni Hansen
> >> ----- Allan Mitchell wrote: -----
> >> what do the source values look like. This sounds like a
driver issue
> but I
> > am interested to see the values
> >> --
> >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
> > www.allisonmitchell.com - Expert SQL Server Consultancy.
> > www.SQLDTS.com - The site for all your DTS needs.
> > I support PASS - the definitive, global community
> > for SQL Server professionals - http://www.sqlpass.org
> >>> "Magni hansen" <mjh@farodane.fo> wrote in message
> > news:bbf801c3ec9e$7fb8a0e0$a501280a@phx.gbl...
> >> I am using DTS for import data from Navision to MS SQL DB,
> >> but i am getting this error when trying to import a BCD
> >> (15,5) into the MS SQL.
> >>> Error msg: Insert error... ('Pr',DBTYPE_NUMERIC), status
> >> 12: Invalid status for bound data.
> >>> If i change the decimal(15,5) to varchar(30), i only get "-
> >> " imported into 'Pr' column.
> >>>