Re: Update Sql Server 2000 database from the HP3000

P.S. As per other posts we tend to use ODBC drivers - We have a cobol
program that prepares updates for a SQL database and a VB program that
collects those updates via ODBC every 10 or so seconds. Thus we
essentially update the SQL database at the same time as the main
database on the HP - the users don't notice the small delay.

IT depends upon whether you simply want to create a snap-shot of the
original database (use DTS) or whether you want to update the SQL
Database as a result of other updates on the HP.



-----Original Message-----
From: HP-3000 Systems Discussion [mailto:HP3000-L@xxxxxxxxxxxxx] On
Behalf Of Dave Vorgang
Sent: 07 September 2005 16:31
To: HP3000-L@xxxxxxxxxxxxx
Subject: [HP3000-L] Update Sql Server 2000 database from the HP3000

Hi All,

Is there a product that will allow a COBOL program to call subroutines
that will update an Sql Server database?

I am trying to get info on a product called SqlLink3000 but have not
received any. Also, I want to know of other products that are out
there.

Thanks,


Dave Vorgang
Senior (and getting older everyday) Programmer / Analyst
Medford School District - Information Technology
(541) 842-1021
mailto:Dave.Vorgang@xxxxxxxxxxxxxxxxx

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________



The contents of this email are confidential to the intended recipient
and may not be disclosed. Although it is believed that this email and
any attachments are virus free, it is the responsibility of the recipient to confirm this.

Smith & Williamson Corporate Finance Limited - A member of the London Stock Exchange.
A member of M&A International Inc. http://www.mergers.net Registered in England No. 4533970. Authorised and regulated by the Financial Services Authority
Smith & Williamson Investment Management Limited, Registered No. 976145. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Pension Consultancy Limited - Independent Intermediary. Registered No. 3133226. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Fund Administration Limited, Registered No. 1934644. Authorised and regulated by the Financial Services Authority.
Smith & Williamson Limited - A member of Nexia International. Registered in England No. 4534022. Regulated by the Institute of Chartered Accountants in England & Wales for a range of investment business activities.
NCL Investments Limited, Registered No. 1913794.
Member of the London Stock Exchange authorised and regulated by the Financial Services Authority.

Registered Office: 25 Moorgate, London EC2R 6AY
Telephone: 020 7131 4000 http://www.smith.williamson.co.uk

Nexia Audit Limited - A member of Nexia International. Registered in
England No. 4469576. Registered to carry on audit work and regulated by the Institute of Chartered Accountants in England & Wales for a range of investment business activities.

Registered Office: 25 Moorgate, London EC2R 6AY
Telephone: 020 7131 4000 http://www.nexiaaudit.co.uk


______________________________________________________________________
This email has been scanned by the MessageLabs Email Security System.
For more information please visit http://www.messagelabs.com/email
______________________________________________________________________

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

.

Relevant Pages

  • Re: how to move location of default database???? plz!
    ... fine, cool about the database, it probably amounts to how much tagging one ... updates - i woulda rolled them all back. ... No recent version of Windows does ... well when you have less than about 50MB to 100MB of free space. ...
    (microsoft.public.windowsmedia.player)
  • Re: The right database for the job?
    ... Note that "many updates ... > the programmer that have to fix somebody elses code and/or database ... > devices under its control, it connects to a central "DB server" program ...
    (comp.databases)
  • Re: Disk transfers
    ... database software rather than in the application itself) is to capture the change in a relatively small update record in a log - which can be supported effectively in a relatively small amount of NVRAM if performance is important, rather than throwing GB of NVRAM at a generic disk write-back cache, and which in any event can effectively batch many such updates into a single log write if they occur very close to each other - and then later perform the eventual on-disk structural updates lazily, in the background, and possibly in bulk. ... though I'm not sure how the latter would vary all that much (unless you're just referring to the difference between disk and NVRAM performance). ...
    (comp.arch)
  • Re: A different definition of MINUS, Part 3
    ... can actually be the value of the database at any set point in time. ... updates, on the other hand, assert which possible value for the ... neither the algebra nor the calculus are sufficient when it comes to ... To extend the analogy to view updates, we also have an input delta ...
    (comp.databases.theory)
  • Re: Access2k upsizing to SQL2k Automation
    ... Once I manually set the primary keys on two of the ... correctly against the SQL database. ... Upsize Wizard only marks some of the columns 'null'. ...
    (microsoft.public.access.conversion)