Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

ASP Provider= Connection Error

Status
Not open for further replies.
jantoine

jantoine

IS-IT--Management
Jan 29, 2003
20
US
I have a valid page on server that I'm moving to a new server. Loading this page from on my old serer works beautifully. However, opening the same page from the NEW server produces an error:



BJC Change Management-Test

Microsoft OLE DB Provider for Oracle error '80004005'

Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation. Provider is unable to function until these components are installed.

/bjcremedychangemgmt.asp, line 369


My code at line 369 reads:

360. dim oConn
361. dim oRst, sql, RptName, esql, gsql, fsql, ShowAnalyst, ShowDetail, SelOpt
362. dim ncrlSel, crcrdSel, acrcbSel, isatrSel, wlsdSel, wlsmSel, wlsaSel, isawSel
363. dim oacdSel, oacmSel, npcSel, grpOrInd, cacdSel, wlssSel, tmpSess, SelectType
364. dim defaultStartDate, defaultEndDate, sYear, sql1, npccSel, sPeriod, ipyYear
365. dim GroupOrder, partno, ppbdSel, start_date, end_date, nwlsdSel, nwlasmSel
366. set oConn = server.CreateObject("adodb.connection")
367. 'set oCmdArea = server.CreateObject("adodb.command")
368.
369. oConn.Open = "Provider=MSDAORA;Data Source=<MyOracleDatabase>;User ID=<MyUserName>;password=<MyPassWord>;"
370. set oRst = server.CreateObject("adodb.Recordset")
371. set RptName = Request.QueryString("rptname")
372. set grpOrInd = Request.QueryString("groupOrIndividual")
 
Sort by date Sort by votes
Does the new server have Oracle components setup on it? It seems that this is where the issue is coming in.

------------------------------------------------------------------------------------------------------------------------
"The major difference between a thing that might go wrong and a thing that cannot possibly go wrong is that when a thing that cannot possibly go wrong goes wrong it usually turns out to be impossible to get at or repair."
--Dou
 
Upvote 0 Downvote
Thanks for the reply Chopstik! Love that handle :)

I'm told by the D.B.A.'s that the Oracle Components are set up. I don't know how to valid if they are; and I'm still getting the error.
 
Upvote 0 Downvote
I rather much like my handle myself. :)

Honestly, I am not certain. I use SQL Server myself so am not entirely certain how Oracle is different. Can you connect to the server with the same setup that you've highlighted in your code? Sorry, I am not much help here. [ponder]

As far as your DBA goes, it would not be the first time that a DBA has said that something is there and it subsequently turned out that their statements were not completely accurate. [noevil]

------------------------------------------------------------------------------------------------------------------------
"The major difference between a thing that might go wrong and a thing that cannot possibly go wrong is that when a thing that cannot possibly go wrong goes wrong it usually turns out to be impossible to get at or repair."
--Dou
 
Upvote 0 Downvote
Yes! I've used NetMeeting to connect to the new server. From there, I started an Oracle SQL session without a problem.

I'm inclined to agree with you assessment of DBA's. They tend to live in a different world and look down on everyone else. That attitude I don't understand. Thanks for you time and assistance.
 
Upvote 0 Downvote
This is EXACTLY what I'm running into as well...if anyone out there comes up with an answer, I'm all ears ;)

One of the options we are looking at (and one I'm NOT wanting to do) is to set up an ODBC connection and use that.

The DBA I'm working with is using SQL Server on the IIS machine, and is using some SQL Server 'wizard' to connect to the Oracle machine. I've looked at everything he has, and there are no connection strings around I can steal for my app....

I did a search on the IIS machine though, and was NOT able to find MSDAORA.dll...yet the DBA loaded Oracle8i client, has the latest MDAC loaded from Micro$oft, and we're able to use SQLPlus80W.exe to connect to the Oracle server...

Not sure if any of this additional info will help, but hope it does ;)
 
Upvote 0 Downvote
Well I seem to have found an answer and it isn't pretty. It seems that Microsoft's MDAC is level 2 compliant whereas Oracle 9i is level 3... they aren't compatible and there's no fix.

My DBA tells me I have to use MS 2000 and Oracle 8i for ODBC compatibility. We even tried to load 9i on 2000 server and that too failed.
 
Upvote 0 Downvote
Odd...we're running Oracle 8.0.5 on NT4.0 machine, and the IIS server is running on Win2K Server...

If I read your info correctly, you're saying that the solution is an older version of Oracle? But that is what we have, and that still doesn't work...I encountered THIS URL that might help you...it didn't work (we havn't tested with the restart of the machine yet) for us though...

 
Upvote 0 Downvote
Jantoine,

I had a simliar issue when I tried reloading Oracle on a new server for our Lilly software. Oracle sent me a new installer and client because there was a major issue with the X86 install files and Windows 2000, 2003, and XP. The network admin here was on the phone for a solid week before they got him the correction.

Funny part was the Oracle SQL session worked fine and all the oracle tools, just nothing else including the software we use.

I didn't try ODBC so I can't tell you if it worked. It take me a bit but I will get the information from our network admin if you want and you can see if it fits your situation.

