SankaraNarayanan,
Thursday, April 04, 2002, 10:04:14 AM, you wrote:
SM> I am using Visual Basic application to insert and
SM> update records in MySQL database.
SM> MySQL 3.23 is installed in Windows 2000 Server.
SM> I am running my VB application from my Windows 95
SM> machine with MyODBC 2.50 for Win 95 installed in my
SM> machine.
SM> I have used the provider for the connection
SM> as follows:
SM> ............
SM> Set gcnMMLS = New ADODB.Connection
SM> With gcnMMLS
SM> ' Thru' Provider
SM> .ConnectionString =
SM> "Provider=MSDASQL.1;Persist Security Info=False;Data
SM> Source=MMLSConn"
SM> .ConnectionTimeout = 300
SM> .CursorLocation = adUseClient
SM> .Open
SM> End With
SM> ..............
SM> While saving the record i have used transaction for
SM> the connection object as follows:
SM> ..................
SM> gcnMMLS.BeginTrans
SM> ..................
SM> But the problem lies here...my application shows error
SM> as follows:(in my application i am trapping the error)
SM> ..................
SM> Error Number -2147467259
SM> [TCX][MyODBC]Transactions are not enabled
SM> ..................
SM> What could be the problem???
This error occures when you are trying to perform some
transactional calls in MyODBC on a non-transactional
MySQL server. You can add support InnoDB or BDB tables in the MySQL
server or set up 'Disable Transactions' option in the DSN configuration window.
SM> Thanks.
SM> Shankar
--
For technical support contracts, goto https://order.mysql.com/
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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
