Solved

Linked server error - SQL 2005 to MAS 90 via ODBC

Posted on 2011-09-13
5
658 Views
Last Modified: 2012-05-12
I am using a system dns odbc connection to create a linked server to a MAS90 system.  
The odbc driver is the MAS 90 32-Bit ODBC Driver.
The linked server is named MASDPK.

I have a number of queries and stored procedures.

It is a roll of the dice for it to work.  Often, I can hit the linked server 4 or 5 times in a row with success, and then I will receive this message.  
___________________________________________________________________________
Msg 7399, Level 16, State 1, Procedure UpdateRecipeDescription, Line 10
The OLE DB provider "MSDASQL" for linked server "MASDPK" reported an error. The provider reported an unexpected catastrophic failure.
Msg 7303, Level 16, State 1, Procedure UpdateRecipeDescription, Line 10
Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "MASDPK".
____________________________________________________________________________

The way I can get around it is to close SQL 2005, use net start and stop for the MSSQLSERVER and restart SQL.  Sometimes, if I wait awhile, it will work again on its own.

Everyting is being processed locally on a Server 2003 Service Pack 2.

Is there any way to get this to work consistently?
0
Comment
Question by:Scamquist
  • 3
  • 2
5 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
Comment Utility
http://blogs.msdn.com/b/john_daskalakis/archive/2009/11/13/9921916.aspx
http://bugs.mysql.com/bug.php?id=29242

curious, when it fails, are you working with particularly large datasets?
0
 
LVL 1

Author Comment

by:Scamquist
Comment Utility
No.  The tables are small (<3000 records)
0
 
LVL 17

Expert Comment

by:dbaSQL
Comment Utility
I cannot say for sure, but I think that 7399 is due to an authentication failure.  I know you'd think if that were the case, it would never work, but I have read that this happens with access.  

maybe you could trace it
http://social.msdn.microsoft.com/Forums/en/sqldataaccess/thread/025b012d-82e1-416f-b1b8-00c59cb0ebf5


0
 
LVL 1

Author Closing Comment

by:Scamquist
Comment Utility
One of the links points to a problem with the driver.  I have a feeling the MAS90 ODBC driver may not be 100%.

Thanks for the pointer.
0
 
LVL 17

Expert Comment

by:dbaSQL
Comment Utility
Glad you found it.
0

Featured Post

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

771 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now