I've tried posting and reposting this message in several other sybase
forums without so much as a chastisment for posting in the wrong forum.
I'm trying here now in hopes someone will actually have a suggestion!

My company was using ASA 6 with a customized program in powerbuilder.
Until the upgrade to ASA 7, the program was able to excute nested
queries.

I created a log to see what is happening and have pasted below. The
only thing I can say for certain is that the nested queries seem to
work when connected to a local test server. It's when I go over tcp/ip
that they no longer work. I could sure use some help.

Any suggestions for settings on the ODBC client would be gratefully
welcomed or
alternatively the right forum to post this help request in.


Thu Jan 19 2006 09:47
CONN: Application information:
"HOST=Z018386;OS=Windows 2000 Build 2195 Service Pack
4;PID=0x3f8;THREAD=0x504;EXE=C:\Applications\Accep t\accept.exe;VERSION=7.0.**4.2788;API=ODBC"



CONN: Attempting to connect using:
UID=dbd;PWD=***;DBN=Accept;ENG=pbprod1;CON=SQL_DBC _2164d20;ASTOP=YES;INT=NO**;CBSIZE=1048;CBSPACE=10 ;DBG=YES;LTO=1200;LOG=c:\crts.log;DMRF=NO;LINKS=TC P*I*P{ip=w000s2k005};PROWS=2048;PBUF=2048



Trying to start TCPIP link ...


Loading wsock32.dll
Loading ws2_32.dll
TCP using Winsock version 2.0
My IP address is 10.173.149.73
My IP address is 127.0.0.1
TCPIP link started successfully


Trying 10.173.188.215:2638
Found database server pbprod1 on TCPIP link
Client connected
CONN: Connected to the server
CONN: Connected to database successfully