stored procedures and sqloledb

terre · November 17th, 2004, 01:38 PM

Tried that:
strSQL="EXEC up_exp_date @client_id=1688,@exp_date='"&exp_date&"'"

I get the same error (string or binary data would be truncted).

The stored procedure runs fine in isql and query analyzer. Is it possible to tell with query analyzer if the db connection is being made via odbc or oledb? I fooled around with the connection parameters and the system information and could not reproduce the error with query analyzer.

so wierd.

-Terre

happygv · November 22nd, 2004, 07:27 PM

If that works fine on Query analyser, it should do the same from ASP page too. Now lets move on to next step. On your ASP page, try this and post here the output that you see on your browser.

Code:

strSQL="EXEC up_exp_date @client_id=1688,@exp_date='"&exp_date&"'"
response.write strSQL
Response.end

Quote:

quote:Is it possible to tell with query analyzer if the db connection is being made via odbc or oledb? I fooled around with the connection parameters and the system information and could not reproduce the error with query analyzer.

I am not sure what connection parameters you refer to in case od query analyser.

Hope that helps.
Cheers!

_________________________
- Vijay G
Strive for Perfection