Last post Dec 17, 2010 08:45 AM by arunabathan
Dec 17, 2010 08:45 AM|arunabathan|LINK
in my website i did excel data directly upload to database table using c# code and oledb excel connection string..in this working fine local iis and usine wamp server ,but when i applied to win server R2 2008 its showing below error
System.InvalidOperationException: Transaction has already been committed or is not pending at MySql.Data.MySqlClient.MySqlTransaction.Commit() at aspx_Xlupload.karvy(Object sender, EventArgs e) in c:\inetpub\ftproot\investwise\aspx\Xlupload.aspx.cs:line 1968
i used Mysql tranaction in this uploaded function.. its surely working in local using wamp server but in server its not working.. in server side i used MySql Administrator 5.2 and MySql Ouery Brower 5.2.44
i anyone know solution please reply me..
win server R2 2008