Solved

Linked server error - SQL 2005 to MAS 90 via ODBC

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

U.S. Department of Agriculture and Acronis Access

With the new era of mobile computing, smartphones and tablets, wireless communications and cloud services, the USDA sought to take advantage of a mobilized workforce and the blurring lines between personal and corporate computing resources.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SQL - sum months, quarter, YTD 9 91
Compare data between two databases 16 95
Sql Permission 6 52
display data in text field from data base for updating 6 50
I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
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.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

932 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

8 Experts available now in Live!

Get 1:1 Help Now