Anyone doing ADP with AS400 OLEDB ?

[AlexT]

Well, the title says it all...

I believe it should be possible...

Anyone doing it for "real" ?!

Regards

--alexT

 

[Norman Yuan]

As far as I know, you cannot, at least, not directly. ADP is specifically
designed as SQL Server/MSDE front end, not anything else. Indirectly, you
can create a linked server (link to SQL Server) from AS400, so that the data
from AS400 is supplied to ADP through SQL Server's link. Note, the linking
is done on SQL Server end, not directly on ADP side. So you still need SQL
Server. Thus, the question become why to do that? You can simply use *.mdb
linking to other type of data source than SQK Server.

If in your ADP app (with data mainly from SQL Server), you need to
occassionally get small amount of data from other source than SQL Server,
you can simply write some VBA code, using ADO Connection/Command/Recordset,
to access data on those sources. Or create linked server on the SQL Server
to get data from there.

 

[chakatheapeman]

Access 2003 allows for linked tables

In the query section right click and create a linked table.

I never set up an ODBC connection this way. Be careful, with ADO
know you can actually update that tables. This may also be the cas
with your connection

 

[aaron.kempf]

You can link to AS400 on the server side; it's actually a lot easier to
link in one place instead of in 100 different places (and you only have
to install AS400 drivers on the SQL Server side)

So it's totally doable.

I've done a ton of AS400 MDB work and I know firsthand what a pain it
is.

I personally hate MDB; I thnk that it's too much of a pain to use in a
real world environment.

And I love ADP; I just wish that MS would take them seriously.
I have a list of a dozen bugs in Access ADP and MS wont do anything
about them