SEO

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

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

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

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