[Bug 21365] New: Rounding error in database app?
wine-bugs at winehq.org
wine-bugs at winehq.org
Thu Jan 14 00:14:54 CST 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 at winehq.org
ReportedBy: dank at 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.
More information about the wine-bugs
mailing list