ASP Provider= Connection Error

[jantoine]

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")

 

[Pyrrhonist]

In the link I posted before...

http://www.error-bank.com/microsoft.public.dotnet.framework.adonet/84787_Thread.aspx

Towards the bottom (page 5 of 7 on my printed copy) it lists this error...(3) Oracle ODBC Driver

Had you tried the solution suggested on that page?

 

[jantoine]

Pyrrhonist,

That worked!!!! I must have missed a step in an earlier attempt!!! THANKS!

 

[Pyrrhonist]

**laugh** No worries! And I'm glad it worked...that bodes well for my problems Just have to wait until we can do a system reboot now!!!

Enjoy!

 

[jantoine]

You should know that solution is really in 2 parts. First involves the steps you supplied. Next involves changing the text in my ASP code from:

oConn.Open = "Provider=MSDAORA;Data Source=<Source>;User ID=<User>;password=<Password>;"

To:
With oConn
.Provider="MSDAORA"
.ConnectionString="Data Source=<Source>;User ID=<User>;Password=<Password>;"
.Open
End With

You and Cassidy really save us a lot of work and expense. THANK YOU SO MUCH!!!!

 

[jantoine]

Pyrrohonist,

Althought your recommedations worked, I've had to monkey with the DSN and ASP code daily to make the connections work. Everyday, the old error pops up again.

Now, I've removed and recreated the DSN and I'm still not able to get the page to display without errors. Any new ideas?

 

[Pyrrhonist]

Hmmm...I'm sorry to hear that...I am still awaiting the possibility of a system reset on my end, and still havn't had the chance to test out the suggested changes.

One site I had encountered mentioned something like what you're experiencing...unfortuneately, the 'solution' that person listed REALLY isn't much of a solution...

1) Keep trying to connect, and EVENTUALLY a connection will succeed...everything should be fine for a while once the initial connection has been established once...

2) This is a known problem...wait for a patch...

As I said, neither 'solution' was appealing, but that is what was suggested by the other user...not sure which site I'd seen this on now (been a few weeks since I found it) and I am paraphrasing somewhat...

If I encounter anything further, I'll post it here though...sorry to hear that your system is back in the state it was again

 

[jantoine]

You can't imaging my displeasure at arriving back at the same place. I do appreciate your help.

If you recall the site offering information on this problem, let me know. YOu can email me direct at:

JAntoine@bjc.org

Thanks again.

 

[DreXor]

from my experiences in the past, if you happen to have front page extentions/security enabled can cause this similar effect, used to be with FP2k it would rewrite your bloody asp code all the time ( nightmare )

marked for email if you happen to have FP enabled i'll see what i can rummage up in the meantime

DreX
aKa - Robert

 

[jantoine]

DreXor,

How and where can I turn FP off? I'd like to explore this. Thanks.

 

[DreXor]

it will be in the MMC for IIS, and also inside FP itself, directory security and so forth is set withing the folder properties inside FP, and then is carried across to IIS via the server extentions.

if directory security settings have been set by frontpage, any time the services are restarted, FP is loaded/connected, or changes ( pages added etc ), will re-apply the security settings to your web environment and in turn may cause the resetting of your manually set permissions.

DreX
aKa - Robert

 

[jantoine]

WOW! Great info DreXor! Do you know if the same applies, as it should, to InterDev 6.0? I use InterDev for all of my ASP development.

Thanks again. I'll ask the Security Team for their help.

 

[DreXor]

it could possibly, i dont know never really used interdev and dont know if it has permission settings for active environment

visual safesource probably would, especially if the DB is included in the scheme

DreX
aKa - Robert