i searched the web for a code to connect an 8i oracle database with the ASP and i didn't find anything useful untill now . So if any one can help me in this i will be so greatful , also i wanna know if it is possible for the PWS or is it only working with the IIS
How do you connect to your database(oracle9i) upon clicking a button? Let's say I have a text box which ask for a specific date, then upon clicking the button, the script will connect to the database and extract records based on the input date.
I'm new to ASP so please forgive my ignorance. Our IT department says that there is no way that what I suggest can be done. I disagree because it should be possible (if not there is a massive hole in the market), but don't have the technical knowledge to back myself.
We have an Windows/IIS web server for our public website. Internally for our intranet we have a Unix box with and Oracle database. What I want to know is: Is it possible to query that database from the windows server using ASP? Are there any clients/COM/APIs etc that this would require? Can anyone direct me to a webpage that has more info?
i have written a small asp code with backend as oracle.i have created a small database which is accessed by asp. now suppose if i have to move the database to another system along with code what should i do.
my database, sqlplus oracle, has a column ccexpiry, whch is set to date. In my form in asp, there will always be an error whenever i pass in a date that is not in the DD MMM YYYY which is the standard for oracle. My qn is how can i pass in a date that is in DD/MM/YYYY format? Code:
How do i connect to Oracle Database through ASP? I have Used the Following Syntax But it gives me ADODB .Connection error no as '800a0e7a' saying Provider Cannot be Found.
set objcn1=server.createobject("Adodb.connection") objcn1.Open "Provider=OraOLEDB.Oracle;Data Source=servername;User Id=abc;Password=cbs"
I'm building a website using the oracle database engine. i'm conneting to the database using the odbc. the database is created on a webserver. when i'm using the odbc on my local workstation the connection works. but when i'm trying to publish the site i receive the following error: Microsoft OLE DB Provider for ODBC Drivers error '80004005'
Specified driver could not be loaded due to system error 5 (Oracle in OraHome92).
/arabic/news_index.asp, line 46
line 46 is when i'm opening the connection.
Note: what i mean with "my local workstation" is when i call the website using the localhost. and i mean by "publish the site" is by giving the website a dns name.
When I place a record set on an asp page designed in dreamweaver. I get the following error when i try to run d page.
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
Specified driver could not be loaded due to system error 127
I am connected to the database i can see my tables i was able to make a record set but when i place it on the pace and try to prview the page in internet explorer i get the above error. I have used oracle 10g to create the database.
i would like to ask what is the best and easiest way to connect an ASP application to an ORacle database? i will be accessing the database server from our network. do i still need to install anything in my local pc?
I written a procedure in oracle which returns a value. What all I want to do is to hold the value in a ASP vairable. The Oracle procedure,
create or replace procedure tat (j out number,i in nnumber,k in number) is begin j:=i+1; end tat;
I need to get the value of j in a variable & how to pass more parameters. i need this to be handled in asp i will pass through request form and call the procedure, and the procedure will return a value that also has to be hold.
Can I connect oracle using asp?Is it possible?I have done it with msaccess and sql server 2000 before. Can you guide me to create a connection with rdbms oracle with asp.(with dsn or without dsn)
I am trying to write a simple SQL statement which will take a string (startdate) in the format DDMMYYYY and compare it to a date stored in an Oracle database. My SQL is as follows:
<%
"select * from tblhistory where datechanged = '" & startdate & "'"
%>
The field datechanged in the Oracle database is set up using the Sysdate variable, on a previous occasion.
I have a big problem here ....i have an oracle pakage and i need to call this package in ASP , when i use "microsoft odbc for oracle" it work fine . But now we need to change the odbc to "Oracle in OraHome92" ...so evrything in the package call must be change. any one can help me ?? how can i call this package via this odbc driver and how i can retrun a record set from the package?.
On User Logout,I Close my Asp Application Browser Window, and attempt to shut down oracle database. The window closes, but Oracle Shutdown displays "Stop Active Connections".
Can i avoid this window ? I am not using global.asa.
The following is my logout code : <%Session.Abandon()%> <script language="JavaScript"> parent.window.close(); </script><%dim Executor Set Executor = Server.CreateObject("ASPExec.Execute") Executor.Application = """E:ORAWIN95BINOSTOP73.EXE""/screen" Executor.ShowWindow = false Executor.ExecuteWinApp set Executor=nothing%>
Anyone have any good links on accessing the paging methods in the Microsoft ADO when dealing with Oracle? I've tried just about everything I know, and I can't get those methods to work worth a diddly. Code:
I have had an issue that I have been working on for a couple of days.I am trying to retrieve and display an Oracle CLOB datatype containing a long description using ASP and ADO.
I cannot seem to get the contents of the recordset to display and the RecordSet.Eof and Bof properties are not returning true or false.
i am newbie to this environment,please tell me how to connect asp with oracle, ineed all the steps and sample coding.the sample coding has to show "connected" msg after conecting asp with oracle.
I'm having an asp page and I have data in excel sheet records. what i'm doing is getting those data from excel sheet through VB dll as recordset and storing it in Oracle database.
Eventhough i have a length check for each cells, when there is more than 255 chars in a cell it's throwing an error which is as follows. Error desc : Invalid Use of null Error No : 94.
An error keeps popping up on my ASP application connecting to an Oracle 9i database via a SELECT statement:
Item cannot be found in the collection corresponding to the requested name or ordinal.
However, if I put it an "On Error Resume Next", it works fine, and is able to return the value in question. The SELECT also works fine on the database itself. Here's the SELECT,
sqlstr = "select f_get_dept_name('123') dept_name from myschema.tbl_xyz"
how to add records to Oracle? coz now im doing the registration page for for new equipment,then in the page there got many fields need to fill up which call from 2 different table. so how can i do that?
I'm calling an update procedure from Oracle using ASP..
<pre> With objCommand .CommandText = "{call cust_Update(?, ?, ?)}" .CommandType = adCmdText .Parameters(0).Value = varCus_id .Parameters(1).Value = varf_Name .Parameters(2).Value = varbirthdate .Execute() ............ </pre> the problem I'm having is when entering the birthdate. This is the error I get... Microsoft OLE DB Provider for Oracle error '80040e14' I believe it has something to do with the delimiter in the date string("/"), but not sure? The Oracle procedure birth_date column is in "mm/dd/yy" format: birth_date=to_char(i_birth_date,'mm/dd/yy').... When I pass this in the textbox from the asp in this format I get the error? How can I resolve the ASP to take in the right characters for the birthdate?
i have created an ASP page and have to retrieve some values from oracle tables. Please help me with the connection syntax as weel as the code for retrieving some data from the tables .
I have converted my database from Access to Oraclec and of course I have changed my queries to work with oracle transactions.
My question is : I have a query that searches my Oracle Table for matching fields, it only returns the fields that matches the search criteria with case sensitivity.
In other word, if I enter "test" as my search string and and the table field is stored as "Test" no result is retrieved. If I search for "Test" then I get the result. Code:
I have been writing basic ASP pages now for a little over a year using access databases and javascript as my scripting language. I've been able to do about anything I needed so far. Now comes time when I wanna make a simple ASP page for my work to help thing move a little faster. However they use a Oracle database.
So the problem I think I'm going to run into is how do I connect to this database? The server that will be running the ASP pages isn't on the same machine as the Oracle database but it is on the same network. In the past I have always used the following for my connection.