King Rat (gkr) wrote,
King Rat
gkr

PivotTable Office Web Component irritation

I'm trying to create a pivot table for Internet Explorer using Office Web Components. Only it seems I can't get it to work unless I use integrated windows security. Thing is, the SQL server I'm using doesn't recognize domain users. We have a special read-only user name and password for that server. Despite the fact that I have put this username and password in the ConnectionString property, I cannot get this damn thing to work at all. It always requests that the user enter their name/password pair. Or when I fiddle with it, it just doesn't work at all and doesn't give me any error information.

It's days like these that I dislike being a programmer.

Subscribe

  • Last post

    I don't plan to delete my LJ (I paid for permanent status, dammit), but this will be the last post. I don't plan to read it anymore, either…

  • Unemployed

    Turns out my insurance is cut off at midnight tonight, not the end of the month. In a way, that's a good thing. Now I'll move my appointment…

  • Home from the cruise, off to Sunnyvale

    A week off, but tomorrow I head to the home office for a week there.

  • Post a new comment

    Error

    Anonymous comments are disabled in this journal

    default userpic

    Your reply will be screened

  • 0 comments