CDaoException Error (Error Code #3633)

[Former Member]

Good Day EveryOne,

I'm using BusinessObjects 5.1.2. (company cannot afford newest version of this application )))) )

I have a problem when I try to import data from Excel file or Text file into Business objects.

I create new Data provider and put Personnel Data Files and browsed any Excel file.

Following error occurs:

"ERROR:CDaoException

SCODE_CODE = 3633 SCODE_FACILITY=10 SCODE_SEVERITY=1 ResultScode=2148142641"

Can someone help me to fix this?

many thanks in advance...

[WMuellner · Accepted solution]

Check the supported version of Excel (e.g. save the file as an "earlier version" of Excel)...

hth,

Walter

[Former Member · Accepted solution]

Thank you for your help, but the problem still remains. It also appear when i'm trying to import text files. i don't know why it should work like this.

[Former Member · Accepted solution]

Hi Alekper,

You attempt to import a Personal Data file (such as Excel or Text) and receive one of the following errors:

Error A: "CDaoException SCODE_CODE=3633 SCODE_FACILITY=10 SCODE_SEVERITY=1ResultfromScode=2148142641."

Error B: "Couldn't find installable ISAM (3170)."

It is might be due to the following reasons.

BusinessObjects version 5.1 requires the DAO 3.5 component, dao350.dll, and the 3.5 version of ODBC drivers (msexcl35.dll, mstext.dll) to perform these functions.

For "Error A", the dao350.dll file has been moved, renamed, deleted, damaged, or is unregistered.

For "Error B", the msexcl35.dll or mstext.dll files have been moved, renamed, deleted, damaged, or are unregistered.

Several Microsoft products (Windows 2000 Server, Office 2000 Premium) now install MS DAO 3.6 and the MS Jet Database Engine 4.0, which installs dao360.dll and msexcl40.dll (or mstext40.dll) respectively.

You can check the actual version of the Jet engine installed by going to Start > run, type "regedit" and then click "OK". Check the following System Registry path:

HKEY_LOCAL_MACHINE/Software/Microsoft/Jet

A folder named "3.5" should be present if you are using the DAO 3.5 component.

Follow these resolutions in order:

Resolution 1

Install Data Access Pack from BusinessObjects 5.1 Disk 1

1.Select \Vol1\Microsoft\Dataac\

2.Run Dataac.exe.

3. Select the Data Access Pack and install.

This installs and registers the required version of the DLL files and you can now import/export Personal Data files.

Resolution 2

1.Backup the msexcl35.dll file by renaming it to "msexl35OLD.dll" and backup the "mstext.dll" file by renaming it to "mstextOLD.dll".

2. Copy the "msexcl35.dll" and "mstext.dll" files from a working machine and paste them into the path "c:\WINNT\System32\".

3. Register the new DLL files by going to Start > Run and typing the following lines into the text box:

regsvr32 "c:\Winnt40\system32\msexcl35.dll"

then;

regsvr32 "c:\Winnt40\system32\mstext.dll"

Regards,

Sarbhjeet Kaur

[Former Member · Accepted solution]

Hi,

Thanks for the explaination. Infact we are also facing the same issue. Did all things as mentioned. But still this error is coming "CDAoException Scode=3633...". Is there any other solution to it?

[former_member24303]

What OS are you using?