Re: ODBC Access?

["Steve Landess" <sjl_abc@xxxxxxxxxxx>]

Dave -

Do you have any columns in the Access table containing null values?
If the corresponding fields in the AS/400 file don't allow nulls,
you will encounter this error.

I had a similar problem when uploading data from an Access table,
and I wrote a VB function that I used in my Select statement
within the Access database to substitute blanks for nulls in alpha fields
and zeros for nulls in numeric fields.

Steve

----- Original Message ----- 
From: <>
To: <midrange-l@xxxxxxxxxxxx>
Sent: Thursday, December 02, 2004 10:04 AM
Subject: ODBC Access?


>
>
>
>
> Can anybody tell me what I need to change on the iSeries to accept an ODBC
> upload from a MS-Access database?  I can open the file in Access as a
> link-table but if I try to add to it I get a message that reads
> "ODBC--insert on linked table 'DPLIB_EXTRACT' failed.
>
> This is a one-shot project so in the interest of security anything that
> turn on I can turn off once it's done.  Thanks.
>
> Dave Parnin
> Nishikawa Standard Company
> Topeka, IN  46571
> daparnin@xxxxxxxxxxxxxxxxxx
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
>