modglin
Programmer
- Apr 10, 2001
- 105
I have been creating reports in Crystal 8.5 using my ODBC driver FoxProFile-Word for quite some time. Not sure what has changed, but when I try to refresh one of these reports or try to create a new report I do not get the some options that I used to get.
Previously, when creating a new report I would click on the ODBC driver mentioned above and it would then go to a Configure Connection where I would click ?Free Table directory and indicate O Drive and click OK. It would then listallof the .dbf files and if I clicked OK aain it would then go to Data Explorer and I could add the tables that I needed for the report.
For some reason when I click on the driver now it goes to a Select Data Source screen where it is asking for a DSN name. I am not able to get any further than that to connect to the tables (not really sure what it is looking for). I get this same screen if I click refresh on a report previously created - where in the past it would just refresh.
I went to a computer that has the actual program that these tables are created in and Crystal and she still gets the options that I previously had and it also refreshes any reports that are currently there. I then went to another computer and installed crystal to see if I would be able to create the report. Had to download an ODBC driver for Foxpro, once I did that and tried to create the report, I received the Select Data Source rather than teh Configure connection.
Any ideas as to what could have changed or caused this. Would a change in security for the database (payroll files) have caused the inability to connect even though it does not give that sort of error?
Previously, when creating a new report I would click on the ODBC driver mentioned above and it would then go to a Configure Connection where I would click ?Free Table directory and indicate O Drive and click OK. It would then listallof the .dbf files and if I clicked OK aain it would then go to Data Explorer and I could add the tables that I needed for the report.
For some reason when I click on the driver now it goes to a Select Data Source screen where it is asking for a DSN name. I am not able to get any further than that to connect to the tables (not really sure what it is looking for). I get this same screen if I click refresh on a report previously created - where in the past it would just refresh.
I went to a computer that has the actual program that these tables are created in and Crystal and she still gets the options that I previously had and it also refreshes any reports that are currently there. I then went to another computer and installed crystal to see if I would be able to create the report. Had to download an ODBC driver for Foxpro, once I did that and tried to create the report, I received the Select Data Source rather than teh Configure connection.
Any ideas as to what could have changed or caused this. Would a change in security for the database (payroll files) have caused the inability to connect even though it does not give that sort of error?