• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1926
  • Last Modified:

Unknown Database Connector Error

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?
0
Carla Romere
Asked:
Carla Romere
  • 4
  • 2
1 Solution
 
mlmccCommented:
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

mlmcc
0
 
Carla RomereDirector of Information TechnologyAuthor Commented:
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.
0
 
Carla RomereDirector of Information TechnologyAuthor Commented:
Ok I got the ODBC connector corrected finally back to Ross_Data, but I'm still getting the Unknown Database Connector Error.
0
Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
mlmccCommented:
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.

mlmcc
0
 
Carla RomereDirector of Information TechnologyAuthor Commented:
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.
0
 
Carla RomereDirector of Information TechnologyAuthor Commented:
I didn't do anything to resolve the issue it just seemed to resolve on its own.
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now