Groups > comp.databases.ms-sqlserver > #591

Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!weretis.net!feeder4.news.weretis.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From	"Bob Barrows" <reb01501@NOyahooSPAM.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005
Date	Fri, 12 Aug 2011 14:56:50 -0400
Organization	A noiseless patient Spider
Lines	31
Message-ID	<j23t1o$cls$1@dont-email.me> (permalink)
References	<bc35893b-4e20-4fe7-81b3-1472057cfb8d@u12g2000prc.googlegroups.com>
Injection-Date	Fri, 12 Aug 2011 18:56:57 +0000 (UTC)
Injection-Info	mx04.eternal-september.org; posting-host="NUmboHSNYG4cX5Ys9j8TNw"; logging-data="12988"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1853VeoPZt3BMzDvWYapTTM/sG9IjBZCqY="
X-MimeOLE	Produced By Microsoft MimeOLE V6.00.2800.2001
X-Antivirus-Status	Clean
X-Newsreader	Microsoft Outlook Express 6.00.2800.2001
X-Antivirus	avast! (VPS 110812-0, 08/12/2011), Outbound message
Cancel-Lock	sha1:pxc/kXWxlaProrBZufuV5pFg3DE=
X-Priority	3
X-MSMail-Priority	Normal
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:591

Show key headers only | View raw

xo wrote:
> Hello -
>
> I have a strange problem when casting value under 64-bit sql server
> 2005 vs under 32-bit sql server 2005.
>
> I got two servers.  One has 32-bit SQL server 2005 standard edition
> (version 9.00.3073.00) on Windows NT 5.2 (3790) with NT INTEL x86.
> The second server has 64-bit SQL server Enterprise edition (version
> 9.00.4035.00) on Windows NT 5.2 (3790) with NT AMD64.
>
> The problem came when I tried to cast value under 32-bit SQL server
> 2005, the result gets queried out.  But when the same sql got run,  it
> prompted conversion error - "Error converting data type varchar to
> numeric." under the 64-bit server.
>
> I tried cleaned up the data and it still gives the same error.
>
Please show us how to reproduce this symptom. You need to provide a script
that we can run on our servers to see the error you are getting. If the
problem occurs when using variables, that would enable you to easily create
a repro script:

declare @v1 <somedatatype>, @v2 <someotherdatatype>;
set @v1=<somevalue>;
set @v2=cast(@v1 as <someotherdatatype>);

Replace the <...>s with the actual data types and values required to
reproduce your symptom and post it here.

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 xo <xo5555ox@gmail.com> - 2011-08-12 10:33 -0700
  Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 "Bob Barrows" <reb01501@NOyahooSPAM.com> - 2011-08-12 14:56 -0400
    Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 xo <xo5555ox@gmail.com> - 2011-08-12 13:05 -0700
      Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 "Bob Barrows" <reb01501@NOSPAMyahoo.com> - 2011-08-12 16:56 -0400
  Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 Erland Sommarskog <esquel@sommarskog.se> - 2011-08-12 22:06 +0200
    Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 xo <xo5555ox@gmail.com> - 2011-08-12 13:17 -0700
      Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 Erland Sommarskog <esquel@sommarskog.se> - 2011-08-12 22:25 +0200
        Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 xo <xo5555ox@gmail.com> - 2011-08-12 14:31 -0700
          Re: Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005 Erland Sommarskog <esquel@sommarskog.se> - 2011-08-13 12:59 +0200

csiph-web