Client Access Express ODBC

[GhostWolf]

I'm trying to use CAE ODBC in a new app, (Access to start, convert to VB for production), but am having a slight problem.

Although I've selected "Read/Write (all SQL statements allowed)" in the connection type, I always get a "read only" error message when I issue an update statement against a file.

The user ID I'm using to connect to the '400 has *ALL authority to the files I'm using.

Is there some configuration setting on the '400 I'm missing? Or something else, maybe?!

I'm using CA ODBC Version 8.0.02.00; getting the same results in Access 2000 and 2003.

(NOTE: I've copied this post from IBM Solutions in hopes of getting a response.)

 

[ArtieChoke]

Are you using Access to do the updates with linked tables or ?

"I think we're all Bozos on this bus!" - Firesign Theatre

 

[GhostWolf]

That's the method I'm trying right now.

 

[ArtieChoke]

Access is finicky. You need to set primary/unique keys on each linked table or it won't let you do updates. You probably have to drop the links and reimport them. At that point, it should ask you for a unique key if it can't determine it. Select what makes it unique and you'll be all set.

"I think we're all Bozos on this bus!" - Firesign Theatre

 

[GhostWolf]

Thanks for the tip. I'll give it a try in the morning.

 

[GhostWolf]

Shucks!! No sugar! A little closer though, maybe...

Now I get DB2/400 SQL error "7008 - [FileName] in [LibraryName] not valid for operation." The target file has two key fields; update fails whether one or both are used.

*PUBLIC has *CHANGE authority to both the file and the library; my user ID has *ALL authority.

OS/400 v5r1. Is there something I need to set up on the '400 for this to work?!!
.

 

[GhostWolf]

Found it!!

I was trying to do the testing from my new laptop. It has the XP Home OS - and IBM doesn't support it! (XP Pro's okay, just not Home.)

Set the same queries up on a Win2k desktop, and they ran just fine.

If someone finds a way to get Home to work with CA, I'd sure appreciate hearing about it. I'd hate to have to set this thing up for dual-boot!
.

 

[ArtieChoke]

Unfortunately, you won't be able to do it from XP home, as it doesn't support domain networking - so you can't get authenticated - doh!

"I think we're all Bozos on this bus!" - Firesign Theatre