Advertisement

11.06.2007 at 05:46AM PST, ID: 22941607 | Points: 500
[x]
Attachment Details

MSSQL 2005 Linked Server to Progress v9.1C on Linux throught Merant 3.60 keeps failing

Tags: server, progress, linked, 2005
Hi,

I have added in MSSQL linked server to Progress v9.1C database using such commands:
EXEC sp_addlinkedserver
   @server = 'SAF',
   @srvproduct = '',
   @provider = 'MSDASQL',
   @datasrc = 'SaFmer'
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'SAF',@useself=N'False',@locallogin=NULL,@rmtuser=N'root',@rmtpassword='root_pass'

Connection works fine, I can retrieve and update data.
We start running our application, written in VB.NET, which does all work using that linked server.
Everything works fine, for a while. Then in random time spans, I start getting error:

An error occurred while preparing the query "SELECT bla bla bla ..." for execution against OLE DB provider "MSDASQL" for linked server "SAF".
OLE DB provider "MSDASQL" for linked server "SAF" returned message "[MERANT][ODBC PROGRESS driver][PROGRESS]Server not reachable or possible RPC error"

After few minutes of these errors program "fixes itself", works few minutes fine and again goes back to error messages.

maybe anybody experienced this kind of behaviour and could recommend where start looking for problem or some kind of workaround?
Start your free trial to view this solution
Question Stats
Zone: Database
Question Asked By: subine
Question Asked On: 11.06.2007
Participating Experts: 2
Points: 500
Views: 0
Translate:
Loading Advertisement...
11.07.2007 at 11:13AM PST, ID: 20235197

Rank: Master

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
11.22.2007 at 04:19PM PST, ID: 20336768

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Handhelds / PDAs
  • Displays / Monitors
  • Components
  • Networking Hardware
  • Peripherals
  • Laptops/Notebooks
  • Storage
  • Servers
  • Desktops
  • New Users
  • Misc
  • Apple
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMWare
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMWare
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Community Advisor
  • Lounge
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • Community Advisor
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
11.07.2007 at 11:13AM PST, ID: 20235197

Rank: Master

this has come up before to me some time ago...

its a problem of incompatibility of SQL Server with the ODBC Drivers
provided for the Progress .
I would recommed to contact the Provider for the Progress ODBC Driver  for
further information.


 
11.22.2007 at 04:19PM PST, ID: 20336768
Which SP level does 9.1C has?
What OS is the database running on?
There where many issues with Progress 9.1C and SQL. This is a very old version of Progress.
Upgrade to at least 9.1E04 would help already a lot.
Do you know if there are any errors in the DB log from the Progress database. If you get error 3735 and 2526 then it is a problem which should be fixed in in on e of the following  9.1C servicepacks:
depending on OS:
Compaq Tru64      - 9.1C04
HP-UX 11 64-Bit   - 9.1C01
HP-UX 11          - 9.1C02
IBM AIX           - 9.1C02
RedHat Linux      - 9.1C01
Sun Solaris       - 9.1C02
Sun Solaris Intel - 9.1C03
Unix V.4          - 9.1C04
Win 32            - 9.1C03

Does it help changing the default isolation level to anything but "read uncommitted"?


 
 
20080236-EE-VQP-29 / EE_QW_2_20070628