FIX: ????? ??? ??? ????? ????? SQL ???????? ???? OLE DB DB2: "SQLSTATE 22007 SQLCODE-181"

?????? ????????? ?????? ?????????
???? ???????: 924599 - ??? ???????? ???? ????? ????? ??? ???????.
????? ???? | ?? ????

?? ??? ??????

???????

???? ??? ????????? ??????. ?? ?????? ???? SQL ???????? ???? Microsoft OLE DB DB2. ????? SQL ?????? ????? datetime Microsoft SQL Server ??? ???? ????? ?????? IBM DB2. ???? ????? ?????? IBM DB2 ?????? ??? ???????? DATE IBM DB2. ?? ??? ?????????? ?? ????? ????? ????? ???????:
22007 SQLSTATE: SQLCODE:-181
??? ???? ??????? ????? SQL ??????? ?????? ????? datetime SQL Server ??? ???? ????? ?????? IBM DB2.
declare @var1 datetime
set @var1 = '2006-09-27 00:00:00.000'
SELECT COL1, COL2, COL3
FROM IBMDB2.TESTDATA.USER1.TABLE1
WHERE COL2 = @var1
?? ??? ??????? ???? ??? ??????? ??? ??? ?????? COL2 ?????? ??? ???????? DATE IBM DB2.

?????

?? ??? ??????? "? ???? OLE DB ?? DB2 ?? ???? ??? ?????? IBM DB2 ?????? ????? ????? ?????? IBM DB2 ??? ????? ??????? datetime SQL Server. ?????? ????? ???? OLE DB ?? DB2 ??????? ??????? ???????? ????? ?? ???? ???? ?????? ???? OLE DB ?? DB2 ??? ????? ?????? IBM DB2. ??????? ??? ??? ???? ???? ???????? DATE IBM DB2. ?????? ???? ????? ????? ???????? ?? ??? "???????".

????

????? ?????? Microsoft Server 2006

??? ??? ???????? ??? ?????? ??? ???? ???? ???? ?? "???? Server ????? ??????". ????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft" (????? ?? ??? ???????? ??? ???? ?? ???? ??????? ??? ?? ??? ??? ?????? ??????????):
979497????? ?????? ??? ???? ???? ???? ?????? ????? Server 2006

????? ?????? Microsoft Server 2004

????? ????? ???? ????? ?? Microsoft. ???? ????? ??? ?? ?? ??????? ??????? ?? ??? ???????. ????? ??? ??????? ?????? ??? ??? ??????? ???? ????? ??? ??????? ????????. ?? ??? ????? ???????? ?????? ??? ??? ??????? ??????. ?????? ??? ?? ??? ????? ??? ??????? ??????? ???? ????????? ??? ??????? ?????? ?? ????? ???????? ???? ????? ??? ??? ??????? ??????.

?? ???? ???? ????? ??????? ?????? ???? ??? "???? ????? ??????? ????" ???? ????? ????? ???????. ??? ?? ???? ??? ?????? ???? Microsoft ???? ??????? ?????? ?????? ??? ??????? ??????.

?????? ???? ?????? ?????? ?? ??????? ??? ????? ?? ???? ????? ????? ??? ???? ?????. ???? ????? ?????? ????? ???????? ??? ????? ????? ???????? ????????? ???? ?? ???? ??? ???? ??? ??????? ?????? ????????. ?????? ????? ????? ?????? ????? Microsoft ???? ??????? ?????? ?????? ????? ?? ?????? ??? ???? ????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://support.microsoft.com/contactus/?ws=support
?????? ???? ????? "???? ????? ??????? ??????" ?????? ???? ????? ??????? ??????. ??? ?? ????? ????? ?????? ??? ???? ??? ???? ?? ????? ????? ???? ???? ?????.

