EOF via ADODB 2.8 avec Driver ODBC 5.1 et MySQL 5.05
Bonjour
J'utilise ADODB 2.8 pour gérer une base MySQL locale v5, via le dernier driver ODBC v5.1 pour MySQL.
Ma table contient des champs de type : int(11), text et datetime. Elle contient 197 enreg.
Je me cogne à une fin de fichier (table soit disant vide) quand j'essaye de lire celle-ci avec un "select * from table".
La requète "select count(*) from table" renvoie bien un enreg. avec la valeur 197.
Mon Recordset est toujours ouvert avec les options suivantes :
Recordset.Open SQL, Connexion, adOpenStatic, adLockReadOnly, adCmdText
Les propriétées ODBC lors des connexions sont celles-ci :
Code:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92
| Current Catalog jch
Reset Datasource
Active Sessions 0
Asynchable Commit Faux
Catalog Location 1
Catalog Term database
Catalog Usage 31
Column Definition 1
NULL Concatenation Behavior 0
Data Source Name MyODBC_JCH
Read-Only Data Source Faux
DBMS Name MySQL
DBMS Version 5.1.37-community-log
GROUP BY Support 3
Heterogeneous Table Support 0
Identifier Case Sensitivity 8
Maximum Index Size 3072
Maximum Row Size 0
Maximum Row Size Includes BLOB Vrai
Maximum Tables in SELECT 63
Multiple Storage Objects Faux
Multi-Table Update Faux
NULL Collation Order 4
OLE Object Support 1
ORDER BY Columns in Select List Faux
Prepare Abort Behavior 2
Prepare Commit Behavior 2
Procedure Term stored procedure
Provider Name MSDASQL.DLL
OLE DB Version 02.00
Provider Version 02.81.1132.0
Quoted Identifier Sensitivity 4
Schema Term
Schema Usage 0
SQL Support 259
Structured Storage 1
Subquery Support 31
Isolation Levels 1118464
Isolation Retention 0
Table Term table
User Name root
Pass By Ref Accessors Vrai
Transaction DDL 2
Asynchable Abort Faux
Data Source Object Threading Model 1
Output Parameter Availability 4
Persistent ID Type 4
Multiple Parameter Sets Vrai
Rowset Conversions on Command Vrai
Multiple Results 1
Provider Friendly Name Microsoft OLE DB Provider for ODBC Drivers
Connection Status 1
Server Name localhost via TCP/IP
Open Rowset Support 0
Accessible Procedures Faux
Accessible Tables Faux
Integrity Enhancement Facility Faux
Outer Join Capabilities 123
Stored Procedures Vrai
Driver Name myodbc5.dll
Driver Version 05.01.0006
Driver ODBC Version 03.51
Like Escape Clause Y
Special Characters !"#%&'()*+,-.:;<=>?@[\]^`{|}~
Max Columns in Group By 0
Max Columns in Index 32
Max Columns in Order By 0
Max Columns in Select 0
Max Columns in Table 0
Numeric Functions 16777215
SQL Grammar Support 1
Outer Joins Y
String Functions 14647295
System Functions 7
Time/Date Functions 2097151
File Usage 0
Active Statements 0
Password
Persist Security Info Vrai
User ID root
Data Source
Window Handle
Location
Mode
Prompt 4
Connect Timeout 15
Extended Properties DSN=MyODBC_JCH;UID=root;PWD=;
Locale Identifier 1036
Initial Catalog
OLE DB Services -7
General Timeout
Autocommit Isolation Levels 0 |
Merci