I have a report that runs a database connection made in OLE DB ADO for Access. The report has run just fine on the setup I had. Recently we needed to change to an ODBC Microsoft Access Driver (*.mdb,*.accdb) which would allow us to connect to a seperate system that allowed us to tie two datasources together. They were both ODBC Microsoft Access Drivers (*.mdb,*.accdb)
Currently, I can create a data source connection and then build a report off this new data source connection. Then I would think open an old report made with OLE DB ADO and through "Set Data source Location in Crystal Reports Developer assign a new data source. Then change to this new data source which is accdb.
Of course when I do this I get the “Failed to retrieve data from the database” I click OK then get “Invalid Argument Provided”. Then I get a blank white page.
Does anyone know a work around or solution if there is one to this problem. Else I need to get busy with rewritting a bunch of reports over in the new version.
The only thing unique about where the datasource is or Crystal Reports Developer is that it was originally installed on a Windows 2008 Server which I had to go in and move some driver files around like the ACEODBC.DLL file over to the C:\Windows\SysWOW64\ folder. I can create a report with it so everything seems to be okay there. Please advise if you know something about this.