hello,
am not sure where to post this, either in ASP or MS SQL, the error below tends to show up from time to time when trying to run a script.

line 86 below is where my script calls a stored proceedure.

funny enough this error does not show up always

pls advice
Afrika

line 86 >> set cmdSms = Server.CreateObject("ADODB.Command")

Um,... are you sure that is where the error is actually occuring??

I would wrap a pile of debugging around that line, write to a log file or something, because I can't see how that line would work one time and not the other, it's not like you have any variables involved or anything.

thanks for your reply.

Please explain how you would debug in "asp"

you can write output to the screen

response.write "section A<br>"
make the DB connsection
response.write "section b<br>"
Select a recordset
response.write "section c<br>"
run stored procedure
response.write "section d<br>"

thats one way of doing it.....

yup, that would be my suggestion as well...

Sorry this is late,
thanks I added an error handling function. after the on error resume next to catch the error

however the problem was a bit complex. i was using varchar(15) to save 11 characters, but when its passed in the asp page, the server.encode function would translate it to much more than 15 characters.

I have solved it now, i just increased the database values

thanks all
Afrika