Oracle Database On Unix Box
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?
View Replies
ADVERTISEMENT
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 Related
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.
View Replies
View Related
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.
View Replies
View Related
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:
View Replies
View Related
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"
View Replies
View Related
I 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:
View Replies
View Related
I need to do is display results of a command I run in UNIX, for example:
In the ASP page I'd have a textbox in which the user would type an UNIX command like "cat unixFile", after the user hits the "Execute Button" the results would be displayed in another textbox.
Basically my question is, how can I login to an UNIX server from ASP, send UNIX commands and capture the result?
View Replies
View Related
Is there a way to create directories using vb or jscript in IIS to a unix machine? I want to have the aility to upload files through my Win2k Web Server, and have those files stored on my Mac OS X Server under new directories based on date and Upload ID's from the Db.
View Replies
View Related
Simple quesion: Can you run ASP pages on a Unix server?
I am trying to learn "include files" and before I go any further I need to know if it can be used on a Unix server. IF NOT, what would be my options?
View Replies
View Related
I'm working on a proof of concept for ASP. I've already done it using Windows 2k server, IIS, using open source [no initial cost involved]. I'm looking to doing the same using a linux box. Does anyone know if this can be done without buying any additional tools?
View Replies
View Related
i have got someone who is interested in moving a ASP site to my hosting setup but my host is a UNIX platform. Actually i can see no reason for his site to be ASP cause it looks like a flat html site with .asp encoded pages.I just wondered what the experts think of running ASP on UNIX.
View Replies
View Related
In my pages i have to read a text file which is created in Unix format through my asp code. The problem is that the readline command reads the whole file and not line by line as the file is in Unix format. Is there a way to convert it using asp code and then read it or any other solution to this problem?
As the file is created by an application not controlled by myself it is impossible to force the application developer to do this job so i have to do it during runtime. So what are your suggestions?
View Replies
View Related
I am trying to replicate the Unix Timestamp,specifically the function
mktime() in Vbscript, ASP. I have the following so far:
ThisTime = DateSerial(2004, 9, 27) + TimeSerial(0, 0, 0)
response.write DateDiff("s", "12/31/1969 00:00:00", ThisTime)
This returns the timestamp: 1096329600, and when you decode that it comes
to: 27 Sep 2004 20:00. I want to set the time too, ie. show for example: 27
Sep 2004 16:15
View Replies
View Related
Please tell me how to execute a unix shell script from ASP?
Is it possible to pass the user id and password for the unix server as call parameters?
View Replies
View Related
Will ASP run on Unix/Linux software like Apache or Red Hat? If so what needs to be done to do this?
View Replies
View Related
I need to access a database on a MS SQL Sever from my unix apache web server.I would preferably want to continue to use ASP rather than go to PHP or Perl - I know that I need to build unixODBC on the web box, but do I need to do anything else other than reference the SQL server in unixODBC?
Has anyone used unixODBC? The console & CLI seem fairly self-explanatory... Do you need extra drivers to connect to a MS SQL box? Can I still use the same server.createobject & ADODB statements in my ASP code? Or do they need to change? Syntax etc?
View Replies
View Related
I currently use ADO (adoConn.Provider = "ADSDSOObject") to access user information in the domain Active Directory. I want to expand my application to be able to access user information in other LDAP compatable user lists (LINUX or UNIX for example). I did some
searching on deja.com (google groups) and microsoft's newsgroups, but couldn't find anything.
View Replies
View Related
i'm trying to use an odbc driver to connect from an asp page to a data source (dbase) on unix sunsolaris. is this poss?
the driver is installed though i cant seem to do it through dreamweaver ultradev - can i do it through the ftp connection?
what would i input as the source on the following to initiate the connection in the asp page?
"Provider= "MSDASQL"; Data Source= server name ?
"Database=test;User ID=sa;Password=blabla"
or how would i do it using the followign as an include file ? Code:
View Replies
View Related
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.
View Replies
View Related
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.
View Replies
View Related
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 Related
I know how to connect with Access.How can we connect ASP with oracle without mentioning the Data Source Name?
View Replies
View Related
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.
View Replies
View Related
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?
View Replies
View Related
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 Related
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.
View Replies
View Related
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?.
View Replies
View Related
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%>
View Replies
View Related
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
View Replies
View Related
Does anyone know how to return data from an Oracle pakage using Oracle driver?
View Replies
View Related
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:
View Replies
View Related
I 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 ...
View Replies
View Related
