dbTalk Databases Forums  

Want to access SQL Server from Ingres (reposted from Tojo)

comp.databases comp.databases


Discuss Want to access SQL Server from Ingres (reposted from Tojo) in the comp.databases forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Roy Hann
 
Posts: n/a

Default Want to access SQL Server from Ingres (reposted from Tojo) - 10-08-2007 , 08:37 AM






Quote:
Some background information I have two systems one Windows plattform
with an MFC application using SQL Server database and an OpenVMS
plattform with an Ingres 4GL application using an Ingres database.

This Ingres version is character based running on an OpenVMS Plattform.
The application is based on forms and events is based on functionkey
like F12, F13 and so on. The mouse can't be used in this Ingres version.
when I did select _version() is said 6.4/06 (vax.vms/00) The version on
SQL Server 2000 is 8.00.194

Both systems are located on the same Ethernet LAN.

My actual question is the following: I want to be able to access the SQL
Server database directly from my Ingres 4GL application. This might be
impossible.

Then my next question is if it's possible to access SQL Server from a
separate process running on OpenVMS written in C?

So what alternatives are there to access an SQL Server database from
OpenVMS plattform.

I also want to access Ingres from MFC but this is not a problem because
it's possible to access the Ingres database from MFC using Ingres/Net.

//Tony
I expect that VAX is probably pretty mature, to say the least. Last year we
migrated a complex government ABF application from Ingres 6.4 on a VAX to
Ingres 2006 on a bottom-of-the-range Dell server, for less than the cost of
year's maintenance, and gave them a ten-fold boost in performance into the
bargain plus disk-level replication to a standby system. ABF is highly
portable with very minimal effort even porting between platforms as
dissimilar as VMS and Windows. It really was very easy--the hard part was
that the original developers had no source code control system and three or
four variants of every source module. You won't have that problem I am
sure! ;-)

Once you get off the VAX and onto a Windows platform (and stop hemorrhaging
money to look after the VAX), it should be pretty easy to integrate with MS
SQL Server. It would certainly be no harder and probably much easier than
messing around with Enterprise Access Gateways. The gateways mostly work,
but they are an operational hassle and they always end up giving me a bad
scare every time I've deployed one. I sure wouldn't commit to spend money
on one before proving it works in its intended role.

Roy




Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.