New subject: [Bug 21365] Rounding error in database app?

14 Jan 2010


      http://bugs.winehq.org/show_bug.cgi?id=21365
Summary: Rounding error in database app?
           Product: Wine
           Version: 1.1.36
          Platform: x86
        OS/Version: Linux
            Status: UNCONFIRMED
          Severity: normal
          Priority: P2
         Component: -unknown
        AssignedTo: wine-bugs@winehq.org
        ReportedBy: dank@kegel.com
http://forum.winehq.org/viewtopic.php?t=7333
describes a rounding error:
I've got a "straightforward" database querying problem with a Visual Basic 6
application that happens on Debian (+WINE), but not on Windows XP.
SETUP: 
* COMPUTER "FREE" with: 
--- DEBIAN Lenny (Lang: Spanish) 
--- unixODBC + FreeTDS for ODBC conectivity to remote MSSQL2000 (tested,
working) 
--- WINE 1.1.33 
--- MDAC 2.8 (for channelling the ODBC connection through to unixODBC)
* COMPUTER "M$" with: 
--- Windows XP (Lang: Spanish) 
--- MSSQL Server 2000 
--- MDAC 2.8
PROBLEM: 
I create an ODBC connection to MSSQL2000 on VB6, and query a field (Numeric
9,2) into an ADODB.Recordset. 
On Windows, the program returns the complete field numeric value (2.44), but on
Debian it rounds the number (2.00).
On Debian, channelling the Query through isql properly returns 2.44, so it's
most likely a WINE or VB6+WINE issue.
LITTLE VB6 TEST PROGRAM CODE (returns 2.44 on Windows XP, but 2.00 on Debian): 
Code:
Private oConn As ADODB.Connection
Private Sub Command1_Click() 
    Dim oRS As ADODB.Recordset
Set oConn = New ADODB.Connection 
    oConn.Open "DSN=myODBCDSN; UID=username; PWD=password;"
Set oRS = New ADODB.Recordset
oRS.Open "SELECT Price FROM GOODS WHERE idGoods = 10", oConn, adOpenDynamic 
    MsgBox oRS("Price")
oConn.Close 
    Set oRS = Nothing 
    Set oConn = Nothing 
End Sub
The line oRS("Price") is where the problem is.
...
I noticed oleaut32.dll is distributed with VB6 Runtime Libraries, which I had
previously installed. I reinstalled them via Winetricks both set as Builtin and
native and there was no change unfortunately.
I also fiddled with all Library Native/Builtin settings to see if anything
changed, but the problem remains.
...
In WINE 1.1.35, native OLE DB support was added. Since I could not find a
solution using ODBC, I switched to a OLE DB DSN-Less connection taking
advantage of this brand new feature and tried again. It worked!
I could not find why ODBC gave me this problem, and now I can remain happily
ignorant [hopefully].
-- 
Configure bugmail: http://bugs.winehq.org/userprefs.cgi?tab=email
Do not reply to this email, post in Bugzilla using the
above URL to reply.
------- You are receiving this mail because: -------
You are watching all bug changes.

[Bug 21365] New: Rounding error in database app?