Solved

Explanation of error message

Posted on 1998-11-20
2
145 Views
Last Modified: 2010-04-04
Hello All !

Can someone tell me, in "plain English", what the following
error message means and how or what I need to do to rectify it?  I have a Delphi 1 app that is hitting SQL Anywhere database/tables.  The error message that I am getting is:

"Passthrough SQL connection must be shared"

The code that is being executed at the time of error is:
MainForm.ActionQuery.Close;
MainForm.ActionQuery.SQL.Clear;
MainForm.ActionQuery.SQL.Add('Select * From ' + TableName);
MainForm.ActionQuery.RequestLive := True;
MainForm.ActionQuery.Open;

Thanks in advance,
Everett
0
Comment
Question by:ecrockett
2 Comments
 
LVL 4

Accepted Solution

by:
dwwang earned 50 total points
ID: 1347448
The error is because in BDE configuration you set the SQLPassThruMode to NOT SHARED.

See the help of SQLPassThruMode in BDE configuration below:

"NOT SHARED" : Passthrough SQL and non-passthrough SQL do NOT share the same connection. Updateable SQL queries are not supported with aliases that have the SQLPASSTHRU MODE parameter set to NOT SHARED.

That means, when you want to update a dataset(requestlive:=true),
you have to set the SQLPassThruMode to SHARED ....

0
 

Author Comment

by:ecrockett
ID: 1347449
Thanks for the reply dwwang!  I was initially having a problem with my idapi.cfg file; it was not saving the settings (shared autocommit), that I was entering.  I ended up re-installing the bde, and then, I was able to save my changes.  Once the setting was turned on, I was in business.

Once again,
Thanks-A-Meg,
Everett
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
I designed this idea while studying technology in the classroom.  This is a semester long project.  Students are asked to take photographs on a specific topic which they find meaningful, it can be a place or situation such as travel or homelessness.…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now