Hi, I am trying to execute a stored procedure and occasionally it falls into exception saying 'ASAProv.80' failed with no error message available, result code: DB_E_BADACCESSORHANDLE(0x80040E00). And some times it return no results back. Any ideas? asked 02 Aug '13, 07:54 venugopal Jeff Albion |
This is most likely a bug in the OLEDB library that was fixed in CR#530923. Because version 8 no longer has engineering support, the only resolution is to upgrade to a newer version of SQL Anywhere where this bug is fixed (9.0.2 or higher). Mikel answered 02 Aug '13, 13:01 Mikel Rychliski Hi Mikel, Thanks for your reply but The connection string for the version 8 which I am using currently is below <add name="xxx" connectionstring="Provider=ASAProv;Persist Security Info=True;Data Source=Datasourcename;UID=userid;PWD=password;ASA Multiple Results=True" providername="System.Data.OLEDB"/> But if I now use the version 12 what would be the connection string?
(13 Aug '13, 10:45)
venugopal
|
Please provide the Version number of SQLA you use.
I am using SQL Anywhere version 8
The connection string for the version 8 is below <add name="xxx" connectionstring="Provider=ASAProv;Persist Security Info=True;Data Source=Datasourcename;UID=userid;PWD=password;ASA Multiple Results=True" providername="System.Data.OLEDB"/>
But if I now use the version 12 what would be the connection string?
With SQL Anywhere 10 and above, the OLEDB provider has been renamed from "ASAProv" to "SAOLEDB".
Check the v12 docs on OLEDB connection strings:
OLE DB connection parameters