+ Reply to Thread
Results 1 to 5 of 5

OLAP EXCEL OLE DB Provider Error

  1. OLAP EXCEL OLE DB Provider Error

    Hello,

    I created two cubes in sql2000 and sql2005 servers. The cubes are akin and
    the users connect them via excel 2003 and excel XP edition. Somehow excel
    2003 users cannot connect the 2005 analysis server but excel XP edition can.
    I have downloaded and installed MSXML 6.0 SDK, OLE DB 9.0 Provider and
    XLAddinSetup.msi on the users client's computers so far but not is changed.
    SQL 2005 has service pack 2 and win 2003 sp1. The error message is below.
    Have you met that kind of error before. Any advice would be helpful

    Thank you.

    Errors

    XML parsing failed at the line 1 column 9: DTD is prohibited

    and after

    Errors in the ole db provider. An error occurred while loading the
    connection dialog box component for prompting






  2. Re: OLAP EXCEL OLE DB Provider Error

    On May 29, 8:09 am, "tolgay" wrote:
    > Hello,
    >
    > I created two cubes in sql2000 and sql2005 servers. The cubes are akin and
    > the users connect them via excel 2003 and excel XP edition. Somehow excel
    > 2003 users cannot connect the 2005 analysis server but excel XP edition can.
    > I have downloaded and installed MSXML 6.0 SDK, OLE DB 9.0 Provider and
    > XLAddinSetup.msi on the users client's computers so far but not is changed.
    > SQL 2005 has service pack 2 and win 2003 sp1. The error message is below.
    > Have you met that kind of error before. Any advice would be helpful
    >
    > Thank you.
    >
    > Errors
    >
    > XML parsing failed at the line 1 column 9: DTD is prohibited
    >
    > and after
    >
    > Errors in the ole db provider. An error occurred while loading the
    > connection dialog box component for prompting


    Have you had any resolution to this issue? I am having the exact same
    error and cannot seem to find a fix.


  3. Re: OLAP EXCEL OLE DB Provider Error

    Try installing this patch:
    http://support.microsoft.com/kb/936305/

    I get a similar error when re-opening an Excel file that already had a
    connection the cube. However, I do not get any error when accessing
    the cube for the first time in an Excel file.

    Any ideas?













    On Jul 11, 12:16 pm, smcraven1 wrote:
    > On May 29, 8:09 am, "tolgay" wrote:
    >
    >
    >
    >
    >
    > > Hello,

    >
    > > I created two cubes in sql2000 and sql2005 servers. The cubes are akin and
    > > the users connect them via excel 2003 and excel XP edition. Somehow excel
    > > 2003 users cannot connect the 2005 analysis server but excel XP edition can.
    > > I have downloaded and installed MSXML 6.0 SDK, OLE DB 9.0 Provider and
    > > XLAddinSetup.msi on the users client's computers so far but not is changed.
    > > SQL 2005 has service pack 2 and win 2003 sp1. The error message is below.
    > > Have you met that kind of error before. Any advice would be helpful

    >
    > > Thank you.

    >
    > > Errors

    >
    > > XML parsing failed at the line 1 column 9: DTD is prohibited

    >
    > > and after

    >
    > > Errors in the ole db provider. An error occurred while loading the
    > > connection dialog box component for prompting

    >
    > Have you had any resolution to this issue? I am having the exact same
    > error and cannot seem to find a fix.- Hide quoted text -
    >
    > - Show quoted text -




  4. Re: OLAP EXCEL OLE DB Provider Error

    On Jul 12, 11:07 am, Henry wrote:
    > Try installing this patch:http://support.microsoft.com/kb/936305/
    >
    > I get a similar error when re-opening an Excel file that already had a
    > connection the cube. However, I do not get any error when accessing
    > the cube for the first time in an Excel file.
    >
    > Any ideas?
    >
    > On Jul 11, 12:16 pm, smcraven1 wrote:
    >
    >
    >
    > > On May 29, 8:09 am, "tolgay" wrote:

    >
    > > > Hello,

    >
    > > > I created two cubes in sql2000 and sql2005 servers. The cubes are akin and
    > > > the users connect them via excel 2003 and excel XP edition. Somehow excel
    > > > 2003 users cannot connect the 2005 analysis server but excel XP edition can.
    > > > I have downloaded and installed MSXML 6.0 SDK, OLE DB 9.0 Provider and
    > > > XLAddinSetup.msi on the users client's computers so far but not is changed.
    > > > SQL 2005 has service pack 2 and win 2003 sp1. The error message is below.
    > > > Have you met that kind of error before. Any advice would be helpful

    >
    > > > Thank you.

    >
    > > > Errors

    >
    > > > XML parsing failed at the line 1 column 9: DTD is prohibited

    >
    > > > and after

    >
    > > > Errors in the ole db provider. An error occurred while loading the
    > > > connection dialog box component for prompting

    >
    > > Have you had any resolution to this issue? I am having the exact same
    > > error and cannot seem to find a fix.- Hide quoted text -

    >
    > > - Show quoted text -- Hide quoted text -

    >
    > - Show quoted text -


    I found the issue was how someone set up their original connection to
    the cube through Excel. If the original author of a spreadsheet
    entered a username and password in their connection setup, then all
    other users would get this error. If you set up your connection to
    use Windows Authentication, then this error would not show up.


  5. Re: OLAP EXCEL OLE DB Provider Error

    Thank you! That seems to have done the trick.

    However, some users have gotten another error when trying to access
    the cube within Excel:

    XML for Analysis parser: The LocaleIdentifier property is not
    overwritable and cannot be assigned a new value

    As I found out in previous postings, changing the user's Regional
    Language Settings to Englilsh (US) via the Windows Control Panel fixes
    the problem. However, my company has users in Quebec whose settings
    are in French.

    Is there a fix for this as well?



    On Jul 12, 5:11 pm, smcraven1 wrote:
    > On Jul 12, 11:07 am, Henry wrote:
    >
    >
    >
    >
    >
    > > Try installing this patch:http://support.microsoft.com/kb/936305/

    >
    > > I get a similar error when re-opening an Excel file that already had a
    > > connection the cube. However, I do not get any error when accessing
    > > the cube for the first time in an Excel file.

    >
    > > Any ideas?

    >
    > > On Jul 11, 12:16 pm, smcraven1 wrote:

    >
    > > > On May 29, 8:09 am, "tolgay" wrote:

    >
    > > > > Hello,

    >
    > > > > I created two cubes in sql2000 and sql2005 servers. The cubes are akin and
    > > > > the users connect them via excel 2003 and excel XP edition. Somehow excel
    > > > > 2003 users cannot connect the 2005 analysis server but excel XP edition can.
    > > > > I have downloaded and installed MSXML 6.0 SDK, OLE DB 9.0 Provider and
    > > > > XLAddinSetup.msi on the users client's computers so far but not is changed.
    > > > > SQL 2005 has service pack 2 and win 2003 sp1. The error message is below.
    > > > > Have you met that kind of error before. Any advice would be helpful

    >
    > > > > Thank you.

    >
    > > > > Errors

    >
    > > > > XML parsing failed at the line 1 column 9: DTD is prohibited

    >
    > > > > and after

    >
    > > > > Errors in the ole db provider. An error occurred while loading the
    > > > > connection dialog box component for prompting

    >
    > > > Have you had any resolution to this issue? I am having the exact same
    > > > error and cannot seem to find a fix.- Hide quoted text -

    >
    > > > - Show quoted text -- Hide quoted text -

    >
    > > - Show quoted text -

    >
    > I found the issue was how someone set up their original connection to
    > the cube through Excel. If the original author of a spreadsheet
    > entered a username and password in their connection setup, then all
    > other users would get this error. If you set up your connection to
    > use Windows Authentication, then this error would not show up.- Hide quoted text -
    >
    > - Show quoted text -




+ Reply to Thread