Solved

Explanation of error message

Posted on 1998-11-20
2
149 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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article explains how to create forms/units independent of other forms/units object names in a delphi project. Have you ever created a form for user input in a Delphi project and then had the need to have that same form in a other Delphi proj…
Introduction The parallel port is a very commonly known port, it was widely used to connect a printer to the PC, if you look at the back of your computer, for those who don't have newer computers, there will be a port with 25 pins and a small print…
Are you ready to implement Active Directory best practices without reading 300+ pages? You're in luck. In this webinar hosted by Skyport Systems, you gain insight into Microsoft's latest comprehensive guide, with tips on the best and easiest way…

713 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