SEO

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

Hey,

1/ Did you try to export the nested report to find out any 'strong' connect
to a database?
2/ Did you try to create the same nested report in the new configuration and
test it?
RC

"Impy" <wynnemail@gmail.com> a écrit dans le message de
news:1138230133.953408.146820@o13g2000cwo.googlegr oups.com...
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:\c rts.log;DMRF=NO;LINKS=TCP*
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

Rachid,
Thanks for your help. As far as suggestion #1, do you mean 'string'
connect? Or did you really mean strong? If so you'll need to explain
that further.
As for suggestion # 2. I'm not sure what you mean by creating the
nested report on the new configuration? The new configuration was just
upgrading the server from ASA 6 to 7 and subsequently upgrading the
ODBC client from 6 to 7. The powerbuilder version itself was not
upgraded but was pointed to the new ODBC driver (via an .ini file).
Actually, the new driver was simply named the same as the old driver
(after first renaming the old drivers to "bak")
Wynne

Wynne,
In french we say 'En dur dans le script', but please forget suggestion #1.
About suggestion #2, sometimes we don't undersatnd what happen with PB when
we change a little thing, so i suggest you to run your report in
developement mode and see if it works with the database in the server,
before re-generate the report.
Rachid

"Impy" <wynnemail@gmail.com> a écrit dans le message de
news:1138982490.392720.71320@g44g2000cwa.googlegro ups.com...
> Rachid,
> Thanks for your help. As far as suggestion #1, do you mean 'string'
> connect? Or did you really mean strong? If so you'll need to explain
> that further.
> As for suggestion # 2. I'm not sure what you mean by creating the
> nested report on the new configuration? The new configuration was just
> upgrading the server from ASA 6 to 7 and subsequently upgrading the
> ODBC client from 6 to 7. The powerbuilder version itself was not
> upgraded but was pointed to the new ODBC driver (via an .ini file).
> Actually, the new driver was simply named the same as the old driver
> (after first renaming the old drivers to "bak")
> Wynne
>