ADS 11.10.024. Data Dictionary. I was told one time at a summit when making a Procedure in Delphi using the Advantage Extended Procedure for Win32 that I should leave the Aliasname/ConnectPath blank. I had to make a Procedure that uses data from two different databases so I have two AdsConnection should I leave the AdsConnection for the one database that is executing the procedure blank and put the Alias in the one that is connected to the second database. Right now i entered the Alias in both AdsConnection and it have been working for many months to yesterday, the company called and said that the program froze when it came to that point where it execute the Procedure. I went online and I tried to execute the Procedure from Arc32. The blue process bar just shows and it stops nothing happens. I opened the Remote Server info in Arc32 and clicked on the Active Queries and see that the Procedure shows with 2.75% completed and the seconds to complete just keep going up. Only two computers run this procedure and one computer was still in the program and was able to execute the procedure, but as soon I closed the program and started it again it was stopping at the procedure. After restarting the Ads service it works again. Any idea what could course this, the only thing I have done in the past is changing all alias \SERVER:6262\SHARED_FOLDER.. even on the server it self or I was unable to open any database.

asked 28 Sep '15, 22:57

KimHJ's gravatar image

KimHJ
516343950
accept rate: 16%


Does the server know about the alias? Does it read the ads.ini where it is defined?
I would never rely on an alias in a stored procedure and use parameters to pass in a Connection String. And don't forget to set LoginPrompt to false ... otherwise a login dialog is being executed, but a service (ADS) doesn't display it.
As for the AdsConnection that is used to connect the host database: StartUp sets its Connection Handle to the one passed into the function (that's done by Advantage). So the Alias and/or ConnectionPath becomes invalid.

link

answered 29 Sep '15, 13:08

Joachim%20Duerr's gravatar image

Joachim Duerr
8.7k1031133
accept rate: 18%

Yes the server has an ADS.INI file with Alias. It have been working for six months with the two AdsConnection each pointing to a different Alias and it most be working because part of the data only exist in the second database that does not have a procedure. So what you are saying it's a bad idea to use a connection to another database inside a procedure and that could cause the procedure to stop at 2.75% assuming that it is the point where it tries to connect to the second database.

(29 Sep '15, 19:23) KimHJ

it's not bad to use a connection to another database ... it#s just the usage of an alias that might go wrong. Without having details of your code it's hard to solve.

(29 Sep '15, 19:30) Joachim Duerr
Your answer to the original question.
If responding to a request for additional information, please edit the question or use the comment functionality.
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "Title")
  • image?![alt text](/path/img.jpg "Title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Tags:

×271
×172
×40

Asked: 28 Sep '15, 22:57

Seen: 1,961 times

Last updated: 29 Sep '15, 19:30

Advantage Developer Zone Contact Us Privacy Policy Copyright Info


Powered by Advantage Database Server and OSQA
Disclaimer: Opinions expressed here are those of the poster and do not necessarily reflect the views of the company.