| Author |
Message |
Stefan Cuypers
Guest
|
 Posted:
Fri Sep 10, 2004 4:16 am Post subject:
Problem with OLE DB2 provider |
|
|
I've just installed an application that uses the OLE DB2 provider in Host
Integration Server 2004 on a production machine, but it refuses to work. If
I run the Data Access Tool and click on 'Sample Query' an SQL error
HY000 -372 is reported. Does anyone have any idea what could cause this?
I did some further testing and found the following:
- It does not work on 2 Windows Server 2003 machines that previously had SNA
4.0 client installed (which I uninstalled before installing HIS2004 client)
- It does work on a Windows XP Pro SP2 and another Windows Server 2003
machine, both of which never had SNA 4.0 client software installed
I don't know if the previous SNA 4.0 install causes this, but if it does
does anyone have any idea what the uninstall left behind that could cause
the problems?
regards,
Stefan Cuypers |
|
| Back to top |
|
 |
Stefan Cuypers
Guest
|
| Posted:
Fri Sep 10, 2004 5:44 pm Post subject:
Re: Problem with OLE DB2 provider |
|
|
After a couple of hours of debugging into SNA code I located and solved the
problem.
It seems that some code page definitions from
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\CodePage] were
missing (e.g. the 37, which is used by the SNA code).
I suspect the uninstall code from SNA Server 4.0 removes these entries,
which it shouldn't.
Problem got resolved by merging the settings from a working server into the
registry of the non-functioning server.
regards,
Stefan Cuypers
"Stefan Cuypers" <stefan.cuypers@nospam.postalias> wrote in message
news:uAMENMslEHA.3476@tk2msftngp13.phx.gbl...
| Quote: | I've just installed an application that uses the OLE DB2 provider in Host
Integration Server 2004 on a production machine, but it refuses to work.
If
I run the Data Access Tool and click on 'Sample Query' an SQL error
HY000 -372 is reported. Does anyone have any idea what could cause this?
I did some further testing and found the following:
- It does not work on 2 Windows Server 2003 machines that previously had
SNA
4.0 client installed (which I uninstalled before installing HIS2004
client)
- It does work on a Windows XP Pro SP2 and another Windows Server 2003
machine, both of which never had SNA 4.0 client software installed
I don't know if the previous SNA 4.0 install causes this, but if it does
does anyone have any idea what the uninstall left behind that could cause
the problems?
regards,
Stefan Cuypers
|
|
|
| Back to top |
|
|
Neil Pike
Guest
|
| Posted:
Sat Sep 11, 2004 1:32 am Post subject:
Re: Problem with OLE DB2 provider |
|
|
Stefan,
A great bit of debugging! I've seen issues with NLS files/install before, but
this is a new one. (I don't use the DB2 OLEDB driver).
There's no chance of MS fixing the SNA 4 "setup" (Uninstall) code. But maybe
the PSS folks will honor this one with a Kb article....
| Quote: | After a couple of hours of debugging into SNA code I located and solved the
problem.
It seems that some code page definitions from
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\CodePage] were
missing (e.g. the 37, which is used by the SNA code).
I suspect the uninstall code from SNA Server 4.0 removes these entries,
which it shouldn't.
Problem got resolved by merging the settings from a working server into the
registry of the non-functioning server.
|
Neil Pike MVP/MCSE. Protech Computing Ltd
(Please post ALL replies to the newsgroup only unless indicated otherwise) |
|
| Back to top |
|
|
Jeremy Remlinger [MSFT]
Guest
|
| Posted:
Sat Sep 11, 2004 3:54 am Post subject:
Re: Problem with OLE DB2 provider |
|
|
Stefan,
Interesting. I have not see this before. However, plese remember that SNA
4.0 clients are not supported, and have never been tested on Windows 2003
OS. So it is possible that the uninstall does cause some problems that we
have not seen.
I will do some Ad Hoc testing here and see what I can come up with.
Again...great find!
ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸
Jeremy "Rem" Remlinger, MSCE
SNA/HIS Engineer
Microsoft
This posting is provided 'AS IS' with no warranties, and confers no rights.
© 2004 Microsoft Corporation. All rights reserved.
ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸
--------------------
From: "Stefan Cuypers" <stefan.cuypers@nospam.postalias>
References: <uAMENMslEHA.3476@tk2msftngp13.phx.gbl>
Subject: Re: Problem with OLE DB2 provider
Date: Fri, 10 Sep 2004 14:44:04 +0200
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.181
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
Message-ID: <#sGVePzlEHA.3896@TK2MSFTNGP15.phx.gbl>
Newsgroups: microsoft.public.hiserver.general
NNTP-Posting-Host: d576ae10.kabel.telenet.be 213.118.174.16
Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15
.phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.hiserver.general:4106
X-Tomcat-NG: microsoft.public.hiserver.general
After a couple of hours of debugging into SNA code I located and solved the
problem.
It seems that some code page definitions from
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\CodePage] were
missing (e.g. the 37, which is used by the SNA code).
I suspect the uninstall code from SNA Server 4.0 removes these entries,
which it shouldn't.
Problem got resolved by merging the settings from a working server into the
registry of the non-functioning server.
regards,
Stefan Cuypers
"Stefan Cuypers" <stefan.cuypers@nospam.postalias> wrote in message
news:uAMENMslEHA.3476@tk2msftngp13.phx.gbl...
| Quote: | I've just installed an application that uses the OLE DB2 provider in Host
Integration Server 2004 on a production machine, but it refuses to work.
If
I run the Data Access Tool and click on 'Sample Query' an SQL error
HY000 -372 is reported. Does anyone have any idea what could cause this?
I did some further testing and found the following:
- It does not work on 2 Windows Server 2003 machines that previously had
SNA
4.0 client installed (which I uninstalled before installing HIS2004
client)
- It does work on a Windows XP Pro SP2 and another Windows Server 2003
machine, both of which never had SNA 4.0 client software installed
I don't know if the previous SNA 4.0 install causes this, but if it does
does anyone have any idea what the uninstall left behind that could cause
the problems?
regards,
Stefan Cuypers
|
|
|
| Back to top |
|
|
John Chambers
Guest
|
| Posted:
Mon Sep 13, 2004 7:41 pm Post subject:
Re: Problem with OLE DB2 provider |
|
|
FYI, I have experienced an issue like this after uninstalling the SNA 4.0
Client on Windows XP machines. This problem caused display issues with
Internet Explorer. Specifically, the following needs to be added back in
Under the key
HKLM\SYSTEM\CurrentControlSet\Control\Nls\Codepage
Add the string value
28591 = c_28591.nls
John Chambers
"Jeremy Remlinger [MSFT]" <jeremyr@online.microsoft.com> wrote in message
news:dq154k4lEHA.1156@cpmsftngxa10.phx.gbl...
Stefan,
Interesting. I have not see this before. However, plese remember that SNA
4.0 clients are not supported, and have never been tested on Windows 2003
OS. So it is possible that the uninstall does cause some problems that we
have not seen.
I will do some Ad Hoc testing here and see what I can come up with.
Again...great find!
ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸
Jeremy "Rem" Remlinger, MSCE
SNA/HIS Engineer
Microsoft
This posting is provided 'AS IS' with no warranties, and confers no rights.
© 2004 Microsoft Corporation. All rights reserved.
ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸
--------------------
From: "Stefan Cuypers" <stefan.cuypers@nospam.postalias>
References: <uAMENMslEHA.3476@tk2msftngp13.phx.gbl>
Subject: Re: Problem with OLE DB2 provider
Date: Fri, 10 Sep 2004 14:44:04 +0200
Lines: 39
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.181
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.181
Message-ID: <#sGVePzlEHA.3896@TK2MSFTNGP15.phx.gbl>
Newsgroups: microsoft.public.hiserver.general
NNTP-Posting-Host: d576ae10.kabel.telenet.be 213.118.174.16
Path:
cpmsftngxa10.phx.gbl!TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!TK2MSFTNGP15
phx.gbl
Xref: cpmsftngxa10.phx.gbl microsoft.public.hiserver.general:4106
X-Tomcat-NG: microsoft.public.hiserver.general
After a couple of hours of debugging into SNA code I located and solved the
problem.
It seems that some code page definitions from
[HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\CodePage] were
missing (e.g. the 37, which is used by the SNA code).
I suspect the uninstall code from SNA Server 4.0 removes these entries,
which it shouldn't.
Problem got resolved by merging the settings from a working server into the
registry of the non-functioning server.
regards,
Stefan Cuypers
"Stefan Cuypers" <stefan.cuypers@nospam.postalias> wrote in message
news:uAMENMslEHA.3476@tk2msftngp13.phx.gbl...
| Quote: | I've just installed an application that uses the OLE DB2 provider in Host
Integration Server 2004 on a production machine, but it refuses to work.
If
I run the Data Access Tool and click on 'Sample Query' an SQL error
HY000 -372 is reported. Does anyone have any idea what could cause this?
I did some further testing and found the following:
- It does not work on 2 Windows Server 2003 machines that previously had
SNA
4.0 client installed (which I uninstalled before installing HIS2004
client)
- It does work on a Windows XP Pro SP2 and another Windows Server 2003
machine, both of which never had SNA 4.0 client software installed
I don't know if the previous SNA 4.0 install causes this, but if it does
does anyone have any idea what the uninstall left behind that could cause
the problems?
regards,
Stefan Cuypers
|
|
|
| Back to top |
|
|
Stefan Cuypers
Guest
|
| Posted:
Tue Sep 14, 2004 5:34 am Post subject:
Re: Problem with OLE DB2 provider |
|
|
I've indeed experienced this problem with IE to after experimenting with
SNA, but I did not make the link to SNA back then.
The main reason I had SNA 4.0 running on Windows 2003 was that I was
convinced there was a problem between HIS 2000 and our AS/400 and I did not
have the time to figure this out. (And indeed SNA 4.0 does not work reliably
under Win2003, it crashes under pressure).
A while ago I uninstalled SNA 4.0 on a test machine (running Windows XP Pro)
and installed HIS 2000 and could not get the OLE DB2 driver to work. I
uninstalled the HIS2000 and reinstalled SNA 4.0 and that didn't work either.
(I never got SNA to work on that machine again).
I hoped HIS2004 would solve these problems, so I installed it on a test
machine (a reformatted Windows XP Pro that has never seen SNA 4.0) and it
worked fine. I then installed HIS2004 on a Win2003 test machine in a virtual
PC where it worked fine to. But when moving to the production server it
failed, forcing me into debug mode.
A KB article about this would be nice since it would have saved me a lot of
time.
Stefan
"John Chambers" <JohnC@test01.com> wrote in message
news:OS$N9#ZmEHA.3520@TK2MSFTNGP11.phx.gbl...
| Quote: | FYI, I have experienced an issue like this after uninstalling the SNA 4.0
Client on Windows XP machines. This problem caused display issues with
Internet Explorer. Specifically, the following needs to be added back in
Under the key
HKLM\SYSTEM\CurrentControlSet\Control\Nls\Codepage
Add the string value
28591 = c_28591.nls
John Chambers
"Jeremy Remlinger [MSFT]" <jeremyr@online.microsoft.com> wrote in message
news:dq154k4lEHA.1156@cpmsftngxa10.phx.gbl...
Stefan,
Interesting. I have not see this before. However, plese remember that
SNA
4.0 clients are not supported, and have never been tested on Windows 2003
OS. So it is possible that the uninstall does cause some problems that we
have not seen.
I will do some Ad Hoc testing here and see what I can come up with.
Again...great find!
ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸
Jeremy "Rem" Remlinger, MSCE
SNA/HIS Engineer
Microsoft
This posting is provided 'AS IS' with no warranties, and confers no
rights.
© 2004 Microsoft Corporation. All rights reserved.
ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸
|
|
|
| Back to top |
|
|
CLS
Guest
|
| Posted:
Wed Sep 29, 2004 12:57 pm Post subject:
Re: Problem with OLE DB2 provider |
|
|
I've just installed an application that uses the OLE DB2 provider in Host(
os/390)
Integration Server 2004 and 2000. I receive strange characters in SQLstate
while the SQLcode is OK when there is DB2 error. For ex. SQLstate : ôò÷ó
Sqlcode : -204
Why??
Thanks
Claudio |
|
| Back to top |
|
|
cmurialdo
Guest
|
| Posted:
Fri Oct 08, 2004 12:17 am Post subject:
Re: Problem with OLE DB2 provider |
|
|
I have the same problem with Data Access Tool on 'Sample Query' and with the
Managed Client for DB2 Sample too:
"SQL error ocurred. SQLSTATE: HY000, SQLCODE: -372".
I installed HIS (2004) for first time (on windows XP SP2).
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\CodePage\31 there is
in the registry.
Any ideas? |
|
| Back to top |
|
|
Neil Pike
Guest
|
| Posted:
Sat Oct 09, 2004 12:40 am Post subject:
Re: Problem with OLE DB2 provider |
|
|
Use NTREGMON (www.sysinternals.com) to see what particular key it's looking
for that isn't there.
| Quote: | I have the same problem with Data Access Tool on 'Sample Query' and with the
Managed Client for DB2 Sample too:
"SQL error ocurred. SQLSTATE: HY000, SQLCODE: -372".
I installed HIS (2004) for first time (on windows XP SP2).
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Control\Nls\CodePage\31 there is
in the registry.
Any ideas?
|
Neil Pike. Protech Computing Ltd
(Please post ALL replies to the newsgroup only unless indicated otherwise) |
|
| Back to top |
|
|
cmurialdo
Guest
|
| Posted:
Sat Oct 09, 2004 2:35 am Post subject:
Re: Problem with OLE DB2 provider |
|
|
Neil:
I tried with NTRegmon but I don't see anything strange. The only thing is
that it doesn't find some keys, but that same thing happens in the DB2 UDB
example that's working fine.
Did you try the "Managed Client for DB2 Sample with as400" ?.
I followed it and I can connect to as400, but the "Open RS" throws the
following exception "SQL error occurred. SQLSTATE: HY000, SQLCODE:
-372" or sometimes "Internal network library error".
The sample works fine with DB2 UDB, but doesn´t work with as400.
I tried the example with :
1. "Microsoft OLE DB Provider for as/400 and VSAM"
2. An .udl file that I defined with the Data Access Tool of Host integration
Server
3. "Microsoft OLE DB Provider for DB2"
and in all 3 cases I get the same error. |
|
| Back to top |
|
|
Neil Pike
Guest
|
| Posted:
Sat Oct 09, 2004 7:23 pm Post subject:
Re: Problem with OLE DB2 provider |
|
|
Unfortunately I don't have AS400 or DB2 access to try it out on at the moment.
You'll need to raise a case with MS PSS to get it resolved methinks.
| Quote: | I tried with NTRegmon but I don't see anything strange. The only thing is
that it doesn't find some keys, but that same thing happens in the DB2 UDB
example that's working fine.
Did you try the "Managed Client for DB2 Sample with as400" ?.
I followed it and I can connect to as400, but the "Open RS" throws the
following exception "SQL error occurred. SQLSTATE: HY000, SQLCODE:
-372" or sometimes "Internal network library error".
The sample works fine with DB2 UDB, but doesn´t work with as400.
I tried the example with :
1. "Microsoft OLE DB Provider for as/400 and VSAM"
2. An .udl file that I defined with the Data Access Tool of Host integration
Server
3. "Microsoft OLE DB Provider for DB2"
and in all 3 cases I get the same error.
|
Neil Pike. Protech Computing Ltd
(Please post ALL replies to the newsgroup only unless indicated otherwise) |
|
| Back to top |
|
|
cls
Guest
|
| Posted:
Wed Dec 29, 2004 3:39 pm Post subject:
RE: Problem with OLE DB2 provider (HIS2004) |
|
|
I've just installed an application that uses the OLE DB2 provider in Host.
During an update on the table (single row) DB2 HOST/os390 I have :
sqlstate: HY000
sqlcode: 7343
Why??
Thanks CLS |
|
| Back to top |
|
|
cls
Guest
|
| Posted:
Wed Dec 29, 2004 3:43 pm Post subject:
Problem with OLE DB2 provider HIS2004 |
|
|
I've just installed an application that uses the OLE DB2 provider in Host
Integration Server 2004. When there is an update after a select on the same
row with a table DB2 HOST/OS390 I have an error:
sqlstate:HY000
sqlcode : 7343
Why
Thanks CLS |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in