Failed to retrieve data from database. Vendor Code 102

SOLVED

Good Morning Sage Community,

I have an issue that I can't seem to resolve after a few hours of troubleshooting...

I receive the following error when running a report:

I'm running this client of Safe X3 Client:

Doing some research - I found that this error is usually tied to the ODBC setup on the machine..  All reports I write have the ODBC conn named "ADX_CS_X3V5", whereas the old client (and this report), seem to be using "ADX_X3V5".  Therefore - I added an ODBC connection named "ADX_X3V5", and before logging into sage, configured the client to run off user preferences and added the new connection.

I STILL get the same error...

Here's the funny part - On our App box for Sage - I can run this report no problem.  

The App Box runs an older client - and when I install this older client on end users machines, the report runs fine.  The ODBC setup on the old machine uses this "ADX_X3V5".  

But then another problem arises - the "Export to..." button on the Report Reviewer doesn't work.  No errors or pop-ups - it simply just doesn't load.

Can someone provide some insight on this?  As far as I can tell, this report is using an ODBC driver that's not longer included in the windows install?  I've been sitting on this issue for awhile now.. and even our consultants seem to be stumped!  Thanks so much in advance.

  • 0
    verified answer

    Hi Joe,

    Are all the ODBC details for ADX_X3V5 on the new machines set exactly the same as those on the App Box? The report may be trying to access data stored under a particular user that the connection set up on the new machines doesn't have access to.

    Also - when the report runs, Sage passes through connection details from the running instance, so it shouldn't matter which data source your report is set to use when you open it in Crystal Reports. Sometimes though, the data sources for a report can get mixed up which results in them not being properly set when being run from Sage. To fix this, go to 'Database -> Set Datasource Location' in Crystal Reports and set the main data source for the report *and* individually set the data source for each of the tables so they all match the report data source. This is a quirk within Crystal Reports that has caused me all sorts of consternation.

    I hope this makes sense.

    Cheers,

    Ben.