× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



MS Access is a desktop application NOT an enterprise database server. If
you were using SQLServer DECS could connect to that.

If you need to connect to a desktop application NOTESSQL is the correct
tool for the job.


Walter Scanlan
Senior Software Engineer
WPLC products for IBM i for Power Systems including AS/400, iSeries and
System i
507-286-6088
Cell: 507-990-4539
wscanlan@xxxxxxxxxx





From:
gregg.eldred@xxxxxxxxxxx
To:
domino400@xxxxxxxxxxxx
Date:
06/04/2008 09:51 AM
Subject:
DECS and SQL/Access




All of our connections between Domino, DB2, and MS Access are done using
DECS.

We have an Access DB on a Windows server, and are having issues using DECS
to move data directly between DB2 on the iSeries and the Access DB. The
DSN
has been created, but it is on the Windows server.

Moving data between Notes and Access and Notes and DB2 are handled quite
well using DECS. However, the same is not true of a direct DECS Connection
from Access to DB2. Is that possible? Are there any pointers/reference
material to get DECS to move data between the Access DB and DB2 on the
iSeries?

Or am I supposed to use LEI or similar? I'd like to keep using DECS, if I
can.

Thanks.

Gregg


_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (Domino400) mailing list
To post a message email: Domino400@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/domino400
or email: Domino400-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.