SBX - Search With Button

SBX - Forum Post Title

Crystal report returning Database Vendor code 102 error

Microsoft Dynamics SL Forum

peter hummel asked a question on 26 Jun 2014 1:53 PM
My Badges

Question Status

Unanswered

A custom crystal report using a view and a table. Getting error

Failed to retrieve data from database.

Details: [Database Vendor Code: 102]

We get this error only on one workstation. If the user logs on to a different workstation they can run the report. Have reloaded client on workstation, rebooted workstation, deleted ODBC connection. Different user logs on (administrator rights) and doesn't work.  Something wrong with workstation.

Reply
Rick Kerns responded on 26 Jun 2014 4:12 PM
My Badges

Peter, what version of SL and what version of Crystal Reports are you running?

You might try one ODBC change to see if it makes any difference.  Configure the ODBC definition for your application database using the SQL administrator credentials.  On the DSN configuration page, look at the Use ANSI option settings.  If they are checked, uncheck them and try the report.  If the are not checked, check them and try the report.  I know that sounds strange but I have found that the ANSI settings affect various reports built under prior versions of Windows talking to different versions of SQL.

The other common issue with some user developed reports is that they are built with a particular printer type and then the workstation running the report cannot resolve the printer optimization codes in that report.  If you open the report in Crystal and go to the printer setup, check the No Printer option.  This causes the report to be more generic and lets it work with any printer.

Not sure if either of these will help but they are things I try when I get an error similar to this and one of them usually fixes the issue.

Reply
harshshah responded on 1 Jul 2014 8:12 AM

are the sql odbc drivers for both workstation same.  on SL2011 it uses sql 2012 native client odbc.

Reply

SBX - Two Col Forum

SBX - Migrated JS