Just upgraded to IQ16 SP11

[themadmurph]

We upgraded from IQ15.4

However, I'm having an issue with remote servers to ASE.

I've dropped and recreated the remote server and external logins, as they didn't work after the upgrade.

We have a number of proxy tables to ASE and a number of procedure which get information from these proxy tables.

I can run a select from the proxy table and it connects and returns.

However, if the select is in a procedure, it either tells me that remote ASE does not exist, or claims the login fails.

I've even tried to recreate the procedure, just in case. It didn't help.

Any help would be appreciated.

TIA.

Murph...

examples

[Sybase][ODBC Driver][Adaptive Server Enterprise]Login failed.

or

Msg 11214, Level 11, State 0:

SQL Anywhere Error -659: Remote server 'REMOTE_ASE' could not be found

(82 rows affected)

[Jeff Younce]

It's obvious it's a permission issue

--
You received this message because you are subscribed to the Google Groups "iqug" group.
To unsubscribe from this group and stop receiving emails from it, send an email to iqug+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.