by abc » Wed, 06 Feb 2002 13:46:50
when ODBC calls a stored procedure which in turns calls another
procedure returns an incorrect value whereas it should return a correct
value in SQL query analyzer.
any idea?
thanks
abc
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
by Rishi M. Agrawal [M » Thu, 14 Feb 2002 03:55:41
Query Analyzer also uses ODBC to connect to SQL Server.
It is difficult to comment on the problem without going over the stored
procedures and the relevant tables' script. Could you post the DDL or a
script that will help reproduce the problem ?
Hope that helps.
Regards,
Rishi M. Agrawal, MCDBA
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
--------------------
| Subject: ODBC call stored procedure returns incorrect value
|
| Hi all,
|
| when ODBC calls a stored procedure which in turns calls another
| procedure returns an incorrect value whereas it should return a correct
| value in SQL query analyzer.
|
| any idea?
|
| thanks
|
| abc
|
|
|
| *** Sent via Developersdex http://www.developersdex.com ***
| Don't just participate in USENET...get rewarded for it!
|
1. ODBC returns incorrect value in stored procedure
Hi all,
has anybody experience stored procedure returning a value say 2 in Query
analyzer but when pass through ODBC returns a 0. When returning a string
value, ODBC returns a null.
Please shed some light on this.
thanks
andrew
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
2. Data Modelling Software on Net ?
3. return select values in stored procedure to a calling stored procedure
4. Unix "group" permissions is Informix
5. Howto call a stored procedure and get a return value
6. select count(x) returning 1 instead of total count
7. hr return value wrong when calling MTS component from Stored procedure
8. Servlet cannot connect to Microsoft SQL Server database
9. Error when evaluating return value from stored procedure call
10. Newbie problem with stored procedure call return value
11. Howto call a stored procedure and get a return value
12. no value returned calling stored procedures in vc++