Post reply

help with sp4 on sql server 2000-emergency

  • September 17, 2006 at 9:02 am

    #115731

    Hi everyone,

    this morning, in my monitroing program, I got the following messge from my asp program:

    Description: Requested operation requires an OLE DB Session object, which is not supported by the current provider.

    It seems like that after sp4 applied on sql server 2000. the OLE DB cannot talk to database any more.

    Any suggestion and clue?

    Betty

  • September 17, 2006 at 4:02 pm

    #660931

    Can you connect to the db and do something like Select * from dbo.SysObjects?

  • September 18, 2006 at 10:46 am

    #661081

    I don't really know what happened after they applied sp4 to my sql server 2000.

    I told my myself, I need to take a look at my testing database, I suddenly I found out that my live data get into my testing database and that tell me why some my production program gives invalid object error messge. You can image what will happen when you have production code running against testing database.

    So I look at the ODBC set up and the original DSN is pointing to testing database instance instead of my origianl set up --> production database.

    We have two database instances on our server. I guess they were not aware of it. One is testing server(MSDE), one is production server(sql server 2000), after the service pack is applied, something happened, I still don't know they manually did it, or system set up?

    Thank you all for providing your idea.

     

    Betty

  • September 18, 2006 at 10:51 am

    #661084

    I would be extremely surprised to find out that the system did this on its own... it's not like it does a search and replace on your hd and start changing pointers to the servers location!!!

     

    Anyways I'm glad you got it all sorted out.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply