Posted 27 October 2008 - 10:59 AM
We are experiencing a problem when using Crystal Reports 10 with VB2005 to generate reports using larger datasets. If we try to print a report that would contain a fairly large amount of data we get an error.
Exception source is RptControllers.dll
Exception Type System.Runtime.InteropServices.ComException
Exception Message: Login Failed
ADO Error Code 0x
Microsoft OLE DB Provider for SQL Server
[DBNETLIB][ConnectionOpen (Connect()).] SQL Server does not exist or access denied
SQL State 08001
Native Error: Error in File c:\docum~1\useraccount\locals~1\Temp\**name of reporttempfile.rpt
Unable to connect: incorrect log on parameters.
Exception Target site SetTableLocation
Now the above sound obvious at first but mind you if we filter the report for a Shorter time frame or use MORE paramters it will print just fine.
We have had this error reported on Win XP Sp3. SP2, Windows 2003 Server, and Server 2000.
We cleaned out the temp file folder and occasional it lets us print the report but just once and not all the users can print after cleaning out the temp files. I think that's got to do with the amount of data they are trying to pull. We attempted to reinstall the application ( crystal ten) and added full control rights to all the folders involved.
We've been told to check the drive to see if its fat 32 but found that all of them are NTFS. Please any help would be appreciated.