Let me know

Cassidy
 
Upvote 0 Downvote
Pyrrhonist, the issue occurs with Oracle 9i (and, I'm told, higher.) Oracle 8i works with Microsoft MDAC.

Thanks for the link. It's next on my reading list :)

As I said earlier, we also tried to use Oracle 9's client on a 2000 server. That failed with the same errors as the 9 client on 2003.

Thanks again. Good luck!
 
Upvote 0 Downvote
Yes, cassidy, I'd like any help I can get. Thanks!
 
Upvote 0 Downvote
Jantoine,

Here is the message that is from Oracle. You need to have a support agreement to get the files for the fix. I don't know what type of processor you have but the symptoms your describing are exactly what we had. Turns out we wouldn't get a full install and it left us hanging on the development end as well as some other portions. Was very difficult to install too.

Oracle 9i installer has a bug. It wont work with Intel Pentium IV processors. There is a work around.

Workaround 1:
1. Create a temporary directory on your server.
2. Copy the entire contents of the Oracle RDBMS Server CD to the temporary directory created in step 1.
3. Search the directory structure created in Step 1 for the existence of the filename symcjit.dll.
4. Rename each copy of the symcjit.dll to symcjit.old.
5. Run the setup.exe from the install\win32 directory (under the directory on your hard disk used in Step 1) and install Oracle 9 and related products.

Here is the link on the Oracle Metalink support site:

I hope this helps.

Cassidy
 
Upvote 0 Downvote
Thanks Cassidy! It's worth a shot. I'll let you know the outcome.
 
Upvote 0 Downvote
Quick update...

The application I've developed, has two main methods of communicating with the database...read-only access for queries, and a write/update access for logged in users.

The DBA read through the links I posted yesturday, and did everything on them he was able to do (unable to restart the server computer though), and we are now able to connect with the read-only account!

When trying to login, a different error is occuring now, but I think I know why that is, and am working on fixing that....

The main difference that has happened though, and have NO idea if it will make a difference for you or not, is that the DBA altered my connection string...

The string now reads

"Provider=MSDAORA.1;Data Source=MyDatabase;User ID=MyID;Password=MyPass"

IDENTICAL to what we had before, with the exception of adding the '.1' at the end of the provider...? Might be worth trying for you as well...

OH! Almost forgot to mention...the server isn't able to be restarted, but the DBA DID shut down and restart the IIS server...that may well have helped...
 
Upvote 0 Downvote
No, Pyrrhonist, that didn't do it. I also stopped and restarted the IIS server after making the change to my connection string. Thanks for the effort.

Are you running 2000 or 2003 server; also, are you running Oracle? If so, what version of the Oracle client is installed on IIS?
 
Upvote 0 Downvote
Something else that I can see you might try is instead of using MSDAORA is use OraOLEDB.Oracle for the provider. This greatly increased my functionality and abilities on the Oracle Database.

 
Upvote 0 Downvote
Nada! I give up. I think I'm going to move back to Win2000 Pro and Oracle 8i client. I know that works.

I sincerely appreciate your time and efforts to assist. Let me know if I may return the favor. You can reach me at: jantoine@bjc.org

Jean
 
Upvote 0 Downvote
We have IIS (fairly certain it's version 4) running on a W2K Server workstation.

The Oracle DB is loaded on a NT4Server box, running version 8.0.5 of Oracle.

MDAC that is loaded, I've been lead to believe, is 2.7.

At this point, I'm still waiting to get admin rights granted to me to start fiddling with my connection strings...with luck that will allow the app to finally work!

For further info, I am running in a development environ FLAWLESSLY.

What has gotten me into all these problems, is moving the app from devel to production. Development box is the NT4 box running the Oracle DB...it is IIS4 (with patches) running there.
 
Upvote 0 Downvote
Well I'm blue in the face with this. I've gone to Oracle and downloaded their lates drivers (9.2.0.6.0 that's suppose to be compatible with Windows 2003 server.)

I've created new System DSN's and changed the connections string in my ASP code and still get the failures. There's a new failure code that appears that leads to nowhere... Microsoft OLE DB Provider for ODBC Drivers error '80004005'

Specified driver could not be loaded due to system error 5 (Oracle in OraHome92).


WHAT THE HELL IS A SYSTEM ERROR 5?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

penguinspeaks
  • Locked
  • Question
write HTML code within ASP line
Replies
1
Views
264
xwb
xwb
leifoet
  • Locked
  • Question
How to send HTML emails with ASP classic?
Replies
0
Views
245
leifoet
leifoet
penguinspeaks
  • Locked
  • Question
Return to current location on page after asp processes.
Replies
2
Views
196
penguinspeaks
penguinspeaks
how2trainyourdragon
  • Locked
  • Question
Request.Server variables blank for classic ASP
Replies
12
Views
478
GriffMG
GriffMG
Swi
  • Locked
  • Question
JQUERY AJAX POST and how to receive data via Classic ASP
Replies
0
Views
278
Swi
Swi

Part and Inventory Search

Sponsor

Back
Top