Re: Can't print Crystal Report from SQL

From: Netedix (tedtdhoang@hotmail.com)
Date: 10/14/02 

From: "Netedix" <tedtdhoang@hotmail.com>
Date: Mon, 14 Oct 2002 11:33:55 -0500

It works. I was able to trace my problem to the crystal report file which I
saved in Network drive and SQL didn't know this network drive.
I fixed it and it runs OK now.
Thanks
TH

"CW" <calvin_woodno.spam@hotmail.com> wrote in message
news:ODbSKGccCHA.1692@tkmsftngp09...
> Run your component in VB IDE in debug mode.
>
> You can then trace through your code to see what is happening.
>
> "Netedix" <tedtdhoang@hotmail.com> wrote in message
> news:#PDqefUcCHA.1520@tkmsftngp08...
> > Yes, I change my system 'Terminal Service' to 'Application server'.
> Reboot,
> > start SQL server, run Enterprise manager, run Query Analyzer, run my
store
> > procedure in debug mode, it failed again. I check SQL server log..
nothing
> > show up, check event viewer... no new event in application, system,
> > security...
> > I need help...
> >
> > Thanks in advance,
> > TH.
> >
> > "CW" <calvin_woodno.spam@hotmail.com> wrote in message
> > news:eEoPGaLcCHA.2420@tkmsftngp09...
> > > Did you start up your SQL server in application mode to see what
> actually
> > > happened when you run your DLL through oa_Method?
> > >
> > > "Netedix" <tedtdhoang@hotmail.com> wrote in message
> > > news:ORmpkmKcCHA.1092@tkmsftngp08...
> > > > Hi,
> > > > My store procedure call sp_OACreate and sp_OAMethod to a
> > DLLname.DLLclass
> > > > which is a wrap around Crystal Report CRAXDRT object. It can't print
> > from
> > > > the SQL server but it runs fine in VB application. I already apply
the
> > MS
> > > KB
> > > > article Q184291 "PRB: COM Objects Fail to Print When Called From
ASP"
> > but
> > > it
> > > > won't help. Here is my code:
> > > >
> > > > myCR.dll:
> > > > Dim app As New CRAXDRT.Application
> > > > Dim rep As CRAXDRT.Report
> > > > ...
> > > > Set rep = app.OpenReport("myRpt.rpt")
> > > > ...
> > > > rep.DisplayProgressDialog = False
> > > > rep.PrintOut False
> > > >
> > > > Here is an error message from SQL server store procedure. I use
> > > > sp_OAGetErrorInfo:
> > > > Error: 80043AC2
> > > > Source: Crystal Reports ActiveX Designer
> > > > Description: Dos error.
> > > > HelpFile: NULL
> > > > HelpID: 1000440
> > > >
> > > > Any clues?
> > > > Thanks in advance,
> > > > TH.
> > > >
> > > >
> > >
> > >
> >
> >
>
>

Relevant Pages

  • Re: User and Login auditing
    ... I am running SQL 7. ... You could put triggers on your trace table. ... How to Trace in SQL Server by Using Extended Stored ...
    (microsoft.public.sqlserver.security)
  • Re: Tracking user activities
    ... >> I'd like these settings to persist permanently and the event records to ... > In SQL 2000, this is not very simple to do. ... > Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... select Script Trace. ...
    (comp.databases.ms-sqlserver)
  • Re: C2 SQL auditing
    ... Andrew J. Kelly SQL MVP ... Do you suggest any third party tools for SOX compliance? ... I would like to off load the server side trace to the SOX team ... when I stop SQL server then my trace file gets populated. ...
    (microsoft.public.sqlserver.security)
  • Re: SQL logins logged where
    ... you can't trace directly to a table but can use the> fn_trace_gettable function to load the trace file into a> table. ... If you are using SQL Server 7, use> xp_trace_setqueuedestination to set the destination to a> table. ... Security Tab does not give too many ...
    (microsoft.public.sqlserver.security)
  • Re: Simple timeout problem
    ... Brian, I haven't found anything specific on this error. ... We'd want to limit the trace to just the BizTalkRuleEngineDB. ... To run a trace go to SQL Profiler (under the SQL Server entry in the start ... | are reporting a timeout condition trying to connect to the SQL database. ...
    (microsoft.public.biztalk.general)
Quantcast