cancel
Showing results for 
Search instead for 
Did you mean: 

failed to retreive data from the database

Former Member
0 Kudos

Hi Experts,

   I need your help. While i am importing a report in client machine at the time a error coming "FAILED TO RETREIVE DATA FROM THE DATABASE "

and after again one message showing "INVALID ARGUMENT PROVIDED".

  

   In test data base it's working .

   Please find these issue sir.

Thanks and Regards

Ram teja.

Accepted Solutions (0)

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi Experts,

After  verifying the database All sub reports are working properly but one error showing i.e. in my

crystal report Stored procedure is their  in my database expert stored procedure is not expanding in my

field explorer pane .Why it's not expanding that stored procedure I tried but i am not getting.

Please Experts Answer my Question Experts.

Former Member
0 Kudos

hi experts,

still it's showing same message "invalid argument provided  & failed to retreive data from the database"

after i verifying the database.

-ram

Former Member
0 Kudos

hi experts,

sorry for late responding. I hope experts will understand

sub:

In a/p invoice data is fetching that same report what was i am imported in a/r invoice. In A/R invoice

data is not fetching.

- ram teja

Former Member
0 Kudos

Hi Ram,

Try opening your problem crystal report and select in the menu: Database > Verify Database.

Thanks,

Antonio

Former Member
0 Kudos

Could it be that you're on a 64bit machine and you're trying to connect to a 32bit database with no 64bit allowable?

Try navigating to C:\Windows\Syswow64\odbcad32.exe and check if your odbc/OLE DB connection exists there.

Then navigate to C:\Windows\Syswow32\odbcad32.exe and do the same.

If they do not exist, add them (this is assuming you're on Windows 7).

Also in SQL Management Studio, check if the user account you're using has the proper permissions.

Former Member
0 Kudos

Hi Experts,

Already sql native 8 driver was there in client system.But still data was not retrieving from the database .

Thanks & Regards

Ram Teja.

former_member183750
Active Contributor
0 Kudos

Sql native 8 driver?

Pl;ease review the info I provided in my original reply...

- Ludek

abhilash_kumar
Active Contributor
0 Kudos

Hi Ram,

Please provide more info:

- What version of Crystal Reports

- What database and database driver

-Abhilash

Former Member
0 Kudos

hi

crystal report version -2011

database ms sql server 2008,

sap b1 - 8.8 version

former_member183750
Active Contributor
0 Kudos

Make sure that you follow this:

For OLE DB use:

MS SQL 2005 - OLE DB Provider

MS SQL 2008 - SQL Native 10

MS SQL 2012 - SQL Native 11

MS SQL 2013 - SQL Native 11

For ODBC use:

MS SQL 2005 - SQL Native

MS SQL 2008 - SQL Native 10

MS SQL 2012 - SQL Native 11

MS SQL 2013 - SQL Native 11

- Ludek

Senior Support Engineer AGS Product Support, Global Support Center Canada

Follow me on Twitter