??????? ?????

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "???? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ?????? "??????? ??????" ?? "???? ??????.
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????????? ???? ??????
Db2oledb.dll6.0.2048.0488,96003 ?????? ??????: ??x 86???? ??????
Db2oledb.h??? ?????24,57903 ?????? ????17: 36??? ????????? ??????
Ddmstr.dll6.0.2048.044,03203 ?????? ??????: ??x 86???? ??????
Drdaresync.exe6.0.2048.0337,40803 ?????? ????17: 32x 86???? ??????
Microsoft.hostintegration.dataaccesslibrary.dll6.0.2048.086,01603 ?????? ??????: ??x 86???? ??????
Microsoft.hostintegration.dataaccesstool.exe6.0.2048.02,703,36003 ?????? ????17: 32x 86???? ??????
Microsoft.hostintegration.msdb2client.dll6.0.2048.0114,68803 ?????? ??????: ??x 86???? ??????
Mseidb2c.dll6.0.2048.071,68003 ?????? ??????: ??x 86???? ??????
Mseidb2d.dll6.0.2048.0435,20003 ?????? ??????: ??x 86???? ??????
Mseidrda.dll6.0.2048.0695,80803 ?????? ????17: 32x 86???? ??????
?????? ???? ?????? ?????? ??????? ?????? ?????? ???? ????? ??? ??? ??????? ?? ????? ????? ??? ????? ??????.

???? Microsoft OLE DB DB2 ??????? 1.0

????? ????? ???? ????? ?? Microsoft. ???? ????? ??? ?? ?? ??????? ??????? ?? ??? ???????. ????? ??? ??????? ?????? ??? ??? ??????? ???? ????? ??? ??????? ????????. ?? ??? ????? ???????? ?????? ??? ??? ??????? ??????. ?????? ??? ?? ??? ????? ??? ??????? ??????? ???? ????????? ??? ??????? ?????? ?? ????? ???????? ???? ????? ??? ??? ??????? ??????.

?? ???? ???? ????? ??????? ?????? ???? ??? "???? ????? ??????? ????" ???? ????? ????? ???????. ??? ?? ???? ??? ?????? ???? Microsoft ???? ??????? ?????? ?????? ??? ??????? ??????.

?????? ???? ?????? ?????? ?? ??????? ??? ????? ?? ???? ????? ????? ??? ???? ?????. ???? ????? ?????? ????? ???????? ??? ????? ????? ???????? ????????? ???? ?? ???? ??? ???? ??? ??????? ?????? ????????. ?????? ????? ????? ?????? ????? Microsoft ???? ??????? ?????? ?????? ????? ?? ?????? ??? ???? ????? ?? ?????? ???? Microsoft ?????? ??? ?????:
http://support.microsoft.com/contactus/?ws=support
?????? ???? ????? "???? ????? ??????? ??????" ?????? ???? ????? ??????? ??????. ??? ?? ????? ????? ?????? ??? ???? ??? ???? ?? ????? ????? ???? ???? ?????.

??????? ?????

