cancel
Showing results for 
Search instead for 
Did you mean: 

CDaoException ERROR (Error 340) when accessing txt file

Former Member
0 Kudos

Hello,

I'm trying to import data from a text file in BO XIR2 and get the following error :

CDaoException SCODE_CODE = 340 SCODE_FACILITY = 4 SCODE_SEVERITY = 1 ResultFromScode = 2147746132

I've seen a another for an older version of BO suggesting to re-install microsoft data access but these software is already part of windows XP (it does not let me install any previous version).

All suggestion is welcome.

Thanks.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi OSM,

Following information might help you to resolve the issue:

Follow these steps:

1. Go to the following folder located on BusinessObjects CD1:

Vol1\Microsoft\DATAACC

2. Run the DATAACC executable file, and send the dao350.dll file to the following folder:

C:\Program Files\Common Files\Microsoft Shared\DAO

3. Go to Start > Run, and type the following line into the text box:

regsvr32 "C:\Program Files\Common Files\Microsoft Shared\DAO\dao350.dll"

You receive a message stating that the file was registered.

4. Start BusinessObjects and import a *.txt or *.xls format file.

Regards,

Sarbhjeet Kaur

Former Member
0 Kudos

Hi Osm,

Also,could you please test the following solutions:

Resolution 1

1. Make sure the following DLLs are present on the computer:

- In path "files\common files\microsoft shared\dao": dao350.dll

- In path "winnt\ system32": ExpSrv.dll, MSExcl35.dll, MSJet35.dll, MSJInt35.dll, MSJtEr35.dll, MSRepl35.dll, MSRD2x35.dll, VBAJet32.dll, msexch35.dll, and MStext35.dll

Copy the missing DLLs or older DLLs from a computer that does not have this issue.

Resolution 2

Follow these steps to reinstall the Data Access Pack:

1. On the BusinessObjects version Disk 1, go to "\Vol1\Microsoft\Dataac\".

2. Run Dataac.exe.

3. Select Data Access Pack, and install. A message will appear asking if you want to be prompted if newer DLLs exist on the system. Do not check the box; close out of the window. BusinessObjects will not overwrite any newer DLLs; it will only add the required files into the system.

Resolution 3

Install the Microsoft Data Access Pack located at the following URL:

http://support.microsoft.com/support/kb/articles/Q172/7/33.ASP

Regards,

Sarbhjeet Kaur

Former Member
0 Kudos

Hello Sarbhjeet and thank you for your suggestions.

None of them solved my issue :

1/ the requested DLL exist in windows directory

2/ impossible to re-install data access from BO CD : Data access is already part of Windows XP and the OS does not let me install a previous version.

3/ I updated the version of jet DLL as indicated in Microsoft web site but did not change anything.

At this time, I decided to have those external data in a XML file. I don't have any error when accessing a XML file.