471,887 Members | 1,385 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,887 software developers and data experts.

All linked DB2 tables viewable on 390, but only some are viewable after migration to AIX and v8

Hello and thanks for taking the time to read this. I've looked all
over the web and newsgroups and can't find a solution to my problem.
Since the source of the data is DB2, I figured I'd give you guys a try
as well!

Back ground:
User at remote site has Access 2000 running on XP (don't know SP of
either). Linked tables are DB2 v8 running on AIX. All of the linked
tables are in the same database and schema.

Some linked tables, when viewed in datasheet form from within Access,
display "#NAME?"; others do not. This problem started right afer the
database was migrated from 390 to AIX.

Things I've tried:
All obvious connectivity related trouble shooting (the server and DB
can be seen from IBM DB2 Configuration assistant and Putty, the DSN is
registered ODBC, etc.) Results: nothing out of the ordinary.

Reinstalled Msowfc.dll as suggested in KB article(not sure I spelled it

correctly here, but you get the picture) Results: no effect

Checked connection string using this command typed in the Immediate
Window: ?dbengine(0)(0).TableDefs("CAP_UFPWK_DPTMDSC_SLSST K").Connect
Results: Thought I had something here when one of the connection
strings was returned with the user's current ID, but an old password.
Had the user delete the linked table in Access (highlighting and
pressing delete key) and then set up the linked table again. Now all
connection strings are the same

I'm stuck! Anyone have similar problems? Anyone have a suggestion on
how to fix? Thanks in advance for your help!

Nov 12 '05 #1
0 1063

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Robert McGregor | last post: by
4 posts views Thread by Neil Ginsberg | last post: by
10 posts views Thread by Jim Devenish | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.