Solved

Explanation of error message

Posted on 1998-11-20
2
152 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

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…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

751 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