Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

CR9 Viewer - ADO - Invalid path or Filename

Status
Not open for further replies.

tpear

Programmer
Jan 6, 2004
9
0
0
US
Crystal Reports Version: 9
Dataconnection: Pulling from DBF files using ADO Provider: VFPOleDB
Integration: RDC
Software Platform: Visual FoxPro 8 SP1
MDAC Version 2.7 or higher
This is not related to Web.

Over 3000 installs working successfully on W98SE, WME, W2000, WXPH, WXPP

Simplified Working Code Sample:
lcPath = JustPath (Lower(tcData_Fullpath_Filename))
lcLoc = JustFName (Lower(tcData_Fullpath_Filename))
lcSub = JustStem (Lower(tcData_Fullpath_Filename))
lcCon = 'Provider=VFPOLEDB.1;Data Source=' + lcPath
oCR = CreateObject('CrystalRuntime.Application.9')
oRpt = oCR.OpenReport(tcReport_Fullpath_Filename)
oFrm = CreateObject('form')
oRpt.Database.Tables.Item(1).SetTableLocation(lcLoc, lcSub, lcCon)
oFrm.AddObject('oVwr','oleControl','CrViewer9.CrViewer.9.2')
oFrm.WindowType = 1
oFrm.oVwr.Visible = .T.
oFrm.oVwr.Width = oFrm.Width
oFrm.oVwr.Height = oFrm.Height
oFrm.oVwr.ReportSource = oRpt
oFrm.oVwr.ViewReport()
oFrm.Show()


Current problem I'm researching follows:

Client workstation is W98SE
MDAC 2.8 RTM ( MDAC Component Checker returns no mismatches )
ADO Connection to data coded in VFP 8 SP 1 works without a problem
Report file (rpt) exist on mapped drive P:\Rpt_Pre (tried local taking network out of the equation)
Temp data exist on local C:\Windows\Temp

Crystal Reports Viewer reports
invalid path or filename
native error 295

Client is in another state, I only discuss things over the phone with them.
Any suggestions on what might be causing this error?
Any file versions I should be looking for?


 
So, the problem doesn't really appear to be related to the error given.

If this primary workstation (W98SE) prints to it's local printer through Crystal Reports, then the client workstation can print to the printer without an error.

Restart the client workstation, (not the primary) and the client workstation can not print until the primary again prints to the printer through Crystal Reports (the VFP application and CR 9).

I'm going to get more information from the client. How are the printers connected. USB, LAN, LPT
They have the latests HP drivers. Is the drive truely installed locally on the client and not just shared on ( if that was possible on w98se platform )?


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top