????? ????? ????? ?????????? ?? ??? ??????? ?????? ???? ????? (?? ???? ????) ??????? ?? ?????? ??????. ??? ??? ???????? ???????? ?????? ???? ??????? ?? "???? ??????? ???????" (UTC). ????? ???? ???? ??????? ?????? ??? ??????? ??? ??????? ??????. ?????? ????? ??? ??????? ??????? (UTC) ???????? ??????? ?????? ????? ??????? ??????? ??????? ?? ?????? "??????? ??????" ?? "???? ??????.
????? 32-?? (x 86)
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ???????????? ???? ??????
Db2oledb.dll6.0.2048.0488,96003 ?????? ??????: ??x 86???? ??????
Db2oledb.h??? ?????24,57903 ?????? ????17: 36??? ????????? ??????
Ddmstr.dll6.0.2048.044,03203 ?????? ??????: ??x 86???? ??????
Drdaresync.exe6.0.2048.0337,40803 ?????? ????17: 32x 86???? ??????
Microsoft.hostintegration.dataaccesslibrary.dll6.0.2048.086,01603 ?????? ??????: ??x 86???? ??????
Microsoft.hostintegration.dataaccesstool.exe6.0.2048.02,703,36003 ?????? ????17: 32x 86???? ??????
Microsoft.hostintegration.msdb2client.dll6.0.2048.0114,68803 ?????? ??????: ??x 86???? ??????
Mseidb2c.dll6.0.2048.071,68003 ?????? ??????: ??x 86???? ??????
Mseidb2d.dll6.0.2048.0435,20003 ?????? ??????: ??x 86???? ??????
Mseidrda.dll6.0.2048.0695,80803 ?????? ????17: 32x 86???? ??????
????? 64-?? (x 64)
?? ??? ??????????? ??? ??????
??? ?????????? ???????? ????????????????????? ?????????? ??????
Db2oledb.dll7.0.2535.0758,544????? ?????? ????12: 34x 64??? ?????
Microsoft.hostintegration.dataaccesslibrary.dll7.0.2535.02,550,616????? ?????? ????12: 34x 64??? ?????
Microsoft.hostintegration.dataaccesstool.exe7.0.2535.0613,200????? ?????? ????12: 34x 64??? ?????
Mseidrda.dll7.0.2535.01,355,536????? ?????? ????12: 34x 64??? ?????
Snanls.dll7.0.2535.0128,776????? ?????? ????12: 34x 64??? ?????
Db2oledb.dll7.0.2535.0516,880????? ?????? ????12: 34x 86syswow
Mseidrda.dll7.0.2535.0781,072????? ?????? ????12: 34x 86syswow
Snanls.dll7.0.2535.0105,224????? ?????? ????12: 34x 86syswow
?????? ???? ?????? ?????? ??????? ?????? ?????? ???? ????? ??? ??? ??????? ?? ????? ????? ??? ????? ??????.

?????

???? Microsoft ?? ??? ????? ?? ?????? Microsoft ??????? ?? ??? "????? ???".

??????? ????

???? ??? ??????? ????? ????? ????? ????? ?????. ???????? ????? ????? ????? ?????? ????? ????? ????? datetime SQL Server ??? ????? ?????? IBM DB2 ???? ?????? IBM DB2 DATE. ??? ???? OLE DB ?? DB2 ??????? ????? ?? ?????? ??????? datetime SQL Server. ?????? ???? OLE DB ?? DB2 ?????? ??????? ??????? ??? ????? ?????? IBM DB2.

???? ????? ????? ????? ????? ????? ???????:
DateTime ???? ??????? = Value
?? ??? ??????? ????? ????? ????? ????? ValueTRUE ?? FALSE. ??? ??? ?????? DateTime ???? ??????? = TRUE ????? ??? ????? ????? ???? OLE DB ?? DB2 ????? ??????? datetime SQL Server ??? ??? ?????? IBM DB2 DATE. ??? ???? ?? ?????? ???? OLE DB ?? DB2 ?????? ??? ????? ?????? IBM DB2.

??? ??? ?????? DateTime ???? ??????? = FALSE ????? ??? ????? ????? ???? OLE DB ?? DB2 ?????? ????? datetime SQL Server ??? ????? ?????? IBM DB2 ??? ???? ?? ????? SQL. ?? ??? ??????? ???? ?????? ???? OLE DB ?? DB2 ??????? ??????? ?????????? ??????? ??? ????? ?????? IBM DB2.

?????? ??? ?????? ?? ?????? ????????? ??? ?? ??? ?????? ????? ??????? ?????? ???? ??????? ??? ????? ???????.

