Hello again.
There is one more thing:
When I run application from VB environment everything is OK but if I
compile a new executable and run, it is not!
I have checked many configuration and options in ODBC settings and
noticed that application (no matter if its started from .exe or VB)
works correctly until "Commit Mode" <> "Commit immediate".

For "Read uncommitted (*CHG)", "Read committed (*CS"), "Repeatable
Read (*RR)" it's OK.

Have you any ideas?
PS. I found in Windows Registry a parameter:
"Packagevb5"="QGPL/VB5(VBA),2,0,1,0,512 ; *CHG"

Do you know what does "(VBA)" stands for?
Sometimes there is (VBA) or (FBA) or (FRA)...

Best regards,
Krzysiek

krzysiek_bl@tlen.pl (Krzysiek) wrote in message news:<e11342f0.0310160335.68a3e1b@posting.google.c om>...
> Hello
> Unfortunatelly it did not help...
> Krzysiek
>
> "Grup ANTAIX S.A." <antaix@antaix.com> wrote in message news:<3F864EE5.25ED3F40@antaix.com>...
> > In the ODBC, you need to put that the driver converts de CCSID 65535 (by
> > default it is not activated).
> > Try it
> >
> > Krzysiek escribió:
> >
> > > Dear All
> > > I have very strange situation with ODBC settings.
> > > I support application (VB) dealing with db on AS400.
> > >
> > > Some time ago I installed Client Access v4.4 and then I created ODBC
> > > data source to 'link' LIB_1 on AS and everything worked fine.
> > >
> > > Yesterday I have migrated CA to v5.1 and still everything was OK.
> > > But!
> > > Today I removed mentioned ODBC data source settings (for some
> > > important reason) and created it again.
> > > Unfortunately now I get bad-mixed data in the application.
> > >
> > > I have search win2k registry - ODBC setting and compared it with other
> > > PC where application works correctly (because there is still CA v4.4)
> > > and there were differences.
> > > I thought that modifying registry to set these settings/parameters on
> > > PC with CA5.1 as they are on PC with CA4.4 would help. But I was
> > > wrong!
> > > Now registry same connection looks the same and application still does
> > > not work properly.
> > >
> > > I have another ODBC setting on PC with CA5.1 to the LIB_2 (which is
> > > exact copy of LIB_1) and everything works fine – I think just
> > > because these setting were defined when there was CA 4.4 and after
> > > installing CA5.1 were not recreated.
> > >
> > > Registry looks this way:
> > >
> > > [HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI\ABCDB_02]
> > > "Driver"="C:\\Program Files\\IBM\\Client Access\\Shared\\cwbodbc.dll"
> > > "Description"="02: Server Datasource"
> > > "System"="AS4001"
> > > "CommitMode"="2"
> > > "MaxFieldLength"="32"
> > > "DefaultLibraries"="ABCDB02,ABCGM30P,QGPL"
> > > "SearchPattern"="1"
> > > "ManagedDataSource"="0"
> > > "ExtendedDynamic"="1"
> > > "DefaultPkgLibrary"="QGPL"
> > > "LazyClose"="1"
> > > "PreFetch"="0"
> > > "AllowDataCompression"="0"
> > > "RecordBlocking"="2"
> > > "BlockSizeKB"="32"
> > > "LibraryView"="0"
> > > "SortSequence"="0"
> > > "SortTable"=""
> > > "SortWeight"="0"
> > > "LanguageID"="ENU"
> > > "AllowUnsupportedChar"="0"
> > > "ConnectionType"="0"
> > > "ODBCRemarks"="0"
> > > "AlwaysScrollable"="0"
> > > "ForceTranslation"="0"
> > > "TranslationDLL"=""
> > > "TranslationOption"=""
> > > "CCSID"=""
> > > "Naming"="0"
> > > "DateFormat"="5"
> > > "DateSeparator"="1"
> > > "TimeFormat"="0"
> > > "TimeSeparator"="0"
> > > "Decimal"="0"
> > > "PackageMSACCESS"="QGPL/MSACCES(VBA),2,0,1,0,512 ; *CHG"
> > > "Packageposmain"="QGPL/ABCMAIN(VBA),2,0,1,0,512 ; *CHG"
> > > "Packagevb5"="QGPL/VB5(VBA),2,0,1,0,512 ; *CHG"
> > >
> > > My questions are:
> > > 1. Why application works improperly just after recreating ODBC
> > > settings?
> > > 2. Are there any hidden parameters of CA (in registry on somewhere
> > > else on PC) that cause problem in my situation?
> > >
> > > Thanks in advanced for any help.
> > >
> > > Krzysiek