I get the following error message when I search for some fields stored in oracle database.
Microsoft OLE DB Provider for ODBC Drivers (0x80020009)
[Microsoft][ODBC driver for Oracle][Oracle]ORA-01861: literal does not match format string
/documenttracking_v3/ReportMain.asp
The script functions correctly using MSAccess and MS sql, when I moved to Oracle I keep getting Date format error messages eventhough The script includes a function that forces the date format I need. Code:
A database has been developed to allow IT to track fault requests. However when you list the faults in question it doesn't display the issuedate.I have checked the code in relation to the other ASP requests, apart from the field name everything else is identical.
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'm returning a date (5th Jan 2004) from Oracle using the following query:
select TO_CHAR(invoice_date,'DD/MM/YYYY') from...
This should return my date in the UK format, and it certainly appears to be doing just that in Toad. And it also looks correct in my form as it shows as:
05/01/2004
However when I submit my form I am having to convert the date to an Oracle format using this function: Code:
I'm trying to post a date value into an oracle 9i database, using classic asp, as that's the language existing app was written in, using the following code:
to_date('"&date()&"','DD-MMM-YYYY')
that's included in the insert statement, i keep getting the following error on the page:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Oracle][ODBC][Ora]ORA-01821: date format not recognized
any ideas? i checked the database type in the table, it's set to Date.
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:
I am retrivig data from MS Access and displaying data in the form of table. First time it sidplays properly, but if user goes back and agin tries to access same page. It gives following
Error Type: Provider (0x80004005) Unspecified error /DevWebInfo/Leave_status.asp, line 20
I have an asp page in which i have a combo,in change of selected index of combo i am putting the combo value to a hidden variable then submitting the form like this
form.hid.value=1 form.target; form.submit
and again while loading the form i am checking for the value like this .request.form("hid") but i am not getting the value .what could be the problem.the method of my form is post only.
I am writing WYSIWYG editior using javascript and asp.. i need a good solution for image placement, right now i am having one.. but is there is any way to retrive the attributes of the images (height, width) of the image while uploading itself.
I am using Binary read for saving the image. Or is there is any way i can place the images in a better way with out asking our end users to do much work.. Using ASP.
I am developing a simple booking system where I had a booking date. The problem is I want to make sure that the user must book 3 days in advanced for certain room.
I have tried to use DateDiff but it seems doesn't work. Actually i just 1 to make sure that the user must book 3 days in advanced from the current date. I am wondering whether there is anything goes wrong in my datediff function. Code:
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?.
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
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:
