Re: MCP and SQL

More specifically, the product is Application Data Access which provides an
ODBC like interface for COBOL, ALGOL or C to any Windows database that
provides an ODBC driver interface. Unfortunately, the ODBC API is somewhat
complex.

DMSQL provides the SQL CLI interface, which is also very similar to the ODBC
API, but only interfaces to a local DMSII or SQL database. The
documentation for the DMSQL interface is much betted than the Application
Data Access.


<kheinze@xxxxxxxxxxxxx> wrote in message
news:1185359136.977487.158100@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


On Jul 25, 5:18 am, Edward Reid <edw...@xxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
Yeah, I know about DMSQL. But I need the other way around. DMSQL gives
you a SQL view of a DMSII database. What solutions have people come up
with for accessing SQL databases from MCP programs?

What I need is light-weight -- probably just access to a couple of
small
tables.

If I only needed to update them, I could probably use DATAbridge -- it
is
installed at the site in question. But I need to read and write.

Obviously I could set up a protocol and implement an interface
program, but
that's a lot of work for a light-weight requirement. Or I could just
send a
table as a CSV file and send it back later, but that's ... ugly.

Am I missing some MCP tool that can deal with MS SQL Server port 1433
protocol?

How would you do it?

Edward
--
Art Works by Melynda Reid:http://paleo.org

Hi Edward

I have only read about what you are looking for but in the Unisys Docs
they speak of HDBC (That is Host Data Base Connect) to connect eg. a
COBOL program to a Database external to the MCP.

The "Unisys Integration Expert" CD even has an example.

Hope this helps.

Regards
Karl Heinze

karl dot heinze at gijima dot NOTHIS dot com.



.

Relevant Pages

  • Re: Sybase Source. What "data flow source" to use?
    ... "Allan Mitchell" wrote: ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
    (microsoft.public.sqlserver.dts)
  • Re: Sybase Source. What "data flow source" to use?
    ... when I right-click over a SQL 2005 ... database and select Import Data, the list of providers does not include ... either A) the list of datasources defined in ODBC Datasources on my computer, ... I've been so excited about SSIS and telling my co-workers how ...
    (microsoft.public.sqlserver.dts)
  • Re: Sybase Source. What "data flow source" to use?
    ... but could still use DTS to move data. ... when I right-click over a SQL 2005 database and select Import ... datasources defined in ODBC Datasources on my computer, ...
    (microsoft.public.sqlserver.dts)
  • RE: Linking to an SQL Database
    ... registry entry to change the JET engine ODBC Table ... >|>| When linking to a SQL database through MS Access ... >|>| database it connects to has been upgrade to an SQL ...
    (microsoft.public.access.externaldata)
  • Re: Can I use my data source from SQL
    ... Which "SQL" database? ... connection using ODBC and MS Query, or using the VBA OpenDatasource method. ... Data Source dialog box. ...
    (microsoft.public.word.mailmerge.fields)