Solved

Linked server error - SQL 2005 to MAS 90 via ODBC

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

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Need some help wiht :CAST AS Double 11 46
Need help how to find where my error is in UFD 6 30
Sql Server group by 10 30
SQL Error - Query 6 26
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

803 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