?
Solved

Database Server Error

Posted on 2011-09-28
19
Medium Priority
?
352 Views
Last Modified: 2013-12-25
Error Message:
The description for Event ID ( 0 ) in Source ( WITS ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. You may be able to use the /AUXSOURCE= flag to retrieve this description; see Help and Support for details. The following information is part of the event: Error:
Error#: -2147220501

Error Text:Unable to tie the query to the ADO connection.

Source: DB_Lib.SelectQuery

Receiving this error when executing any query.  

Any ideas?

Thank you,

Wendee
0
Comment
Question by:pwdells
[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
  • 10
  • 8
19 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36719516
This was only posted in an Oracle zone.

What product/language/??? is generating this error and I can see about finding additional zones for you.
0
 

Author Comment

by:pwdells
ID: 36719523
Hmmm...  My teammate said it is an Oracle error.  Please let me reconfirm with him.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36719570
OH, that is a Windows event error.

Oracle error messages have a product designator followed by the error number.

For example:  ORA-00942

>>ADO connection

This tells me it is some app like .Net trying to connect to a database.  I assume in this case Oracle.

>>DB_Lib.SelectQuery

I have no idea what DB_Lib is and who makes it.
0
Technology Partners: 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!

 

Author Comment

by:pwdells
ID: 36719625
Oracle 11, he says.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36719650
>>Oracle 11, he says.

Did you not read my last post?

When I Googled "may be able to use the /AUXSOURCE=" it shows that is a Windows event type message.

Nothing posted points to Oracle as the source of the message.
0
 

Author Comment

by:pwdells
ID: 36719675
Digging a little deeper:

The program was developed in VB 6.0 and is using an ODBC connection to Oracle 11.
0
 

Author Comment

by:pwdells
ID: 36719681
Sorry, the emails are not coming in from EE and I didn't refresh before updating.  Please accept my apologies!
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36719738
>>Please accept my apologies!

Accepted and apology wasn't necessary.

>>The program was developed in VB 6.0 and is using an ODBC connection

That would explain why there really isn't an Oracle error message.

I'll see what other zones might help.
0
 

Author Comment

by:pwdells
ID: 36719742
Thank you slightwv!
0
 

Author Comment

by:pwdells
ID: 36719770
We don't need to close this out, right?
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36719771
OK, back to the question:

Has this app ever worked?
If so, what changed?

If not, it might be a version issue of some type.  I assume it had to run on a test server or at least the development server?
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36719777
>>We don't need to close this out, right?

Correct.

I just added more Zones to allow other Experts in those fields to help.
0
 

Author Comment

by:pwdells
ID: 36719804
The app is working on the original server.  There is a new server that this app is integrating to.

So, it has worked on one server, but not the new server.

Now that Oracle is ruled out, I am checking to see if it is a reference library issue, like I experience frequently in Microsoft Access VBA.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36719848
I've not ruled out Oracle.  Only saying that Oracle isn't the one generating the error and if it is, the application isn't passing the Oracle information along.

It still might be an Oracle issue under the sheets.

>>but not the new server.

check bit versions, product versions, etc... between the old server and the new one.

Make sure what used to be 32Bit is still 32Bit and you aren't trying to mix and match 32 and 64.

Verify what products changed versions.  ODBC requires an Oracle client install.  Did the versions change?

Can you find out if DB_Lib is a 3rd party product?  Maybe it isn't compatible with something new.
0
 

Author Comment

by:pwdells
ID: 36719946
All servers are virtual on the same box.  Would that rule out the bit conflict?  32 vs 64.

DB_Lib.DLL is a 3rd party product developed by someone here at our company.  The source is unknown.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 36720371
>> Would that rule out the bit conflict?  32 vs 64

No.  Each VM has it's own OS.  These can be anything.
0
 

Accepted Solution

by:
pwdells earned 0 total points
ID: 36816035
We increased the MTS (TIME OUT) setting this morning from 15 minutes to 30 minutes.  Now the queries are running and the connections are establishing.  So it is working.  

But we don't know why...
0
 

Author Closing Comment

by:pwdells
ID: 36935280
We increased the MTS (TIME OUT) setting this morning from 15 minutes to 30 minutes.  Now the queries are running and the connections are establishing.  So it is working.  

But we don't know why...
0

Featured Post

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
You can of course define an array to hold data that is of a particular type like an array of Strings to hold customer names or an array of Doubles to hold customer sales, but what do you do if you want to coordinate that data? This article describes…
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Suggested Courses
Course of the Month8 days, 4 hours left to enroll

765 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