About Jeff Allen Expertise I can answer basic to intermediate questions related to Classic ASP.I can answer Intermediate to Advanced questions CSS& HTML, and basic questions about JavaScript and Ajax. I can also answer questions related to web page accessibility under US Section 508.
Experience I have 8 years experience with HTML. I have been developing in ASP, VBScript and CSS for two years each. I also currently work as web developer.
Organizations IWA-HWG
Education/Credentials I have a BA in English with minors in Web Design and Scientific and Technical Writing
Expert: Jeff Allen Date: 10/7/2006 Subject: WHERE IS THE ERROR
Question Dear Sir
About the conection string in the example of Microsoft, I want to say its the same as I do but in the statement that I wrote I dividede the connection string into two parts.
Anyway its as i said working correctly before but I have errors just when I transfer to another server, from the other side i try the microsoft connection in my page on the old serrver and its working correctly but when I transfer to the new server I have the same errors as before.
Your Advice please
Best Regards
-------------------------
Followup To
Question -
Dear Sir
Kindly be informed that I developped a classic ASP page before long time ago,
The operating system is WINDOWS NT SERVER V.4 and internet explorer 5 and I installed oracle 9i on it.
This page is connected to oracle database,
The connection to open this database is as followsI have in
Set OracleConn = Server.CreateObject("ADODB.Connection")
OracleConn.ConnectionString = "Provider = MSDAORA; Data Source = orc1"
OracleConn.Open , "Myusername", "Mypassword"
set rs=Server.CreateObject("ADODB.Recordset")
This ASP is working correctly and there is no any errors in it.
Before few days we stop the NT Server and transfer this ASP to another server.
The new server have (Windows2000 server) and IIS 5.0 and I also install oracle 9i on it.
I tried to open my ASP but the following error is displayed:
""The page cannot be displayed
There is a problem with the page you are trying to reach and it cannot be displayed.
Open the localhost home page, and then look for links to the information you want.
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
Error Type:
Microsoft OLE DB Provider for Oracle (0x80004005)
Oracle error occurred, but error message could not be retrieved from Oracle.
/bs/e_state.asp, line 71
Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1; .NET CLR 2.0.50727)
Page:
GET /bs/e_state.asp ""
note that line 71 is for open connection which is :
OracleConn.Open , "Myusername", "Mypassword"
Exactly I dont Know why this error happened . I need your advice please
BEST REGARDS
Answer -
I'm not sure. I'd have to say it has something to do with the connection string itself.
If you look at this example by Microsoft for connecting to Oracle (http://support.microsoft.com/kb/q193225/) they show Username and password as part of the overall connection string. You however have it set up somewhat differently.
Answer Does the new server have the ASP ISAPI dll installed? If so, then Idon't know what to tell you other than possibly ask the Server Admin how you should be doing this as there may be settings on the server that are preventing you from connecting to the database.
