The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

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's gravatar image

venugopal
31113
accept rate: 0%

edited 02 Aug '13, 14:01

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174

Please provide the Version number of SQLA you use.

(02 Aug '13, 09:43) Martin

I am using SQL Anywhere version 8

(02 Aug '13, 12:56) venugopal
Replies hidden

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?

(12 Aug '13, 11:07) venugopal
1

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

(14 Aug '13, 04:10) Volker Barth

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

permanent link

answered 02 Aug '13, 13:01

Mikel%20Rychliski's gravatar image

Mikel Rychliski
2.1k1641
accept rate: 30%

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
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×98
×31
×8

question asked: 02 Aug '13, 07:54

question was seen: 1,253 times

last updated: 14 Aug '13, 04:10