The installation completed successfully, but the Connector/ODBC driver does not appear in I get error 10061 (Cannot connect to server) This error can be raised by a number of different issues, including server problems, network problems, and firewall and port blocking problems.
For more information, see Can't connect to [local] My SQL server.
On Windows, make sure that you have the latest versions of the Microsoft Data Access Components (MDAC) installed.
I have installed Connector/ODBC on Windows XP x64 Edition or Windows Server 2003 R2 x64.
The resolution is to re-record the entire sequence, or modify the VBA code itself.
However the read from xml function takes on file name.Update to the latest version of the Connector/ODBC driver to resolve this problem.Description: A float column with a long decimal digit value that where inserted from My SQL Query Browser or My SQL Command Line, cannot be updated/modified using VB6 and ADO 2.7/2.8. Some values may have been changed since it was last read. I appreciate any help with this, And please forgive my English I'm from Spain How to repeat: I have the next code Set con = New ADODB. Open "DSN=My Sqlfundacio" SQL1 = "SELECT * FROM Proyecto WHERE codproy='" & txt Codigo. Update 'Error show up her End With and the Table structure is CREATE TABLE `proyecto` ( `codproy` varchar(9) NOT NULL, `cont` smallint(5) DEFAULT NULL, `nsubgrupo` tinyint(3) unsigned DEFAULT NULL, `titulo` varchar(255) DEFAULT NULL, `tipo_actividad` varchar(25) DEFAULT NULL, `subtipo_actividad` varchar(35) DEFAULT NULL, `entidad_financ` varchar(12) DEFAULT NULL, `organismo` smallint(5) DEFAULT NULL, `fentrada` datetime DEFAULT NULL, `comite` varchar(10) DEFAULT NULL, `finicio` datetime DEFAULT NULL, `ffin` datetime DEFAULT NULL, `area` varchar(7) DEFAULT NULL, `fenvioetico` datetime DEFAULT NULL, `faprobetico` datetime DEFAULT NULL, `faprobcient` datetime DEFAULT NULL, `fconcesionfirma` datetime DEFAULT NULL, `registro` varchar(60) DEFAULT NULL, `estado` varchar(1) DEFAULT NULL, `totalconc` decimal(19,4) DEFAULT NULL, `bloqueo` varchar(1) DEFAULT NULL, PRIMARY KEY (`codproy`) ) ENGINE=Inno DB DEFAULT CHARSET=latin1; the exception aper with any table but this is and example Hi German and thanks for your report. Now, my test shows that simple case like: Module Module1 Sub Main() Dim con Dim SQL1 Dim rs Proyecto con = New ADODB. Open("DSN=51") SQL1 = "SELECT * FROM bug38147 WHERE Fld1 = 'Primo'" rs Proyecto = New ADODB. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".