Hi,
I am using Visual Basic application to insert and
update records in MySQL database.
MySQL 3.23 is installed in Windows 2000 Server.
I am running my VB application from my Windows 95
machine with MyODBC 2.50 for Win 95 installed in my
machine.
I have used the provider for the connection
as follows:
............
Set gcnMMLS = New ADODB.Connection
With gcnMMLS
' Thru' Provider
.ConnectionString =
"Provider=MSDASQL.1;Persist Security Info=False;Data
Source=MMLSConn"
.ConnectionTimeout = 300
.CursorLocation = adUseClient
.Open
End With
..............
While saving the record i have used transaction for
the connection object as follows:
..................
gcnMMLS.BeginTrans
..................
But the problem lies here...my application shows error
as follows:(in my application i am trapping the error)
..................
Error Number -2147467259
[TCX][MyODBC]Transactions are not enabled
..................
What could be the problem???
Thanks.
Shankar
__________________________________________________
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.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
