Re: ASEOLEDB alternatives?

On Oct 9, 11:21 am, pamela fluente <pamelaflue...@xxxxxxxxx> wrote:
On 5 Ott, 08:20, Jesse <goo...@xxxxxxxxxxxxxxxxxxxxxxx> wrote:





Hi,

I am using ASE 15's oledb provider in a C# program to connect to an
15.0 server. I am finding that it is extremely buggy - all sorts of
access violations for harmless looking queries.

The version of the provider is 15.0.0.51 (file: sybdrvoledb.dll). My
connection string looks like this;
Provider=ASEOLEDB;Data Source=SUMMER:5000;Initial Catalog=pubs3;User
Id=***;Password=***

Does anyone have any experience with ASEOLEDB and it's apparent
flakiness? Just wondering if there's any better alternative out
there. Perhaps there's a better 3rd party oledb provider for
example?

If I run the same queries with AseClient, they work fine.
Unfortunately for this project I can't use AseClient.

For example, here's a simple query that fails every time with an AV in
the ASEOLEDB provider:

exec sp_helpdb 'pubs3'

It AV's when I call Dispose() on the DataReader object after finishing
iterating through the rows:
---------------------------------------------------------------------------­­------------------
Attempted to read or write protected memory. This is often an
indication that other memory is corrupt.

System.AccessViolationException

at
System.Data.Common.UnsafeNativeMethods.IMultipleResults.GetResult(IntPtr
pUnkOuter, IntPtr lResultFlag, Guid& riid, IntPtr& pcRowsAffected,
Object& ppRowset)
at System.Data.OleDb.OleDbDataReader.NextResults(IMultipleResults
imultipleResults, OleDbConnection connection, OleDbCommand command,
IntPtr& recordsAffected)
at System.Data.OleDb.OleDbDataReader.Close()
at System.Data.Common.DbDataReader.Dispose(Boolean disposing)
at System.Data.Common.DbDataReader.Dispose()
---------------------------------------------------------------------------­­------------------

There are other queries where the AV isn't on the Dispose call, but on
ExecuteReader() or some other method. Basically I am finding that
ASEOLEDB is bug-ridden.

would appreciate any advice you may have. I am a bit of a sybase noob
so I feel like I'm at a loss.

Thanks,

Jesse

Jesse,

I am also greatly interested in this question.
If you find a solution to your problems, could you please make me
aware?

Thank you.

-P
---------------------------------------------------------------------------­----------------http://www.datatime.eu/download.aspx
Providing Sybase users with the world's best Reporting Solution- Hide quoted text -

- Show quoted text -

Your thread is titled "ASEOLEDB alternatives?". So, have you thought
about using the
ASE Web Services Producer instead. With this method, database access
is performed
via SOA, with results returned as an XML string. I have not
encountered bugs with this
interface.

I stopped using JDBC, ODBC, and ct-lib several years ago in favor or
Web Services.
For ASE 12.X, this feature was a purchased option, for ASE 15, the
feature is included
with the product.

Mark Gearhart

.