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 =3D "Provider=3DMSDataShape;Persist Security =
Info=3DFalse;User ID=3Ddokpe_i01_usr;Data Source=3Dmysql_dokpe_i01_usr"
Cn.Open strConnection
sql =3D "select concat(nofm, '') as nofm, ti, tri, issn, ex, ad, =
concat(noed,'') as noed, dom from jrn where match(ti) against(" & =
Chr(39) & _ =20
sSearch & Chr(39) & " in boolean mode)"
rec.CursorLocation =3D adUseClient
rec.Open sql, Cn, adOpenKeyset, adLockOptimistic
Set Me.Recordset =3D rec
Me.UniqueTable =3D "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.=20

Thanks for any help

Fran=E7ois Rappaz

Centre de documentation de la Facult=E9 des Sciences=20
Universit=E9 de Fribourg
DokPe - Dokumentationszentrum der Naturwissenschaftlichen Fakultät =
Universität=20
Freiburg=20
P=E9rolles CH-1700 Fribourg Switzerland
http://www.unifr.ch/dokpe/
Tel.: 41 (0)26 300 92 60=20
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/myodbc?unsub=3Dgcdmo-myodbc@m.gmane.o rg