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

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

From	xo <xo5555ox@gmail.com>
Newsgroups	comp.databases.ms-sqlserver
Subject	Problem with casting value under 64-bit sql server 2005 vs under 32-bit sql server 2005
Date	2011-08-12 10:33 -0700
Organization	http://groups.google.com
Message-ID	<bc35893b-4e20-4fe7-81b3-1472057cfb8d@u12g2000prc.googlegroups.com> (permalink)

Show all headers | View raw

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 help.
Thanks in advance.

Back to comp.databases.ms-sqlserver | Previous | Next — 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