Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 161189 - Last Review: April 29, 2005 - Revision: 3.1
Error 7008 when using the StarSQL ODBC driver
This article was previously published under Q161189
The following error appears when you try to manipulate a table on an AS/400
using the StarSQL driver included with SNA Server:
Error 7008 [Starware] [Start SQL ODBC Drivers]
[DB2/400] file-name Not Valid for operation [#-7008]
This error occurs when you try to access non-journaled physical files
residing on an AS/400. If you are using the StarSQL driver that is included
with the Microsoft SNA Server, version 2.11, access to non-journaled physical
files on OS/400 V2R3 should work without a problem. The error should occur
only with other versions of OS/400.
For access to non-journaled physical files on OS/400 V3R1 you must edit the
Odbc.ini (16 bit ODBC driver), or the Windows 95 or Windows NT Registry (32
bit ODBC driver) and add the following to the StarSQL data source
description:
IsolationLevel=0
The data source should be deleted and re-added using the ODBC Administrator
for the change to take place properly.
For example, for Windows or Windows for Workgroups (16 bit ODBC Driver), the
ODBC.INI file will look similar to the following:
[STARSQL]
Driver:C:\WINDOWS\SYSTEM\swodbc16.dll
Description=example for v3r1
SERVER=RDBELLE
CatQual=QSYS2
PkgColID=STARSQL
Netlib=SWWAPPC.DLL
ReadOnly=No
LocalLU=SISYPHUS
RemoteLU=ELLE
ModeName=QPCSUPP
AutoTypDefNam=QTDSQL400
UID=PETER
IsolationLevel=0
For Windows NT or Windows 95 (32 bit ODBC Driver), use the Registry Editor
(REGEDT32.EXE or REGEDIT.EXE) to add the following value:
HKEY_CURRENT_USER\Software\ODBC\ODBC.INI\IsolationLevel
Data Type of REG_SZ (NT) or String (Windows 95)
Value of 0 (zero).
The line on Windows NT should appear as: IsolationLevel:REG_SZ:0
The line on Windows 95 should appear as: IsolationLevel "0"
For more information about the IsolationLevel parameter, please refer to
the Advopts.txt file included in the ODBC directory of the corresponding
client.
APPLIES TO
- Microsoft SNA Server 2.0, when used with:
- Microsoft SNA Server 2.1, when used with:
- Microsoft SNA Server 2.11 Service Pack 1, when used with:
- Microsoft SNA Server 2.11 Service Pack 2, when used with:
- Microsoft SNA Server 4.0, when used with:
- Microsoft SNA Server 3.0 Service Pack 2, when used with:
- Microsoft SNA Server 3.0 Service Pack 3, when used with:
- Microsoft SNA Server 3.0 Service Pack 4, when used with:
- Microsoft SNA Server 4.0, when used with:
- Microsoft SNA Server 4.0 Service Pack 1, when used with:
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate