Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Explanation of error message

Posted on 1998-11-20
2
Medium Priority
?
173 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 200 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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

Question has a verified solution.

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

Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

927 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