My system is on a NT4 (w/SP6a) running IIS 4. I am developing a page that query one record from my Oracle DB 8.1.6 on a separate machine. I am using the MS ODBC for Oracle drive. In my ASP page I have (Connection object has been crreated.) then..
View RepliesI'm trying to call a stored procedure(package) from asp/vb using following
code but I got the error message. What's the correct syntax for oracle stored procedured? Code:
I'm trying to call a stored procedure(package) from ASP/VB using following code. But I got the error message. Code:
View Replies View RelatedI have been modifying a forum I found on the web for a web site I am developing. Everythiing has been going great (www.tastytuscany.com/forum) until I yesterday when I hit a brick wall. There seesm to be an issue with the email functionality. The author wrote a "send_email" function that I just can't figure out why I keep getting this error:
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument
/forum/admin/functions/functions_send_mail.asp, line 158
In the script for the email function, here is an excerpt of the code (he uses a select statement for various email types...) and a call to the function from a page. Might I just modify that include file with my own CDONT script? I use cdonts on other pages in the site just fine? BUT, I would really like to get this to work.. Code:
I'm trying to access a stored procedure in oracle using asp/jscript.
I get an error message complaining about the parameters;
[Oracle][ODBC][Ora]ORA-06550: line 1, column 7: PLS-00306: wrong number or types of arguments in call to 'UPDATE_BAKERY_USER' ORA-06550: line 1, column 7: PL/SQL: Statement ignored
A Response.write returns this:
CommandText: { call BUNGE.UPDATE_BAKERY_USER(?, ?, ?) }
The stored procedure changes a users password, so the parameters are:
plogin
pold_password
pnew_password
Can anyone please help me verify my code?
Code:....
Please help me in finding the code for reading the Return parameter value from an Oracle stored procedure through an ASP page. I need a javascript code for doing that.
Please friends it would be of great help if i get the exact code since my project is stuck up bcoz of this.
I'm trying to run a stored procedure on an Oracle database. I currently get this error message:
Error Type:
ADODB.Command (0x800A0BB9)
Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another.
/live/verify_3.asp, line 24
My code is as follows: ....
is it possible to pass an array into an Oracle PL/SQL stored procedure from ASP? I'm trying to upload approx. 15 000 rows into Oracle and for security reasons am only permitted to access the database through PL/SQL. At the moment I've got it uploading one row at a time by looping through but this is extremely slow.
View Replies View RelatedI would like to know if anyone knows how to execute a stored procedure from ASP.NET 2.0. I'm using the NorthWind database and I'm trying to execute the "CustOrderHist" stored procedure. The error I get is "Incorrect syntax near 'CustOrderHist'. "
Public Function GetCustomerOrderHistory(ByVal customerid As String) As
SqlDataReader
Dim conn As New SqlConnection(conString)
Dim cmd As New SqlCommand("CustOrderHist", conn)
cmd.Parameters.AddWithValue("@CustomerID", customerid)
conn.Open()
Dim dtr As SqlDataReader =
cmd.ExecuteReader(CommandBehavior.CloseConnection)
Return dtr
End Function
How do I call a Stored Procedure with ASP?
View Replies View RelatedIs this the correct way to read a variable from a stored procedure
cmd.CommandType = adCmdStoredProc
cmd.CommandText = "sp_Supplier"
Hi i'd like to know what this line in a asp page does ?
cmd.Parameters.Append cmd.CreateParameter("Supplier",adVarChar,adParamInput,10,sChangeSupplier)
I have a Stored Procedure (SP) being called by my ASP page, but nothing is being executed. The SQL Profiler shows a RPC execute, but the actual SP is not executing as nothing is being inserted.
If I run an EXEC in Query Analyzer, with the same data being passed, it works fine and returns my OUTPUT. The SQL Profiler shows all the hits to the database then too. Code:
I am receiving the following error from the simple script below. This works
fine from a .NET form but when I access the dll from a Classic ASP page it
fails.
Microsoft VBScript runtime error '800a0005'
Invalid procedure call or argument: 'GetGroups'
Code:
I am working on some minor modifications, face uplift and fixing some bugs/problems. This site is done in VBScript and currently is down.
When uploading a file, the following error happens on both my local machine and the development server. Code:
I get this error melding >>>Invalid procedure call or argument: 'InStr' and this is the code where this error refers to:
If (InStr(r, UCase(strRetVal), "<TABLE>") > 0) AND _(InStr(r, UCase(strRetVal), "<TABLE>") < _
InStr(r, UCase(strRetVal), "</TD>")) then ThisCellText = mid(strRetVal, StartCellText, _
InStr(r, UCase(strRetVal),"<TABLE>")- StartCellText )
Else
ThisCellText = mid(strRetVal, StartCellText, _
InStr(r, UCase(strRetVal), "</TD>")- StartCellText )
End If
in this area i am doing something, can anyone plz direct me and tell whats wrong?
I am just wodering in asp program, if there is anybody writing store procedure for inserting data into database since there are so many parameters need to be passed into store procedure(assume there are many columns in the table).
I need to insert data into two separate tables, the relation between these two tables is 1 row of data in table1 could have multiple rows in table2 related to table1, but if the data insertion into any one of the tables is failed, the transaction will roll back and no data will be remained in any of the tables.
If this needs to be handled in asp program using transact sql, how do I implement it. If I need to it using store procedure, how do I pass the error or success signal to asp program from database.
How do I write the code for a button that will call a function/procedure in ASP and delete all records in an array? Should I use a function or procedure? Anyone who would like to finish this code? Code:
View Replies View RelatedI really don't know what's happening now with my IIS, it's really annoying me, before, when I'm accesing my asp page, I got the "ActiveX component can't create object" error and that's pointing to the line of "Set objConn = Server.CreateObject("ADODB.Connection")".
And I think the registration of my components are fine. I already reinstall my MDAC 2.8 but still no luck, then I used the IIS lockdown tool and now I can run my asp pages. But there's another problem, when I used to process my first page to the second page...
It really takes a long time to process and nothing happens, and when i refreshed the page or close it....I got now this error msg "The remote procedure call failed and did not execute".
I'm looping through the source code of an HTML page, looking for links, grabbing the source of those links and saving each one in turn to an HTML page on disk.
This is working fine about 70% of the time, but sometimes it falls over when I try to write the source code as a text file to disk: Code:
That's what I get when I try and view "default.asp" on my server.
EVERY other page works except that and no, it's not the ASP code since it works fine on our web host (uplinkearth.com) as you can see here.
Why does it do that? The service is stared in Services, along with the Locator...why shouldn't it work? It just started doing this not to long ago for no good reason (of course, we all know NOTHING happens for 'no good reason'). Any ideas?
If I type it in (http://frontier/) it doesn't load, so I 'Stop' it, then refresh and gives me that message...
I'm using Windows XP Pro with IIS 5...all service packs and updates installed along with mySQL.
I had developed a messageboard in asp which allows users to post new messages,reply to existing messages.I am using textarea (Html tag) for a messagebox in my asp page .When the user enters any characters in messagebox except a single quote ('),the message gets inserted in oracle database without any problem.But if message contains single quotes (') , while inserting in a database it gives the following error
"Microsoft OLE DB Provider for Oracle error '80040e14' ORA-00917: missing comma ".
Is there any solution to insert messages containing single quotes in a database?
im trying to add the values in 2 taables using asp + oracle 9i error
OraOLEDB (0x80040E14)
ORA-00936: missing expression
Code:
I have the Oracle not-logged on error that keeps popping up intermitently. When I restart the web server the problem is solved and everything is fine. I am unable to figure out what the problem is?
I do not have this problem with other websites running on the same web server. Can any one advise about what I need to do to solve this or atleast what direction I need to look?
when i try to write a procedure in asp file i get error message, Please explain whats wrong in my coding?
<%
CREATE PROCEDURE ProcedureName_1 AS
select * from table1
%>
Error message:-
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/sixsigma/installation_region.asp, line 2
CREATE PROCEDURE ProcedureName_1 AS
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"
OR
objcn1.Open "Provider=msdaora;Data Source=servername;User Id=abc;Password=cbs"
I am trying to run an example code from a book. However I am getting the following error message:
Number: -2147217900
Description: Syntax error or access violation
Source: Microsoft OLE DB Provider for SQL Server
SQLState: 42000
NativeError: 0
The following is the code that is being used in the asp page:....
I have the below page which i use to add the information from a form to my MySQL database. It works perfectly fine when I don't add the code at the top for sending an email. Can someone be kind and have a look at my code and let me know where I am going wrong.
When I add the email code at the top the error I get is :
Error Type:
Request object, ASP 0206 (0x80004005)
Cannot call BinaryRead after using Request.Form collection.
/change_management/area/upload.asp, line 92
upload.asp I use for addding an attachment to the form ....
Any idea what is causing this error? 006~ASP
0230~Server.Transfer Error~The call to Server.Transfer
failed while loading the page.
Just read about benefits of Server.Transfer over
Response.Redirect, replaced, and getting the error.
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?
View Replies View RelatedI know how to connect with Access.How can we connect ASP with oracle without mentioning the Data Source Name?
View Replies View RelatedI 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.