An error occured during printing (0x80004005)

We have been dealing with this problem for months on end.
The print button on the sql reporter web interface fails to print.
I read about lots of other people with this problem, but Microsoft has
not acknowledged it yet as far as I know.Bump.|||Set.|||Spike.
No responses though...|||Hi
That code indicates access denied. Make sure that the user has the rights to
use the print queue.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"cmay" <cmay@.walshgroup.com> wrote in message
news:1132004788.705682.231620@.o13g2000cwo.googlegroups.com...
> Spike.
> No responses though...
>|||Score.
--
Cheers,
'(' Jeff A. Stucker
\
Senior Consultant
www.rapidigm.com
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:O4gHzWW6FHA.2176@.TK2MSFTNGP14.phx.gbl...
> Hi
> That code indicates access denied. Make sure that the user has the rights
> to use the print queue.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "cmay" <cmay@.walshgroup.com> wrote in message
> news:1132004788.705682.231620@.o13g2000cwo.googlegroups.com...
>> Spike.
>> No responses though...
>|||Mike,
Thanks for the reply.
All of our printers are network printers, but I have access to all of
them, and I can print from any other program just fine.
If I didn't have access to the print queue, would I be able to print
from other programs (Word, Outlook, Notepad, etc)?
Chris
Mike Epprecht (SQL MVP) wrote:
> Hi
> That code indicates access denied. Make sure that the user has the rights to
> use the print queue.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland|||Actually...
I tried hooking up a local printer to one machine.
It prints the first page of the report and then craps out with this
exact same exception.

Am I in the right direction?

I am using VFP as my interface and using SQL table as my back-end but recently i got this problem when i add another field in one of my tables, Before it has only 35 field and it goes right, but when I add another 3 fields my problem starts,... if i edit a character fields with all necessary code to update a record and accepted by SQL it has no problem... but when i edit the numeric field which I add, after i refresh my form, it goes back to each original values. at sql table also when i opened nothing happened the old value still there.

Thank you for any help

Hi Madix_t,

Do you add the field via SQL Management Studio or by ALTER TABLE statements via SQL Pass-through?

I assume you use Visual FoxPro Remote Views, or perhaps VFP CursorAdapters to access the data, or are you using SQL Pass-through? Are you using a buffering scheme?

How are you changing the data? After you've typed in the Textbox (or Grid) do you use the VFP TableUpdate() statement to commit the changes? Do you then requery the SQL back end before you refresh the form?

|||

I am using CursorAdapter, and I even tried to recreate the CA, but it's d'same.

Regarding how I save my data, i dont have any problem with all my tables in MS SQL at VFP interface, all necessary steps that SQL will accept my data has been followed ,.. just only this table after I add another fields., and also this is the only table that has 38 fields.

thanks for any help

|||

Hi Madix_t,

Can you duplicate this problem with a new table? Is there anything about the column that's odd such as being accidentally set to read-only or having a constraint that prohibits the update values you've used?

|||

ok..i'll try it, and thank you maam

Am I in the right direction?

I am using VFP as my interface and using SQL table as my back-end but recently i got this problem when i add another field in one of my tables, Before it has only 35 field and it goes right, but when I add another 3 fields my problem starts,... if i edit a character fields with all necessary code to update a record and accepted by SQL it has no problem... but when i edit the numeric field which I add, after i refresh my form, it goes back to each original values. at sql table also when i opened nothing happened the old value still there.

Thank you for any help

Hi Madix_t,

Do you add the field via SQL Management Studio or by ALTER TABLE statements via SQL Pass-through?

I assume you use Visual FoxPro Remote Views, or perhaps VFP CursorAdapters to access the data, or are you using SQL Pass-through? Are you using a buffering scheme?

How are you changing the data? After you've typed in the Textbox (or Grid) do you use the VFP TableUpdate() statement to commit the changes? Do you then requery the SQL back end before you refresh the form?

|||

I am using CursorAdapter, and I even tried to recreate the CA, but it's d'same.

Regarding how I save my data, i dont have any problem with all my tables in MS SQL at VFP interface, all necessary steps that SQL will accept my data has been followed ,.. just only this table after I add another fields., and also this is the only table that has 38 fields.

thanks for any help

|||

Hi Madix_t,

Can you duplicate this problem with a new table? Is there anything about the column that's odd such as being accidentally set to read-only or having a constraint that prohibits the update values you've used?

|||

ok..i'll try it, and thank you maam