TADOQuery.Open() & Sybase

From: "Ars Nova" <lmuniz@xxxxxxxxxxxx>
Date: 27 Jan 2006 00:13:01 -0700

I am working with Sybase Adaptive Server Anywhere 7.0, Delphi 7 and Windows 2000.
I connect to Sybase database with the follow connection string:
"Provider=ASAProv;User ID=user;Password=password;Data Source=myDataSource"
I can see all tables but when I try to request any data with "SELECT ..." statement and TADOQuery.Open(), my application gets the error "Object or provider is not capable of performing requested operation".
Is it a bug?, Does it exit any solution?
I have proved through "OLE DB Provider for ODBC" and it runs OK but I would like connecting through "Sybase Adaptive Server Anywhere Provider" or other OLE DB Provider for Sybase 7.0

Thank you.
.

Follow-Ups:
- Re: TADOQuery.Open() & Sybase
  - From: Brian Bushay TeamB

Prev by Date: Re: Locate Speed in ADO
Next by Date: [D7 Ent] [TADOStoredProc] lose and get back network connexion it still raise exceptionl
Previous by thread: Locate Speed in ADO
Next by thread: Re: TADOQuery.Open() & Sybase
Index(es):
- Date
- Thread

Relevant Pages

Re: TADOQuery.Open() & Sybase
... >I connect to Sybase database with the follow connection string: ... >Is it a bug?, Does it exit any solution? ... Does this error occur only when you run out of the IDE? ...
(borland.public.delphi.database.ado)
Weird function exit bug ?! exit = Expression illegal in evaluator ?
... I just found this weird exit bug... ... In my 'production' code this also leads to an access violation at address ... mCurrentNode: pointer; ...
(alt.comp.lang.borland-delphi)
[patch 2/2] x86 amd fix cmpxchg read acquire barrier
... There is no official AMD bug ID yet, but it seems to be reported in the field ... unsigned long prev; ... switch { ... LOCK_PREFIX " cmpxchgl %2,%0\n\t" ...
(Linux-Kernel)
Re: Latest microcode data from Intel
... A bit of a bug somewhere here... ... %preunscriptlet failed, exit status 1 ... umask 022 ... send the line "unsubscribe linux-kernel" in ...
(Linux-Kernel)
Re: generalized WHILE() extension/feature?
... UNTIL feature for DO loops. ... we already have the EXIT statement which serves a much ... The infamous DO bug actually was an urban myth anyway. ...
(comp.lang.fortran)