Solved

Linked server error - SQL 2005 to MAS 90 via ODBC

Posted on 2011-09-13
5
664 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 500 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

Free eBook: Backup on AWS

Everything you need to know about backup and disaster recovery with AWS, for FREE!

Question has a verified solution.

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

When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
This tutorial will teach you the special effect of super speed similar to the fictional character Wally West aka "The Flash" After Shake : http://www.videocopilot.net/presets/after_shake/ All lightning effects with instructions : http://www.mediaf…

719 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