Make sure that Return matching rows is checked in your DSN Configuration. Also you can try a DSN-Less Connection like
sql_connection.ConnectionString="Driver={MySQL};server=localhost;DB=DBName;U ID=;PWD=" For MySQL 3.51.04 you have to write Driver={MySQL 3.51.04} for it to work. HTH JFernando *** sql *** -----Original Message----- From: GAY Samuel [mailto:S.GAY@;envergure-conseil.com] Sent: October 30, 2002 09:55 To: MySQL Help Subject: RE: ODBC problem It's ADODB. Here is the "open" code : [...] Set sql_connection = New ADODB.Connection sql_connection.ConnectionTimeout = 10 sql_connection.CommandTimeout = 10 sql_connection.ConnectionString = "Data Source=MoniteurReseau" sql_connection.Open [...] In my ODBC data source "MoniteurReseau" I only specify the database name and the host (localhost). At home (on my own computer) I specify no user (no restriction for any user), and at work I specify "root" as user and the password. The open is done without error, except if I close it and reopen. But the first time the "bug" is on my update request. Sam. -----Message d'origine----- De : Fernando Grijalba [mailto:fernando@;ggtours.on.ca] Envoyé : mercredi 30 octobre 2002 15:47 À : MySQL Help Objet : RE: ODBC problem How are you connecting your app? DSN, ADO Connection String, DAO, etc... JFercan *** sql *** -----Original Message----- From: GAY Samuel [mailto:S.GAY@;envergure-conseil.com] Sent: October 30, 2002 04:47 To: Mail List MySQL (E-mail) Subject: ODBC problem Hi, To test MySQL I'm migrating a small VB project wich already run with SQLServer2000 to try ODBC. I've a problem with two versions of MyODBC (2.50.39 and 3.51.04). I can connect, make some "select..." with succes, one update, and my VB program always crash on an update ! Here is the request, exactly copied from VB debug : --- update adresses_a_surveiller set etat_reseau =1, etat_point_acces=1 where adresse_reseau='10.0.1.253' --- The error message I get is : --- [MySQL][ODBC 3.51 Driver][mysqld-3.23.53-max-nt-log]MySQL server has gone away --- The request is ok according to the table structure, I tried to cut/paste it and run the reqest in MySQL interpreter, and my update is done ! The table structure is (I added a timestamp according to the documentation about ODBC) : --- CREATE TABLE IF NOT EXISTS adresses_a_surveiller ( adresse_reseau VARCHAR(128) NOT NULL, libelle VARCHAR(128), adresse_point_acces VARCHAR(128), etat_reseau INTEGER(1) DEFAULT 1 , etat_point_acces INTEGER(1) DEFAULT 1 , odbc_timestamp timestamp, PRIMARY KEY (adresse_reseau) ) TYPE=InnoDB; --- Another problem : when I restart my VB projet, or if I force to close an reopen my ODBC link to the database before the update, I get this error message : --- [MySQL][ODBC 3.51 Driver]Can't create TCP/IP sicket (10093) --- I don't understand why it doesn't work... any advice ? Thanks in advance. Sam. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php