TADOQuery.Open() and Sybase

Article View: borland.public.cppbuilder.database.ado

Article #649

Back to borland.public.cppbuilder.database.ado Previous Next

#649

From: Ars Nova
Date: Wed, 01 Feb 2006 14:18

11 lines
1468 bytes

I work with Sybase Adaptive Server Anywhere 7.0 and Builder C++ 6.0.
I connect to my database via ADO through "ASAProv" provider, OLE DB Provider for Sybase, and my connection string is the follow:
"Provider=ASAProv;User ID=myUser;Password=myPassword;Data Source=X"
"ADOConnection.Open()" runs OK but when I try request data to any table with "ADOQuery.Open()"... It shows the error "Object or provider is not capable of performing requested operation" 
Why?, I need any solution.
Does the "TADOQuery object" have any special properties?

I need connect to through OLE DB Provider for Sybase, not OLE DB Provider for ODBC.

Thank you very much

Technical Details

Message-ID: <43e0d158$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!proxad.net!194.117.148.138.MISMATCH!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,edd5ff595e151e76,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Ars Nova" <lmuniz@ars-nova.net>
Sender: "Ars Nova" <lmuniz@ars-nova.net>
Reply-To: "Ars Nova" <lmuniz@ars-nova.net>
Subject: TADOQuery.Open() and Sybase
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 212.22.39.106     
NNTP-Posting-Host: 207.105.83.66
Message-ID: <43e0d158$1@newsgroups.borland.com>
Date: 1 Feb 2006 07:18:48 -0700
X-Trace: newsgroups.borland.com 1138807128 207.105.83.66 (1 Feb 2006 07:18:48 -0700)
Lines: 12
Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!proxad.net!proxad.net!194.117.148.138.MISMATCH!pe2.news.blueyonder.co.uk!blueyonder!news-peer-test!btnet!newsfeed.bt.es!caladan.landsraad.net!newsgroups.borland.com!not-for-mail