Nevermind, I found it. Turns out we had set up the ODBC connections
differently. In the set up you must set the SQL Default library to the
library you are working in, I had left mine at QGPL.
Hal McGee
Engineering Data Manager
Group Engineering - Process and Compliance
Seating Products Group
B/E Aerospace
Winston-Salem, NC
[EMAIL PROTECTED]
pace.com
Sent by: To
AccessDevelopers@ [email protected]
yahoogroups.com cc
Subject
09/15/2005 03:06 [AccessDevelopers] SQL0904 with DB2
PM
Please respond to
AccessDevelopers@
yahoogroups.com
I am having an issue pushing data to an AS/400 via ODBC. We have set up the
link to be an active read/write link but each time I try to send the data
via an append query, I get the error message SQL0904. I sent the exact same
database to one of AS/400 operators and it works perfectly for him. Has
anyone run into this before? I can only think it must be a permission or
Client Access set up issue since it works for him and not for me.
Hal McGee
Engineering Data Manager
Group Engineering - Process and Compliance
Seating Products Group
B/E Aerospace
Winston-Salem, NC
Please zip all files prior to uploading to Files section.
YAHOO! GROUPS LINKS
Visit your group "AccessDevelopers" on the web.
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
------------------------ Yahoo! Groups Sponsor --------------------~-->
Most low income households are not online. Help bridge the digital divide today!
http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/q7folB/TM
--------------------------------------------------------------------~->
Please zip all files prior to uploading to Files section.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AccessDevelopers/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
