>I just finished fixing one problem with Crystal, and here I go encountering another.

>I developed a report in Crystal Reports 9.0 that I am accessing through FoxPro using the RDC. When I run the report directly within the
>Crystal Application, no problem. However, when I access the report using the RDC in FoxPro I crash with an error stating "Logon Failed.
>Details: Cannot find DSN in connection string.." when it tries to process the ReadRecords() method. I am not using a DSN, I am
>connecting to two FREE FoxPro tables.

>Can anyone help me out? :-) Thanks for any help in advance.

Additional Info: I tracked down part of my problem, I am just hoping someone else has come across this issue and has a fix. Originally, I was running this report off of an ODBC connection to roughly five tables. The problem I was encountering was that the RDC was taking an extraordinary amount of time to run the report. After trying to find a way to speed up the process without success, I decided to forgo the ODBC connection and instead, process all the calculations in FoxPro, and export two tables with all the required information preformatted. I took the original RPT, removed the ODBC tables, added the FOX2X tables and made some minor tweaks to the design so that it all worked off the new tables.

Now when I run in the Crystal Application, everything works great. The RDC however complains about a Logon Failure. Upon stepping through the code, I found that the .Database.Tables collection is STILL reporting the ODBC tables. I have no clue where it is getting this information from. I checked the RPT file setting several times, and I see no references to the ODBC tables. Why do these reference still exist in the Collection? How do I get rid of them? Please help....thanks in advanced for any help that can be offered.

________________________
Ben Santiago, MCP & A+
Programmer Analyst (SQL, FoxPro, VB, VB.Net, Java, HTML, ASP, JSP, VBS)
Eastern Suffolk BOCES - Student Data Services

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the Universe trying to produce bigger and better idiots. So far, the Universe is winning.
-Rich Cook