[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    RE: MyODBC error
From:       "Robinson, Chad" <crobinson () rfgonline ! com>
Date:       2001-10-29 14:47:21
[Download RAW message or body]

Make sure:
1. You have the BIGINT->INT, Return Matching Rows, and Safety options set in
the driver or DSN. (I use option 147458.)
2. You have compiled MySQL with InnoDB suppport.
3. You have used the "SHOW TABLE STATUS" command to verify that the tables
are set to type INNODB, not MyISAM.
4. You have a timestamp field in each table.

When you want to open and lock a record, you should use "SELECT ... FROM ...
FOR UPDATE".

I've got a complete application using MyODBC, MySQL and VB6, and I'm putting
together some docs for it that I'm submitting to the group. It's about 50%
done - should be done by later this week. Hopefully it will help you.

-----Original Message-----
From: Rene Alvarez [mailto:renealvarez@att.net.mx]
Sent: Monday, October 29, 2001 4:58 AM
To: myodbc@lists.mysql.com
Subject: MyODBC error


I'm developing an application with VisualBASIC 6 using mysql and myodbc but 
found this error.

I'm trying to use transactions to insert information inside a table but 
when I use the command .BeginTrans,
the program stops and I get the error: "Run-time error. 
[TCX][MyODBC]Transactions are not enabled"

I'm really lost with this. Can you help me?

Thanks a lot


---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread4079@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@lists.mysql.com instead.

---------------------------------------------------------------------
Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
posting. To request this thread, e-mail myodbc-thread4080@lists.mysql.com

To unsubscribe, send a message to the address shown in the
List-Unsubscribe header of this message. If you cannot see it,
e-mail myodbc-unsubscribe@lists.mysql.com instead.

[prev in list] [next in list] [prev in thread] [next in thread]