For Programmers: Free Programming Magazines  


Home > Archive > PowerBuilder > April 2005 > Stuck with SQLSTATE 37000 (PB 10, MDAC 2.8 sp1)









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Stuck with SQLSTATE 37000 (PB 10, MDAC 2.8 sp1)
Guy

2005-04-12, 3:59 pm

I have this datastore SQL which contain an SQL with 2 parameters. When
I run my application, the Retreive() returns -1. I am not sure if this
is because there are no rows or if the ODBC driver chokes on
parameters. I get ther 37000 errore when I run the datastore
Run/Preview, and supply paramaters by hand.

I have tried SQLCB.DbParems = "DataBind=1", as per several posts, but
it keeps giving the errors.

Help please. I am trying to get a PB 8 application to work with PB 10.
(Anly clues where I can find PB 8, just in case?)

Config: PB 10, MDAC 2.8.0, SQL Server 2000
Sponsored Links







Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive

Copyright 2008 codecomments.com