???? ?????? ?????? ????? ????? ??? ??? ??????? ????? DateTime ???? ???????.
; Everything after this line is an OLE DB initialization string.
Provider=DB2OLEDB;Password=<Password>;Persist Security Info=True;User ID=<Username>;Initial Catalog=S105FRDM;Defer Prepare=False;Derive Parameters=False;Network Transport Library=TCP;Host CCSID=37;PC Code Page=1252;Network Address=<Address>;Network Port=446;Package Collection=DB2USER;Default Schema=DB2USER;Default Qualifier=DB2USER;DBMS Platform=DB2/AS400;Process Binary as Character=False;Connection Pooling=True;Units of Work=RUW;DateTime As Date=TRUE
??? ??? ????? ??? ??????? ?????? ?????? DateTime ???? ??????? = TRUE ???? ????? ???????? ?? ???? ????? ????? ???????:
22007 SQLSTATE: SQLCODE:-180
???? ??? ??????? ??? ??? ???? ????? ?????? IBM DB2 ?????? ??? ???????? "?????? ?????? IBM DB2. ???? ??? ??????? ??? ????? ?????? IBM DB2 ????? ????? ??????? ??????? ?????????? ????? ????? ??? ????? ??????? ??? ???? ????? ?????? IBM DB2 ?????? ??? ???????? "?????? ?????? IBM DB2. DateTime ???? ??????? = TRUE ???? ??????? ???? OLE DB ?? DB2 ??? ??????? ????? ?? ?????? ??????? datetime SQL Server. ?????? ???????? ??? ???? ????? ??? ????? ????????? ??? ???? ????? ?????? IBM DB2 ?????? ??? ?????? IBM DB2 ?????? ??????.

??? ??? ??? ?? ????????? ??? ???? IBM DB2 ?????? ??? ???????? IBM DB2 DATE ???? ?????? IBM DB2 ?????? ?????? ?? ????? ???? ??????? ????? ????? ?????? ?? ??????? ???????? ??????? ???????. ??? ????? ????????? ???????? ????? ?????? IBM DB2 ?????.

????? ?? ?????????? ???? ??? ??? ??????? ?????? ?????? ?? "????? ??????? ?? Microsoft" (????? ?? ??? ???????? ??? ???? ?? ???? ??????? ??? ?? ??? ??? ?????? ??????????):
824684??? ????????? ???????? ????????? ???? ??????? ????? Microsoft
?????? ?????? ?????? ???????? ?? ??? ??????? ???? ????? ?????? ?????? ?? Microsoft. ?? ???? Microsoft ?? ???? ? ???? ??? ???? ?? ???? ?????? "?? ??? ???????? ?? ?????.

???????

???? ???????: 924599 - ????? ??? ??????: 20/???/1431 - ??????: 2.0
????? ???
  • Microsoft Host Integration Server 2006 Enterprise Edition
  • Microsoft Host Integration Server 2006
  • Microsoft Host Integration Server 2004 Enterprise Edition
  • Microsoft Host Integration Server 2004 Standard Edition
  • Microsoft OLE DB Provider for DB2
????? ??????: 
kbmt kbautohotfix kbdb2oledb kbhis2004 kbfix kbbug kbhotfixserver kbqfe kbpubtypekc KB924599 KbMtar
????? ????
???: ??? ????? ??? ?????? ???????? ?????? ????? ???? ????? ?????????? ????? ?? ????????? ?????? ????. ???? ???? ?????????? ???? ?? ???????? ???????? ?????? ????????? ????? ????????? ???????? ????? ???????? ?????? ?? ?????? ??? ?? ???????? ???????? ?? ????? ??????? ?????? ??? ??????? ?????? ??. ?????? ?? ???? ??? ??????? ???????? ????? ?? ???? ????? ?????? ??? ????? ??? ????? ??????? ?? ????? ?? ?????? ??? ??? ??????? ??????? ?? ????? ????? ????? ????? ?????. ?? ????? ???? ?????????? ??????? ??? ????? ?? ??????? ?? ????? ?????? ?? ??? ????? ?? ????? ??????? ?? ???????? ?? ??? ???????. ???? ???? ?????????? ???????? ??? ????? ?????? ??????? ??????
???? ??? ????? ??????? ?????? ??????????924599

????? ???????

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com