Unknown Database Connector Error

Posted on 2011-02-16
Last Modified: 2013-11-16
I have several reports that just randomly seem to break with the "Unknown Dtabase Connector Error". I think I've found the problem, but can't figure out how to resolve it.

The ODBC connector on every machine that modifies this report, should be named Ross_Data. On all the machines I use, it is correct. However, I discovered this morning when I opened a report after another user opened it, the ODBC is looking for ROSS_DATA now.

I've tried logging off the server, rebooting my PC but I can't get it to look for Ross_Data instead of ROSS_DATA. I also tried resetting the datasource location. All to no avail. How can I get it to forget ROSS_DATA exists and force it to look at Ross_Data?
Question by:Hers2keep
  • 4
  • 2
LVL 100

Expert Comment

ID: 34909142
How are you running the reports?

If you can open the report in Crystal you could use the SET DATASOURCE LOCATION to redirect it to the correct ODBC.  You might need to change that one users ODBC


Author Comment

ID: 34909199
I have looked at every machine that I know of that has ever opened this report and they are all correctly set to Ross_Data. I have used the set datasource location twice now and it *looks* like it takes, but then as soon as I go to preview the report, it goes back to ROSS_DATA and blows up again.

Author Comment

ID: 34909267
Ok I got the ODBC connector corrected finally back to Ross_Data, but I'm still getting the Unknown Database Connector Error.
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

LVL 100

Expert Comment

ID: 34909394
I don't know.  I don't use ODBC connections very often and most of the time when I do they report is being run on 1 machine so we change it on that machine and don't have issues.


Accepted Solution

Hers2keep earned 0 total points
ID: 35031323
The problem seems to have resolved itself. I have no idea what was going on and I have absolutely no idea what resolved it. So, chalk this one up to one from the Twilight Zone.

Author Closing Comment

ID: 35067619
I didn't do anything to resolve the issue it just seemed to resolve on its own.

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Selection between two dates and time range. 21 46
Crystal Reports 12 44
Crystal Reports - Logos 2 19
Keeping multiple Crystal Report detail sections sorted with each other 1 19
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
How to increase the row limit in Jasper Server.
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below.…

713 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