WINE + MSSQL 2000 + VB6 -> Numbers are rounded in records

[Razorwings18]

Hi all,

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: Select all

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.

Any pointers will be most welcome.

[vitamin]

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).

Try native oleaut32.dll.

[Razorwings18]

Thank you for your reply. Actually, odbccp32 and oleaut32 are set to "native, builtin". odbc32 is set to "builtin", since otherwise it won't map the ODBC connection to unixODBC (which sounds logical IMHO).

Sorry for skipping this info in my original post.

[savelov]

Razorwings18,

I think you need to download native oleaut32.dll (or copy from windows xp) and install it manually, as MDAC28 does not contain this dll. (I did not observe any changes to this dll after installation of mdac28 on my wine )

[Razorwings18]

Razorwings18,

I think you need to download native oleaut32.dll (or copy from windows xp) and install it manually, as MDAC28 does not contain this dll. (I did not observe any changes to this dll after installation of mdac28 on my wine )

Ah, you do have a point there. I checked the MDAC28 manifest (http://support.microsoft.com/?kbid=828396) and indeed MDAC28 does not include oleaut32.dll .

Thanks! I'll get the native dll and see if it works.

[Razorwings18]

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.

[Razorwings18]

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].

Thank you all for your suggestions.

[Razorwings18]

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].

Thank you all for your suggestions.