when I tried to run my ASP,I'm getting an error and to fix it, I need to run the configuriation file.but tnsping is not installed proper it seems.So can any one plz tell me the procedure to regenerate the oracle control files on WinXp?
View RepliesI don't know how to upload word doc, images and other files into Oracle Blob fields with binary format.
I tried with the following code, normally it's inserting, suppose if i try to convery binary. Code:
Hi. We have an old ugly application that uses ASP 3.0.
We had to move it to another server recently (basically by copying it
and setting up in IIS), and as we did, we started experiencing
problems with VB.
The code that somehow worked on the old server produces errors. The
most frequent example is
If Request("ddlFilter") then ....
It worked on the old server, now it gives us a type mismatch error.
Also, the errors about index not being in the collection (such as
recordset column) were swallowed (didn't occur) before and now they
actually occur, overall it's like VB went to "strict mode" or
something.
How do we make it lax again? Rewriting all that legacy code will be a
pita
I am trying to configure a new site with IIS. I set up the virtual directory.
When I tried to view it, by typing the ip addr. it does go to the index.shtm,
but goes to another page.
Then when I tried to view the index.shm it shows only the html content. It
gives a file not found error for the Virtual Incude (asp ) files. Is there
something to be done to view the virtual include files?
I'm using ASP to design a website. I know that I can keep some configurable values, such as Server Name, Database Name and even Login Username and Password in "web.config" under ASP.Net. As to ASP, is there a way like this? I'm curious about where to keep them.
View Replies View RelatedI have looked everywhere for asp code that would allow me to change the look of my IIS server generated directory listings. Eventually, I would love to change what is listed dynamically based on permissions, and allow uploading in the current directories.
View Replies View RelatedI think this error that I am receiving is a simple one to resolve.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I have downloaded and installed the latest version of MDAC but the error remains.
I am attempting to configure IIS on a different drive ( E:inetpubwwwroot, instead of c:inetputwwwroot ). Could it be that SQL, ASP and IIS just have trouble talking across multiple drives? ( I have sql installed on a third drive ).
We use the following configuration on our development environment:
Server - win2k spk4
Local Computer - win2k spk3
We use the following code on the server to access a page on the local
IIS :
Set objSrvHTTP = Server.CreateObject ("MSXML2.ServerXMLHTTP.4.0")
strUrl = "http://" & strLocalComputer & "/maoz/ShowRecNum.asp"
objSrvHTTP.open "GET", strUrl , false
objSrvHTTP.send()
lngRecNum= objSrvHTTP.responseText
set objSrvHTTP = nothing
When strLocalComputer contains the local computer name, we get the
requested page. But if we use the IP address of the local computer we
get the error :
msxml4.dll (0x80072EE7)
The server name or address could not be resolved.
We manage to run the URL with the IP address from a browser on the
server but not from a browser on the local computer. Any ideas ?
I am trying to create a product configuration tool and I'm not sure where to start. I have made a database with 4 columns..ID, component, compdescription and compcode. There are 8 different componets to configure on the product and the compcode holds the letters and numbers that eventually make up the part number when you make all your selections.
I want to be able to select one thing from each component category and submit to the database which will return a part number. I thought the easiest way to do this would be with 8 different drop down menus filled with all the options for that component category.
i have downloaded the elijathegold's flexisearch coding, but when i create the database and the table DisWords, and change the database connection from
DBConn.Open "YOUR DATABASE CONNECTION STRING"
to
DBConn.open = server.Mappath("/flexisearch/new.mdb")<-line 54
an error message pop up and shown
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name too long
/flexisearch/flexitestbed.asp, line 54, hope the creator elijathegold or someone else have tried this fleixsearch can help me with this, thx a million
Everything appears to be (mostly) there, with one significant annoying
exception. I've set up "mydomain.net" as a forward lookup zone in the DNS
console.
I've set up admin and www as hosts, so that I have subdomains: people can
visit www.mydomain.net and admin.mydomain.net without a problem.
I have each of these listed in IIS as host headers entries, so that the
webserver correctly differentiates the traffic. This all seems to work fine.
People can go to http://www.mydomain.net/index.html and they're served a
webpage. Code:
i am testing the sending email when u submit a form .. but i am getting an error:
<%
Set myMail=CreateObject("CDO.Message")
myMail.Subject="Email Send"
myMail.From="quince_103@hotmail.com"
myMail.To="qb_103@hotmail.com"
myMail.TextBody="This is a message."
myMail.Send
response.redirect("index1.asp")
%>
the error is:
Error Type:
CDO.Message.1 (0x80040220)
The "SendUsing" configuration value is invalid.
/middle/email.asp, line 7
line 7 is ==> myMail.send
so what shell i do .. ?
Can someone please help with this, I am receiving this error from my simple form:
CDO.Message.1 error '80040220'
.
The "SendUsing" configuration value is invalid
/scripts/formmail.asp, line 19
Here is the asp script I'm using:......
I am having a problem here to send my asp form to my email! I am using CDONTS under w2k and IIS! when i submit the form, all of the message (that suppose to go to my email), went to the queue folder under wwwroot!! nothing appear to my yahoo email also...
that means that my script is working...but only the configuration is need to be adjust here!
the thing is that i dont know how to configure, setup or setting the configuration for Exchange server! since my organization uses exchange server instead of the SMTP!
I wasnt really sure where to put this thread so I have put it in both ASP and DNS forums - i hope this is ok. My problem feels incredibly complicated so Im hoping that someone on one of the forums might know a few things .
Im interested in getting remote data off of a URL using ASP. There is an article about it at the URL below: Code:
Trying to send email via a form from my website. Have to use .asp and I have
been round and round the houses trying to get this to work.
On my xp pro system using IIS this works - an email appears in the folder
When it is hosted I get this error message. I understood that I didn't need
to set up any details about the host of the website. Lots of seaches suggest
putting in the smtp address but I am not sure what to do. I have also seen a
lot of talk about CDO.configuration but again despite searching I can't find
out what to do.
CDO.Message.1 error '80040220'
The "SendUsing" configuration value is invalid.
/version1/contact/email3.asp, line 51
Here's a cut down version of my page....
I creade a project where the user was able to sent e-mails it was working ok until I format my PC. After the format i installed again windows 2000 but i beleve is a diferent version that the previuse one and the e-mails now can not be sent the error that i get is that:
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Runtime.InteropServices.COMException: The "SendUsing" configuration value is invalid. Source Error: 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?
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.
I have a website that we display images we have saved into a SQL Server 2000 database as binary BLOB. This is on a Windows 2003 Server. Just recently (a week ago) this website began to save the images it is displaying on the website as ASP pages in the Temporary Internet Files > IE.Content > Folder.
We have other websites where we use the exact same code and these do not save files on the server when they are displayed.
Here is the code to display the image:
Set rs = objConn.Execute( SQL )
Response.ContentType = "application/octet-stream"
Response.BinaryWrite rs("Product_Image")
SQL is the SQL String to get the image from database
When I add this code:
Response.ContentType = "image/jpeg"
The images still display on the website, but now are saved in the Temporary Internet Files folder as JPG's.
My asp application is connect to oracle database. However, when i try to open the default page, an error occurs and i receive this message:
- Error Type:
Microsoft VBScript runtime (0x800A01B6)
Object doesn't support this property or method: 'MoveFirst'
The code that is causing this error is following:
Code:
<%
Dim objConn
Dim rsForums
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "dsn=ORCL9; uid=toy; pwd=yes;"
Set rsForums = Server.CreateObject("ADODB.Recordset")
rsForums = objConn.Execute ("SELECT * FROM Forums ORDER BY Forum ASC")
rsForums.MoveFirst
%>
<table width="100%" align="center" cellspacing="0" cellpadding="6" border="1">
<tr>
<td width="60%">
<p><b>Forums</b>
</tr>
<%
While Not rsForums.EOF
%>
<tr>
<td><a href="forum.asp?ForumID=<%= rsForums("ForumID") %>"><B><%= rsForums("Forum") %></B></a>
<BR>
<BLOCKQUOTE>
<%= rsForums ("Description")%><BR>
<SMALL>[Total Posts: <%= rsForums("Posts") %>] [Last Post on <%= rsForums("LastPost") %>]</SMALL>
</BLOCKQUOTE>
</tr>
<%
rsForums.MoveNext
Wend
rsForums.Close
The forums table in the oracle database has 2 lines of records, and it should not occur this error. Do you have any idea what is happenning?
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)
View Replies View RelatedI 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
View Replies View RelatedOn 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%>
I am trying to connect to Oracle 9i Database Installed on Win 2000 Server using a DSN and i am getting the foll error :
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC driver for Oracle][Oracle]
/test/includes/openconn.asp, line 7
No error description
The line 7 is where I am opening the connection using
objConn.open "Dsn=test;uid=xxx;pwd=xxx;"
I am able to connect to the Oracle 9i Database using my SQL Plus and also thru Oracle Management Server
Does anyone know how to return data from an Oracle pakage using Oracle driver?
View Replies View RelatedAnyone 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:
View Replies View RelatedI am currently drawing up a sample server architecture for a windows environment,
from ASP is there any limitation on which Database one can work with, ie are MYSQL and Oracle supported ...