SQLAllocHandle error

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: karan (kabi_240_at_hotmail.com)
Date: 03/17/04

  • Next message: Tim Hanson: "cpu load average in ASP script?" 
    Date: 16 Mar 2004 20:44:54 -0800

    Hi I am trying to make a simple connection in an asp page (oracle)
    Dim DConnect
    Set DConnect = Server.CreateObject("ADODB.Connection")
    DConnect.Open "dsn=mydata;uid =xyz;pwd=xyz"
    DConnect.Close
    Set DConnect = nothing

    I am getting this error.
    Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
    [Microsoft][ODBC Driver Manager] Driver's SQLAllocHandle on
    SQL_HANDLE_ENV failed
    I have made the dsn using Microsoft ODBC for Oracle 2.573.9030
    I am running windows 200 server, I have tested the dsn using 'oracle
    odbc test' utility. i can connect to the database and can run the
    queries.

    But gives the above error from my asp page,Please suggest any
    solution.
    Thanks.

  • Next message: Tim Hanson: "cpu load average in ASP script?"

    Relevant Pages

    • Re: SQLAllocHandle Error
      ... SQL Server MVP ... > Set DConnect = Server.CreateObject ... > I have made the dsn using Microsoft ODBC for Oracle 2.573.9030 ... > But gives the above error from my asp page,Please suggest any ...
      (microsoft.public.inetserver.asp.db)
    • SQLAllocHandle Error
      ... Set DConnect = Server.CreateObject ... I have made the dsn using Microsoft ODBC for Oracle 2.573.9030 ... I am running windows 200 server, I have tested the dsn using 'oracle ... But gives the above error from my asp page,Please suggest any ...
      (microsoft.public.inetserver.asp.general)
    • SQLAllocHandle Errort
      ... Set DConnect = Server.CreateObject ... I have made the dsn using Microsoft ODBC for Oracle 2.573.9030 ... I am running windows 200 server, I have tested the dsn using 'oracle ... But gives the above error from my asp page,Please suggest any ...
      (microsoft.public.inetserver.iis)
    • SQLAllocHandle Error
      ... Set DConnect = Server.CreateObject ... I have made the dsn using Microsoft ODBC for Oracle 2.573.9030 ... I am running windows 200 server, I have tested the dsn using 'oracle ... But gives the above error from my asp page,Please suggest any ...
      (microsoft.public.inetserver.asp.db)
    • Re: Oracle Query Performance, Indexes, and Optimization
      ... I'm a MS SQL Server guru, which is all we've got in-house. ... we've outsourced in an ASP model. ... provider is using Oracle 9 for the back end. ... One thing I should have mentioned is that it would be wise to look over the contract with the ASP. ...
      (comp.databases.oracle.server)