Improve company productivity with a Business Account.Sign Up

x
?
Solved

Explanation of error message

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

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

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…
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…
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…
Watch the video to know the simple way to remove or recover or reset lost or forgotten passwords of Outlook PST file. With Kernel Outlook Password Recovery tool such operation is very easy to perform. It is a freeware with limitation to use with 500…

607 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