|
Does anybody have experience with this?
Here's the scenario:
I have a Classic ASP web application that ran just fine on the same machine with an instance of an Oracle 8i database. So, in more specific terms ... one machine running both an Oracle DB and IIS to display information in web pages. This worked.
Then I upgraded the DB to 9i and it does not work. IIS still works, but when the ASP pages get to the point of trying to create the ADODB.Connection to Oracle ... error.
Two different errors occur because I have tried to connect to the DB two different ways.
Using OLE DB:
Oracle error occurred, but error message could not be retrieved from Oracle.
Using a DSN from ODBC:
Specified driver could not be loaded due to system error 5 (Oracle in OraHome92).
Both instances point to driver related errors and the second hints to permission problems. I have tried allowing full permissions to everyone for just about everything possible on a test machine and can see no reason for drivers to be fouled up. Installing the most recent version of the MDAC has been attempted to no avail ... reinstalling the Oracle Client tools ... no go. Even a full reinstallation of Windows 2000 Server, the Oracle DB and the web app still results in the same errors.
If you can help shed any light on this or give suggestions of things to try I am more than willing to try them. TIA.
Wally Atkins
Newport News, VA, USA
|
|
|
|
|
If this spiked anybody's curiosity I'd just like to let folks know that OO4O turned out to be a diamond in the rough.
Still haven't figured out what the deal was with ADO but, hey, it works now. 
Wally Atkins
Newport News, VA, USA
|
|
|
|
|
D2F3U wrote:
OO4O turned out to be a diamond in the r
can u just explain and tell me... how u got things working!
I was born intelligent
Education ruined me!.
|
|
|
|
|
In one case we had a server that had both an 8i instance and a 9i instance and when we switched the ASP code to use OO4O everything magically worked again.
The other case was the same machine scenario (8i and 9i both installed) but the OO4O still gave us some funky permissions error. We wiped the machine of Oracle (both instances removed) and even cleared the registry of all the Oracle info. Then 9i was put back on and we had to give the IUSR and the IWAM users read and execute on permissions on the Bin directory. After all that things were running smoothly again. Crazy huh?
If you are using ASP with OO4O this link should help things get rolling:
http://www.15seconds.com/issue/000131.htm
To my knowledge, OO4O now comes with a normal installation of 9i but did not come with 8i.
I hope this is helpful information.
Wally Atkins
Newport News, VA, USA
|
|
|
|
|
Hi
can you point me to some sites that provide free graphics libraries to use in my site?
thank you
|
|
|
|
|
http://www.pambytes.com
http://www.gemsgallery.org/
http://www.ibiblio.org/gio/iconbrowser/
http://www.allfreeclipart.com/
Best regards,
J. Paul Schmidt - Freelance ASP Web Developer
http://www.Bullschmidt.com - Creating "dynamic" Web pages that read and write from databases...
|
|
|
|
|
Is there a quick way to retrieve the current Windows user's logon name (assume a corp. intranet using Win2000 servers) using ASP? I have tried using <% = Request.ServerVariables("LOGON_USER") %> (as well as REMOTE_USER, UNMAPPED_REMOTE_USER, and AUTH_USER) - all of which return nothing.
|
|
|
|
|
Anonymous wrote:
I have tried using <% = Request.ServerVariables("LOGON_USER") %>
This is the correct way to retrieve the logon name. Ensure that you are using Windows Integrated Authentication on the directory you are using through IIS. An example of how to to do this would be:
Open Internet Information Services (IIS)
Expand the Default Web Site
Right click a Directory (virtual or not)
Select Proporties
Go to the Directory Security tab
Click the Edit ... button for Anonymous Access and Authentication Control
Ensure that Windows Integrated Authentication is the ONLY checkbox that is checked
The default is that both Anonymous Access and Windows Integrated Authentication are checked. This will not work. You must turn off Anonymous Access.
Wally Atkins
Newport News, VA, USA
|
|
|
|
|
Anyone know where I can find a list of characters and their escape sequence. Like space = %20, & = %26, etc.
Jason Henderson My articles
"The best argument against democracy is a five-minute conversation with the average voter." - Winston Churchill
|
|
|
|
|
It's just the ASCII character code in base 16.
Try Accessories/System Tools/Character Map, it will give you the code.
If programming, try a code using .ToString("X") on a char.
My latest article: GBVB - Converting VB.NET code to C#
|
|
|
|
|
Thank you, Sir. 
Jason Henderson My articles
"The best argument against democracy is a five-minute conversation with the average voter." - Winston Churchill
|
|
|
|
|
Hello CPians,
I am developing an application on ASP.NET with C# and one of the basic requirements is to dynamically update certain clients. In other words I need to send information to the client without the client requesting it in order to keep 3, 4 or 5 clients synchronised with the same info when one of them is updating the info.
I know that it sounds strange but this is the essence of the application.
I know that I can refresh the page every X seconds, but this is not good as it will overload the server with unwanted requests.
Is this feasible?
Any ideas are wellcomed!
Thanking you in advance...
|---------------|
| theJazzyBrain |
|---------------|
|
|
|
|
|
You could use Response.Flush but whatever you do the synchronization will never be exact there will always be diferences.
|
|
|
|
|
Man, that sounds like fun!
It depends on when you need to refresh. What is the case where you will need the clients to refresh and what is the case where they don't need to refresh?
One thought ... if all of your clients are using Windows machines then you can create the Microsoft.XMLHTTP ActiveX object with JavaScript to do a small check if the browser should refresh or not. I know you said that you don't want to overload the server with unwanted requests but if you kept it to a small "Yes" or "No" answer then it shouldn't be that taxing.
function shouldIReload() {
var obj = new ActiveXObject("Microsoft.XMLHTTP");
obj.Open('GET', 'Refresh.aspx');
obj.Send();
if (obj.responseText == "yes") {
document.location.reload();
}
}
setTimeout(shouldIReload, 1000);
This way you don't reload the entire page unecessarily and it's rather transparent to the end-user. You could even prompt the user with a confirmation box, or something friendly like that, to let the user know you are about to refresh the page and they should not crap their pants because something is happening when they didn't even click anything
The Refresh.aspx page would do a simple check of whatever criteria and only do a simple Response.Write("yes") or Response.Write("no") accordingly.
Let me know if this helps at all ...
Wally Atkins
Newport News, VA, USA
|
|
|
|
|
I think that this could be helpful...
I will have to try it and I will tell you...
Thanx for the tip...
|---------------|
| theJazzyBrain |
|---------------|
|
|
|
|
|
SQL = "UPDATE questions SET request.form("R1") = votec WHERE ID = request.form("ID") "
how do you get this to work if request.form("r1") = a1
votec is a number entering a fld with datatype of number
and request.form("ID") may be a positive or negative number
THanks in advance
|
|
|
|
|
Anonymous wrote:
how do you get this to work if request.form("r1") = a1
Is the a1 field within the same DB or a differernt DB??
Tony
"Hey" "You aint Tony"
|
|
|
|
|
a1 is a fld in the same database and table as everything else
|
|
|
|
|
Since votec is a number, and you're constructing a string, you might try an explicit cast of votec to a string representation; ie, CStr(votec) instead of merely 'votec'.
"Ask not for whom the bell tolls;
It tolls for thee..."
|
|
|
|
|
Yes that will work, or you can use If Else ElseIf.
Tony
"Hey" "You aint Tony"
|
|
|
|
|
Thanks allot dudes that helped
|
|
|
|
|
I am using Session variables to control flow through a website. One ASP page tests the value of Session("update") on entry; if it's set to "No" the script allows a record to be edited, after which it changes Session("update") to "Yes" and reloads the same page. If the value is "Yes" it is supposed to Update the DB with the new values from the edit phase. The value of the session variable is initialized in global.asa using the Session_OnStart subroutine. The trouble is that this variable never gets set! The other three variables I use for other things all get initialized correctly, but this one consistently gets skipped.
Is there something about session variables that I'm missing? Is "update" a reserved word or something? Is there a smarter way to do this?
"Please don't put cigarette butts in the urinal. It makes them soggy and hard to light" - Sign in a Bullhead City, AZ Restroom
|
|
|
|
|
Dunno, but if each user is supposed to have Session("Update") initialised to "No", you could do something like:
If Session("Update") <> "Yes" Then
...do the update...
Session("Update") = "Yes"
Response.Redirect ("MyPage.asp")
End If
...other code in page...
|
|
|
|
|
That's a possibility, but I really hate the idea of leaving anything undefined, however briefly. This should be working - the variable should be set at the opening of the session. But it isn't, and the others that I define in the same section are being set correctly and reliably. Very strange and frustrating!
"Please don't put cigarette butts in the urinal. It makes them soggy and hard to light" - Sign in a Bullhead City, AZ Restroom
|
|
|
|
|
Is there any site that I can find some web template in it?
Mazy
No sig. available now.
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
