Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Unknown Database Connector Error

Posted on 2011-02-16
6
Medium Priority
?
1,899 Views
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?
0
Comment
Question by:Carla Romere
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
6 Comments
 
LVL 101

Expert Comment

by:mlmcc
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

mlmcc
0
 

Author Comment

by:Carla Romere
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.
0
 

Author Comment

by:Carla Romere
ID: 34909267
Ok I got the ODBC connector corrected finally back to Ross_Data, but I'm still getting the Unknown Database Connector Error.
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 
LVL 101

Expert Comment

by:mlmcc
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.

mlmcc
0
 

Accepted Solution

by:
Carla Romere 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.
0
 

Author Closing Comment

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

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

722 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