Feedback

Feedback

Did this article resolve your question/issue?

   

Article

OpenAcess local SDK fails with unexpected catastrophic failure

Printable View

Information

 
TitleOpenAcess local SDK fails with unexpected catastrophic failure
URL Nameopenacess-local-sdk-fails-with-unexpected-catastrophic-failure
Article Number000168445
EnvironmentProduct: Progress DataDirect OpenAccess Local ODBC Client
Version: 8.1
OS: Windows x64
Database: N/A
Application:SQL Server Linked Server
Question/Problem Description

OpenAcess local SDK fails with unexpected catastrophic failure with simple select query like "select * from emp" using SQL Server Linked Server using sample .NET Memory IP, works fine when using with Sample CSV IP.

Steps to Reproduce1. Build sample Memory IP
2. Create System DSN "Test_Link_Server" and make sure it works.
3. Create new linked server in SQL Server Management Console and execute the following query

select * FROM OPENQUERY(NETCSV, 'SELECT * FROM emp')
Clarifying Information
Error MessageThe OLE DB provider "MSDASQL" for linked server "[name]" reported an error. The provider reported an unexpected catastrophic failure.
Defect Number
Enhancement Number
Cause
The issue seemed to be of a mismatch between the accounts for the SQL Server and Microsoft SQL Server Management Studio
Resolution
Following changes to the SQL Server Linked server and the permissions on the SQL Server service fixed the issue

1) Disable "Allow inprocess" option in Server Objects → Linked Servers → Providers → MSDASQL

2) Open the Services app on your windows server
  • Right-click on SQL Server (MSSQLSERVER) and open properties
  • click on "Log On" tab,
  • Change the fields of "This account:" to .\Administrator or the account used to run the sql server service and put password and confirm password for the windows account (Your Password)
  • Restart SQL Server service
Workaround
Notes
Last Modified Date3/12/2020 4:24 PM
Files
Disclaimer The origins of the information on this site may be internal or external to Progress Software Corporation (“Progress”). Progress Software Corporation makes all reasonable efforts to verify this information. However, the information provided is for your information only. Progress Software Corporation makes no explicit or implied claims to the validity of this information.

Any sample code provided on this site is not supported under any Progress support program or service. The sample code is provided on an "AS IS" basis. Progress makes no warranties, express or implied, and disclaims all implied warranties including, without limitation, the implied warranties of merchantability or of fitness for a particular purpose. The entire risk arising out of the use or performance of the sample code is borne by the user. In no event shall Progress, its employees, or anyone else involved in the creation, production, or delivery of the code be liable for any damages whatsoever (including, without limitation, damages for loss of business profits, business interruption, loss of business information, or other pecuniary loss) arising out of the use of or inability to use the sample code, even if Progress has been advised of the possibility of such damages.


Copyright © 2022 Progress Software Corporation and/or its subsidiaries or affiliates.
All Rights Reserved.

Progress, Telerik, Ipswitch, Chef, Kemp, Flowmon and certain product names used herein are trademarks or registered trademarks of Progress Software Corporation and/or one of its subsidiaries or affiliates in the U.S. and/or other countries. See Trademarks for appropriate markings.

Terms of Use Privacy Center Security Center Trademarks License Agreements Code of Conduct Careers Offices
Do Not Sell My Personal Information