Long number not displayed with adodb

Hi there

We use ms access as a front end to mysql. On one computer (with windows XP 5.1.2600 Service Pack 2 Build 2600...) the long number (int(10)- autoincrement in mysql) are displayed as garbage characters when the data come from the following piece of code:

Dim Cn As New ADODB.Connection, rec As New ADODB.Recordset
Dim sSearch As String, w As Variant, sql As String, strConnection As String

 strConnection = "Provider=MSDataShape;Persist Security Info=False;User ID=dokpe_i01_usr;Data Source=mysql_dokpe_i01_usr"
 Cn.Open strConnection
 sql = "select concat(nofm, '') as nofm, ti, tri, issn, ex, ad, concat(noed,'') as noed, dom from jrn where match(ti) against(" & Chr(39) & _  
 sSearch & Chr(39) & " in boolean mode)"
rec.CursorLocation = adUseClient
rec.Open sql, Cn, adOpenKeyset, adLockOptimistic
Set Me.Recordset = rec
Me.UniqueTable = "jrn"
...

When the form is linked to a linked table or a query via jet, there no problem, long number are correct.

On every computer except one which has been reinstalled, the long number are ok. I have tried to reinstall odbc 3.51 but the problem persists. 

Thanks for any help

François Rappaz

Centre de documentation de la Faculté des Sciences 
Université de Fribourg
DokPe - Dokumentationszentrum der Naturwissenschaftlichen Fakultät Universität 
Freiburg 
Pérolles CH-1700 Fribourg Switzerland
http://www.unifr.ch/dokpe/
Tel.: 41 (0)26 300 92 60 
Fax.: 41 (0)26 300 97 30

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/[email protected]