I'm doing a simple select in PB6.5 using SQL Server 2000. I'm passing parameters

to the SQL statement. My problem is, it does not come up with any results(there

should be 2 instead of 0 rows returned). However, when I use the DB

Administrator in PB6.5, I am able to get the results. The system resides in

Sybase Adaptive Server Anywhere 6 but connects to SQL Server 2000, where I

execute my SQL. I've used dynamic cursor, plain SQL statement, and retrieve

function for the datawindow. Is there anything else I've missed? Is there

something wrong with our SQL 2000 setup.



Thanks,

Grace





EMAIL CONFIDENTIALITY:



This email is for its intended recipient only and may contain confidential

and/or privileged information.



If this email has been sent to you in error, you must not copy or distribute any

 information which it contains.  Following your receipt of this email, please

forward to and notify the Government Superannuation Office at the email address

listed above.  Following such notification, please delete this email.



Please note that any views expressed in this email are those of the individual

sender, except where the sender specifically states such views to be those of

the Government Superannuation Office.

I'd suggest that if you can possibly do this, abandon Powerbuilder as 

quick as you can. In my experience it was slow, unreliable, leaked memory 

and crashed. And no, it wasnt just my bad code, every system Ive ever seen 

in Powerbuilder is the same. We had probs when new versions of databases 

came out, and they were invariably incompatible with the older 

powerbuilder connection libraries. (Dont even get me started on its 140 

page bug list)



Anyway. this sounds like the problem you may be having, so check the PB 

web sites for latest patches etc.



Graham.

www.jobserve.com



> I'm doing a simple select in PB6.5 using SQL Server 2000. I'm passing 

parameters

> to the SQL statement. My problem is, it does not come up with any results

(there

> should be 2 instead of 0 rows returned). However, when I use the DB

> Administrator in PB6.5, I am able to get the results. The system resides 

in

> Sybase Adaptive Server Anywhere 6 but connects to SQL Server 2000, where 

I

> execute my SQL. I've used dynamic cursor, plain SQL statement, and 

retrieve

> function for the datawindow. Is there anything else I've missed? Is there

> something wrong with our SQL 2000 setup.

> 

> Thanks,

> Grace

> 

> 

> EMAIL CONFIDENTIALITY:

> 

> This email is for its intended recipient only and may contain 

confidential

> and/or privileged information.

> 

> If this email has been sent to you in error, you must not copy or 

distribute any

>  information which it contains.  Following your receipt of this email, 

please

> forward to and notify the Government Superannuation Office at the email 

address

> listed above.  Following such notification, please delete this email.

> 

> Please note that any views expressed in this email are those of the 

individual

> sender, except where the sender specifically states such views to be 

those of

> the Government Superannuation Office.

> 

>