Changing a Crystal Reports Developer 2008 "Setting the datasource location" causing error invlalid argument provided.

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.
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?
 
13598Connect With a Mentor Commented:
Before you set the data source location on the report you need to change the driver first.
0
 
13598Connect With a Mentor Commented:
Before you set the data source location on the report you need to change the driver first.
Click on Database. Convert Database Driver and select the new driver.
 
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
There is no Convert database driver anywhere under the Crystal Reports Developer 2008 Database Menu....?
0
Making Bulk Changes to Active Directory

Watch this video to see how easy it is to make mass changes to Active Directory from an external text file without using complicated scripts.

 
13598Commented:
You are correct. I was looking at an older version. Did you try Verify Database?
0
 
13598Connect With a Mentor Commented:
The Invalid Argument Provided part of your error would point more to the database links or mappings. Did you check those?
0
 
13598Connect With a Mentor Commented:
Also how exactly did you set the data source location for your tables? I know you went to Set datasource location but then what did you do in there?
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
Yeah I just did and I get a Login failed pointing to a DAO error code saying it does not recognize the file which is now an .accdb not an .mdb?
I bet I am going to have to rewrite all these reports............Lions and tigers and bears oh no...!
0
 
13598Connect With a Mentor Commented:
Try logging off and logging back on first. From your Database /Log On or Off Server and see what happens.
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
Do you mean log on off through Crystal Reports or Access. It is a large Access database about 1 gig.
0
 
13598Connect With a Mentor Commented:
I meant Crystal Reports/Database/LogOn or Off Server.
0
 
Fletcher BurdineTableau Trainer & Consultant Sales Exec.Author Commented:
We are good. That got me over the hurdle
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.