ADS ERROR

[omni]

Roger,

We have a user that has two terminal servers, and a data server using ads. Been running for years.
Is trying to update all servers.
The data server (ads) we got working with one terminal server.
He added a second (not aware if he did anything else) and now getting
an error 5185 when doing any ads sql type commands, which we use on management reports.
Not ever seen this. Everything as far as I can tell is the same on the servers.
He reinstalled from the same download he got years ago.
That error is not authorized for some reason. Worked friday when one terminal server was up.

Any thoughts are appreciated, from any ads experts, which I am not.

thanks
Fred
OMni

[MIGUELON]

I think the problem is that there are two Advantage engines looking at each other. There can only be one.

Regards
Miguel

[Wolfgang Ciriack]

I do not know, if you have the advantage help file. So here is this to error 5185:

Advantage Local Server connections are restricted when used from a web server, an application server, a terminal server, or any other type of middleware or server product used to access data on behalf of remote computers.

If you receive this error, it is because your application attempted to make a local server connection from one of these restricted environments. Please review the Advantage Local Server Connections portion of the end user license agreement (license.txt, Section B) for details.

It is possible to get this error when you are not violating the license agreement. If, for example, your web application accesses local data that it uses internally, but is never transferred to a client, that usage is legal.

If you are using the Advantage Local Server to access data in this manner (or some similar manner where no data is used or seen by a client), and you receive this error code, you can add the following line to the ads.ini file under the [SETTINGS] section to disable this check:

MTIER_LOCAL_CONNECTIONS=1