Post reply

Driver''s SQLAllocHandle on SQL_HANDLE_ENV failed

  • April 19, 2005 at 7:08 am

    #110048

    I get the above error when attempting to connect to a SQL Server running on my local stand-alone machine.

    I think this is something to do with ODBC as I cannot start SQL Server Agent (it starts but then stops) and cannot create an ODBC User DSN for SQL Server. I get the same message when trying to connect through Query Analyser.

    The SQL Server Agent is running under the local system account.

    Any ideas?

    Thanks in advance,

    Roger Smith

     

  • April 20, 2005 at 3:38 am

    #553706

    I've no idea what caused this problem. However, I solved it by installing MDAC 2.8.

    Roger.

  • May 2, 2005 at 1:03 pm

    #556382

    That worked for me as well. NICE

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

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