[Last Call] Learn about multicloud storage options and how to improve your company's cloud strategy. Register Now

x
?
Solved

Linked server error - SQL 2005 to MAS 90 via ODBC

Posted on 2011-09-13
5
Medium Priority
?
670 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
[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
  • 3
  • 2
5 Comments
 
LVL 17

Accepted Solution

by:
dbaSQL earned 2000 total points
ID: 36542424
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
ID: 36544757
No.  The tables are small (<3000 records)
0
 
LVL 17

Expert Comment

by:dbaSQL
ID: 36544910
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
ID: 36562845
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
ID: 36563002
Glad you found it.
0

Featured Post

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!

Question has a verified solution.

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

by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …
In response to a need for security and privacy, and to continue fostering an environment members can turn to for support, solutions, and education, Experts Exchange has created anonymous question capabilities. This new feature is available to our Pr…

656 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