I need to connect from my ASP page to an access db which has also some Oracle tables linked.
I need to copy some oracle tables in some access table. I have 2 recordset for each "copy process" 1 reading data from oracle and 1 writing them in access.
But I have a big problem: I have to give user/password to ORACLE to use linked tbs.
I have password protected my Access database. I have ASP code that does not include in the password, I am not sure where to place it in the code - and every time it runs it comes up with an 500 internal server error message.
Here is a sample of the code:
.......................................
dim Conn, rs
set adoCn=server.createobject("ADODB.Connection")
adoCn.open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=True;Data Source=" & server.mappath("fpdb/database.mdb")
set rs=createobject("adodb.recordset")
.......................................
I have password protected my Access database. I have ASP code that does not include in the password, I am not sure where to place it in the code - and every time it runs it comes up with an 500 internal server error message...
Here is a sample of the code:
.......................................
dim Conn, rs
set adoCn=server.createobject("ADODB.Connection")
adoCn.open "Provider=Microsoft.Jet.OLEDB.4.0;Persist Security Info=True;Data Source=" & server.mappath("fpdb/database.mdb")
set rs=createobject("adodb.recordset")
.......................................
database.mdb is the password protected file, lets just say ABCD is the password.... how should it look?
I receive error when connecting to MS access DB with password.
Microsoft JET Database Engine error '80004005'
Could not find installable ISAM.
/lpo/common/cnlocalpo.asp, line 4
Here is my string:
cst = "Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:AccessDBLocalPOData.mdb; UID=admin; PWD=hello;"
What went wrong?
I am trying to encrypt the password and then store in Access DB. I have check out already existing threads on Sitepoint and read the artile at 15second.com (Password Encrypt/Decrypt using MDI ). It works for SQLServer. I tried it. It works..
But i am using MS Access Database, and it doesn't have any binary data type in it. So MDI is not working for me here. I havn't find any help.
I am looking for your help now as i have give it up and this thread is the only hope for me now. I need to Encrypt/Decrypt the password while using Access at backend.
I am trying to create a "Members Only" section of my website. I have an Access Database to store usernames and passwords and I am using Frontpage 2003.
I have very little ASP experience and am having trouble finding some help on this subject that is understandable. I already have a global.asa file on the site because I currently have a page with a form that writes to the database.
What I would like to know is how to setup a login screen to get to the members only side of the site which will validate against the password table in the database.
I am working on a CMS website which uses a access database.
When a user adds a page a record is added to a table in the database. The user choses the page style from a selection of 7 or 8 layouts.
I have been asked to find out if I can password protect one of those pages??
I have tried a few sites but not found much. The it has been done before is to add a password protected layout and build a login area into the site.
The effect i want is for the user to click the page and a username and password box will apear?
I have a client who wants to password protect a learning course that is set up in modules. Each module needs to have it's own password protection so users can only access them as they progress through the course.
Each user should have their own password (for each module) and, said client would like the password to expire for the user at some (predetermined?) point. Is this possible? It seems like a lot (in terms of setup), but I don't know much about password stuff.
If it is possible, can someone give me an overview of how it works (theoretically) or where to find more specific info on setting something like this up (in ASP.net)
If it isn't possible, can someone suggest what is more reasonable in terms of protecting the modules?
I created sessions to authenticate username and password. How can I utilize this same script to alert the user to change password at 3rd login? In other words when a user logs into a site after the 3 or 4th time which ever, they are prompted to change their password. Code:
View Replies View RelatedI'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.
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 ...
I'm writing an ASP page using an Oracle driver OraOLEDB.ORACLE and am getting the following error message:
"Multiple-step operation completed with one or more errors. Check each status value."
I cannot use the Microsoft MSDAORA driver because it will not work in my new environment.
Has anyone encountered this problem or know how to fix it?
am trying to connect to an oracle db. I'm not sure if I need a whole path or what am I doing wrong here?
Username = Request.Form ("UserName")
Password = Request.Form ("Password")
Source = request.form ("source")
If username="" Or Password="" Then
Session("Error_message") = "User name and password are required."
Response.Redirect("loginerrorentry.asp")
End If
Set conn = Server.CreateObject("ADODB.Connection")
Set rs = Server.CreateObject("ADODB.Recordset")
'original connection string
conn.ConnectionString = "msdaora.1;Password='" & Password & "';User ID='" & Username & "';Data Source="clscen;"
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'm searching some code samples that using blob data type with asp.
View Replies View Relatedi 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.
View Replies View RelatedI'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"
sqlstr = sqlstr & " where tbl_xzy_id = 4567"
What in the world is going on?
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?