AS400 ODBC probs in Vista U64

**ps3cheats** · 15-Mar-2007, 01:37 AM

Question: ODBC to an AS400 generates an SQL7008 error for update queries.

The exact settings work on and XP machine, but not on a Vista Ultimate machine.

ODBC Settings:
Naming convention SQL with conneciton type read/write all sql statements
Under advanced commit mode I've tried immediate, committed and uncommited.

I'm using Vista Ultimate 64 bit. (I wanted to cause myself and many problems as possible before I go live with Vista in the corp)

**ps3cheats** · 15-Mar-2007, 01:37 AM

Have you checked IBM's iSeries Access site to make sure you have the latest PTF applied to support Vista?
Microsoft Windows Operating Systems and iSeries Access

Looks like it is V5R4M0 with service pack PTF SI25949 or later for Vista Ultimate/Business Editions.

15-Mar-2007, 01:37 AM	#1 (permalink)
ps3cheats Fixed Error! Posts: 1,497 Join Date: Mar 2007 Rep Power: 3 IM:	AS400 ODBC probs in Vista U64 Question: ODBC to an AS400 generates an SQL7008 error for update queries. The exact settings work on and XP machine, but not on a Vista Ultimate machine. ODBC Settings: Naming convention SQL with conneciton type read/write all sql statements Under advanced commit mode I've tried immediate, committed and uncommited. I'm using Vista Ultimate 64 bit. (I wanted to cause myself and many problems as possible before I go live with Vista in the corp)

15-Mar-2007, 01:37 AM	#2 (permalink)
ps3cheats Fixed Error! Posts: 1,497 Join Date: Mar 2007 Rep Power: 3 IM:	Re: AS400 ODBC probs in Vista U64 Have you checked IBM's iSeries Access site to make sure you have the latest PTF applied to support Vista? Microsoft Windows Operating Systems and iSeries Access Looks like it is V5R4M0 with service pack PTF SI25949 or later for Vista Ultimate/Business Editions.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)