This discussion is archived
4 Replies Latest reply: Jun 13, 2012 5:46 AM by 536166 RSS

Connection Oracle with ASP

807089 Newbie
Currently Being Moderated
Hi all.

I have problems with connection ASP and Oracle. I use Windows Server 2008 Enterprise R2 64 bit.

All this string connections not working:
cn.Open "Provider=msdaora; Data Source=ORCL; User Id=ROOT; Password=xxxxxx;"

Error:
ADODB.Connection error '800a0e7a' 
Provider cannot be found. It may not be properly installed
cn.Open "Provider=MSDAORA.1;Password=xxxxxx;User ID=ROOT;Data Source=ORCL;Persist Security Info=True;" 

Error:
ADODB.Connection error '800a0e7a' 
Provider cannot be found. It may not be properly installed
cn.Open "Provider=OraOLEDB.Oracle;ORCL;UserId=ROOT;Password=xxxxxx;" 

Error:
ADODB.Connection error '800a0e7a'
Provider cannot be found. It may not be properly installed
cn.Open "Provider=MSDASQL;DRIVER={Microsoft ODBC for ORACLE};UID=ROOT;PWD=xxxxxx;Server=ORCL"

Error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
[Microsoft][Driver Manager ODBC] Data source name not found and no default driver  
cn.Open "Driver={Microsoft ODBC for Oracle};Server=ORCL;Uid=ROOT;Pwd=xxxxxx;" 

Error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005' 
[Microsoft][Driver Manager ODBC] Data source name not found and no default driver
Can you help me?
Many thanks
MR
  • 1. Re: Connection Oracle with ASP
    gdarling - oracle Expert
    Currently Being Moderated
    Hi,

    Microsoft doesnt make a 64 bit ODBC driver or OLEDB provider for Oracle. Your choices would be:

    1) run the app as 32 bit instead.
    http://technet.microsoft.com/en-us/library/cc784046.aspx
    Configuring IIS to Run 32-bit Applications on 64-bit Windows (IIS 6.0)

    2) install 64 bit Oracle ODBC driver or Oracle OLEDB provider instead, and run the app as 64 bit.

    Note that on 2008R2, the only supported versions currently are 10205, 11201, and 11202.

    Hope it helps,
    Greg
  • 2. Re: Connection Oracle with ASP
    807089 Newbie
    Currently Being Moderated
    Hi, thanks for your help.

    I try your suggestions 1 and 2 but I don't resolve... sorry...

    In the Administrative Tools ---> Data Source ODBC I have Oracle in instantclient_11_2, but I try the configuration I have this error:
    «Unable to connect SQLState=08004 [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve the connect identifier specified»

    If I try connection for Navicat Premium it's all OK... :(
  • 3. Re: Connection Oracle with ASP
    917691 Newbie
    Currently Being Moderated
    Hi

    I had the same problem and solved it by following these steps:

    --the second step suggested earlier by gdarling

    after

    -- Install the Oracle Client for 64bits Systems; (win64_11gR1_client)
    -- Make connection using this ConnectionString:
    "Provider=OraOLEDB.Oracle.1;Password=XXXX;Persist Security Info=True;User ID=XXXX;Data Source=XXXX"


    Best Regards
  • 4. Re: Connection Oracle with ASP
    536166 Newbie
    Currently Being Moderated
    Thanks! The connectionstring in your answer solved my issue (which I was searching already for several hours)

    Why has this been changed?
    Before (= 32bit) I used as connectionstring (Provider=MSDAORA;....)
    Using this connectionstring in 64bit was working for the connection only, once I tried to perform a select, the select returned me all the time "Invalid ROWID".

    Thanks again

    Bart

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points