Solved

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

Posted on 2010-09-14
11
1,107 Views
Last Modified: 2013-12-01
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.
0
Comment
Question by:ruavol2
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 4
11 Comments
 
LVL 16

Accepted Solution

by:
13598 earned 500 total points
ID: 33681711
Before you set the data source location on the report you need to change the driver first.
0
 
LVL 16

Assisted Solution

by:13598
13598 earned 500 total points
ID: 33681721
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
 

Author Comment

by:ruavol2
ID: 33685453
There is no Convert database driver anywhere under the Crystal Reports Developer 2008 Database Menu....?
0
Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

 
LVL 16

Expert Comment

by:13598
ID: 33685642
You are correct. I was looking at an older version. Did you try Verify Database?
0
 
LVL 16

Assisted Solution

by:13598
13598 earned 500 total points
ID: 33685856
The Invalid Argument Provided part of your error would point more to the database links or mappings. Did you check those?
0
 
LVL 16

Assisted Solution

by:13598
13598 earned 500 total points
ID: 33685884
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
 

Author Comment

by:ruavol2
ID: 33685914
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
 
LVL 16

Assisted Solution

by:13598
13598 earned 500 total points
ID: 33685939
Try logging off and logging back on first. From your Database /Log On or Off Server and see what happens.
0
 

Author Comment

by:ruavol2
ID: 33685950
Do you mean log on off through Crystal Reports or Access. It is a large Access database about 1 gig.
0
 
LVL 16

Assisted Solution

by:13598
13598 earned 500 total points
ID: 33686182
I meant Crystal Reports/Database/LogOn or Off Server.
0
 

Author Closing Comment

by:ruavol2
ID: 33801690
We are good. That got me over the hurdle
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The article will include the best Data Recovery Tools along with their Features, Capabilities, and their Download Links. Hope you’ll enjoy it and will choose the one as required by you.
I was prompted to write this article after the recent World-Wide Ransomware outbreak. For years now, System Administrators around the world have used the excuse of "Waiting a Bit" before applying Security Patch Updates. This type of reasoning to me …
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…
This tutorial will walk an individual through setting the global and backup job media overwrite and protection periods in Backup Exec 2012. Log onto the Backup Exec Central Administration Server. Examine the services. If all or most of them are stop…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question