Hi,
I am trying to submit a listing to an online
marketplace/auction site (which uses html for item
description etc) and right at the end this error message
comes on to the screen:

Microsoft OLE DB Provider for ODBC Drivers
error '80040e21'[Microsoft][ODBC SQL Server Driver]String
data, right truncation
/eMarketPlace/CADPostClass.asp, line 183

I have cleared caches, disabled my firewall etc, but to no
avail. I have used this site to submit listings before,
but this has never happened. I have emailed the site, but
they say nothing is wrong from their end. I have tried
over a two week period to list, but the same message comes
up.

Does anyone know what this message means and how I can fix
it.
Thanks
Ana

Do a Profiler trace and find out what stored procedure is being called. May
be the data is getting truncated. Did you try to run the stored procedure
manually in QA and did it return any errors?.

Meher

"Ana" <ana@e-wire.net.au> wrote in message
news:052b01c343a4$36d74140$a301280a@phx.gbl...
> Hi,
> I am trying to submit a listing to an online
> marketplace/auction site (which uses html for item
> description etc) and right at the end this error message
> comes on to the screen:
>
> Microsoft OLE DB Provider for ODBC Drivers
> error '80040e21'[Microsoft][ODBC SQL Server Driver]String
> data, right truncation
> /eMarketPlace/CADPostClass.asp, line 183
>
> I have cleared caches, disabled my firewall etc, but to no
> avail. I have used this site to submit listings before,
> but this has never happened. I have emailed the site, but
> they say nothing is wrong from their end. I have tried
> over a two week period to list, but the same message comes
> up.
>
> Does anyone know what this message means and how I can fix
> it.
> Thanks
> Ana

Thanks for that, unfortunately I'm not familiar with that terminology.
If you could explain how to action what you said that would be great.
Thanks
Ana


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

In SQL Enterprise Manager Go to Tools -->SQL Profiler. A new profiler window
opens up. Choose File --> New Trace and Choose your server. After Clicking
ok the Trace properties window shows up. In the trace properties Click the
Events tab and add stored procedures. Then in the filters fill in the
database name or databaseid and click ok to run the trace. run your process
on the web. The trace will capture the stored procedure that is being passed
with parameters. Copy that statement and paste it in SQL Query Analyzer and
see if there is any error returned.

Meher

"Ana Bogdanovic" <ana@e-wire.net.au> wrote in message
news:eW03PWbRDHA.2148@TK2MSFTNGP10.phx.gbl...
>
> Thanks for that, unfortunately I'm not familiar with that terminology.
> If you could explain how to action what you said that would be great.
> Thanks
> Ana
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!