Re: Does anyone know why this SQL doesn't work on different ODBC versions using ADO



It produces a error. Below is a snap-shot from my application. This was
from yesterday. Last night I upload Version 10 and the statement works
fine.


2.4 Type : EOleException
2.5 Message: Data provider or other service returned an E_FAIL status.

msadcer.dll |Microsoft Data Access - OLE DB Cursor Engine
Resources|2.81.1117.0 |20480 |C:\Program Files\Common
Files\System\MSADC
msader15.dll|Microsoft Data Access - ActiveX Data Objects
Resources|2.81.1117.0 |24576 |C:\Program Files\Common Files\System\ADO
MSVCIRT.dll |Windows NT IOStreams DLL
|7.0.2600.2180 |54784 |C:\WINDOWS\system32
xpsp2res.dll|Service Pack 2 Messages
|5.1.2600.2180 |2897920|C:\WINDOWS\system32
msado15.dll |Microsoft Data Access - ActiveX Data Objects
|2.81.1117.0 |536576 |C:\Program Files\Common Files\System\ADO
uxtheme.dll |Microsoft UxTheme Library
|6.0.2900.2180 |218624 |C:\WINDOWS\system32
NETAPI32.dll|Net Win32 API DLL
|5.1.2600.2180 |332288 |C:\WINDOWS\system32
comctl32.dll|Common Controls Library
|5.82.2900.2180 |611328 |C:\WINDOWS\system32
olepro32.dll|Microsoft (R) OLE Property Support DLL
|5.0.5014.0 |106496 |C:\selectqu
CWBZMODB.DLL|AS/400® OLE DB Provider resources |7.0.0.0
|8704 |C:\Program Files\IBM\Client Access\Mri2924
CWBSOMRI.DLL|AS/400 Operations Navigator |7.0.0.0
|46592 |C:\Program Files\IBM\Client Access\Mri2924
CWBMSGB.DLL |CWBMSGB.DLL |7.0.0.0
|8704 |C:\Program Files\IBM\Client Access\Mri2924
CWBDBMSG.DLL|Client Access Optimized SQL message DLL |7.0.0.0
|11776 |C:\Program Files\IBM\Client Access\Mri2924
cwbcomsg.dll| |
|10240 |C:\Program Files\IBM\Client Access\Mri2924
hnetcfg.dll |Home Networking Configuration Manager
|5.1.2600.2180 |344064 |C:\WINDOWS\system32
CWBZZUT2.dll|AS/400® OLE DB Utility Library |7.0.0.0
|42256 |C:\Program Files\IBM\Client Access
cwbzzodb.dll|AS/400® OLE DB Provider |7.0.0.0
|494352 |C:\Program Files\IBM\Client Access
CwbAdNrt.dll|cwbadnrt.dll |7.0.0.0
|66832 |C:\WINDOWS\system32
CWBUNSSL.dll|CWBUNSSL DLL |7.0.0.0
|44816 |C:\WINDOWS\system32
CWBUNPLA.dll|cwbunpla.dll |7.0.0.0
|175888 |C:\WINDOWS\system32
asOEHook.dll|AntiSpam OE Hook
|2006.1.0.28 |198240 |C:\PROGRA~1\COMMON~1\SYMANT~1\ANTISPAM
cwbuireg.dll|Connections Environment Export/Import API's |7.0.0.0
|14608 |C:\WINDOWS\system32
CwbSy.dll |CWBSY.DLL |7.0.0.0
|23824 |C:\WINDOWS\system32
CWBSV.dll |cwbsv.dll |7.0.0.0
|114448 |C:\WINDOWS\system32
cwbsof.dll |CWBSOF.DLL |7.0.0.0
|196880 |C:\WINDOWS\system32
cwbrw.dll | |
|199952 |C:\WINDOWS\system32
CWBRC.dll |CWBRC.DLL |7.0.0.0
|59152 |C:\WINDOWS\system32
CWBNLTRN.dll|cwbnltrn.dll |7.0.0.0
|8464 |C:\WINDOWS\system32
CWBNLDLG.dll|cwbnldlg.dll |7.0.0.0
|9488 |C:\WINDOWS\system32
CWBNL1.dll |cwbnl1.dll |7.0.0.0
|38160 |C:\WINDOWS\system32
CWBNL.dll |cwbnl.dll |7.0.0.0
|81168 |C:\WINDOWS\system32
CwbMsgbx.dll|Client Access Message Displayer DLL |7.0.0.0
|26384 |C:\WINDOWS\system32
cwbdb.dll |Client Access Optimized SQL DLL |7.0.0.0
|230160 |C:\WINDOWS\system32
cwbco.dll |CWBCO.DLL |7.0.0.0
|208656 |C:\WINDOWS\system32
CWBCFTFT.dll|CWBCFTFT.DLL |7.0.0.0
|11536 C:\WINDOWS\system32
CWBCF1.dll |CWBCF1.DLL |7.0.0.0
|7440 |C:\WINDOWS\system32
CwbCf.dll |CWBCF.DLL |7.0.0.0
|109328 |C:\WINDOWS\system32
CwbBb1.dll |cwbbb1.dll |7.0.0.0
|16656 |C:\WINDOWS\system32
CwbBb.dll |cwbbb.dll |7.0.0.0
|18704 |C:\WINDOWS\system32
cwbad1.dll |cwbad1.dll |7.0.0.0
|13072 |C:\WINDOWS\system32
CwbAd.dll |cwbad.dll |7.0.0.0
|38672 |C:\WINDOWS\system32
CwbAb1.dll |cwbab1.dll |7.0.0.0
|7440 |C:\WINDOWS\system32
CwbAb.dll |cwbab.dll |7.0.0.0
|43792 |C:\WINDOWS\system32


.



Relevant Pages

  • Re: Prevent DLL usage
    ... StackTrace st = new StackTrace; ... The Business Logic DLL references the Data Access DLL. ... No other .net assemblies may use the Data Access DLL. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Prevent DLL usage
    ... The Business Logic DLL references the Data Access DLL. ... No other .net assemblies may use the Data Access DLL. ...
    (microsoft.public.dotnet.languages.csharp)
  • solution design - Im stuck
    ... Put all UI elements in a single dll and all other data, ... feature (like News or Events) and put the data access by itself. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Prevent DLL usage
    ... The Business Logic DLL references the Data Access DLL. ... No other .net assemblies may use the Data Access DLL. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: What happened? Non of VB code works
    ... OLE automation ... I can't find Microsoft Data Access Objects though. ...
    (comp.databases.ms-access)