SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2005 Forums
 Express Edition and Compact Edition (2005)
 Fractional truncation Error
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

dchst
Starting Member

South Africa
12 Posts

Posted - 12/04/2012 :  11:17:44  Show Profile  Reply with Quote
Hi All,

I have a strange problem. A client is getting a fractional truncation error whenever they insert a record. This is on an XP machine with SQL Express 2005 and VB6 application. The client machines also have this problem.

I have taken a copy of the database but I am unable to replicate the error on my machines. The software has been running for years on many machines without issues and few changes to the VB code. Their IT department visited today and changed machine names and probably some other settings.

I do not believe the fractional truncation error can be code related and is more likely to be related to something done by the IT people. I am under pressure to resolve the issue, but am not sure where to look. Any input will be sincerely appreciated!

Edited by - dchst on 12/04/2012 11:35:16

sunitabeck
Flowing Fount of Yak Knowledge

5155 Posts

Posted - 12/04/2012 :  11:43:43  Show Profile  Reply with Quote
Start -> Settings -> Control Panel -> Regional and Language Options -> Regional Options tab -> Customize and look up the value under "No. of digits after decimal" on a box that works correctly and compare it with what it is on a box that does not work correctly.

If that does not offer any clue, I want to say run profiler and look at the queries that are coming into the server, but I don't think profiler is part of SQL 2005 Express. If you have a version that has profiler, you may want to use that to connect to the express instance and profile it. If you are ableto run the profiler and capture a query that inserts the data that lets you narrow it down to either the client side or the database side.

I can't see how it can be on the database side unless the schema or data type of the columns or the stored procedure has changed. So then assuming it is on the client side, you will need to investigate the VB code - I am not much of a VB person, so I don't know what to suggest in that regard.
Go to Top of Page

dchst
Starting Member

South Africa
12 Posts

Posted - 12/04/2012 :  13:13:40  Show Profile  Reply with Quote
quote:
Originally posted by sunitabeck

Start -> Settings -> Control Panel -> Regional and Language Options -> Regional Options tab -> Customize and look up the value under "No. of digits after decimal" on a box that works correctly and compare it with what it is on a box that does not work correctly.

If that does not offer any clue, I want to say run profiler and look at the queries that are coming into the server, but I don't think profiler is part of SQL 2005 Express. If you have a version that has profiler, you may want to use that to connect to the express instance and profile it. If you are ableto run the profiler and capture a query that inserts the data that lets you narrow it down to either the client side or the database side.

I can't see how it can be on the database side unless the schema or data type of the columns or the stored procedure has changed. So then assuming it is on the client side, you will need to investigate the VB code - I am not much of a VB person, so I don't know what to suggest in that regard.



Thanks for this. I re-installed (uninstall and install) SQL Express 2005 SP4 and it works! I forgot to make a note of which SP was on the machine. I can only think that whatever IT did, it involved overwriting or disabling something between VB6 and SQL, presumably something to do with ODBC drivers.

David
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000