Hi Guys,
I am designing an application using oracle 7.0 and ASP 3.0
it generates following errors
1- Their is some client components not exist etc.(it has been solved
after installing its required components)
2-Application is Attempting to Call OCI function <opinit> and it does
not exist in ORA72.DLL
3-Application is Attempting to Call OCI function <odefinpst> and it
does not exist in ORA72.DLL
error 2,3 are creating problems due oracle Component "Oracle Call
Interface 7.0" now
4- I successfully installed Oracle 7.0 on my friend PC here following
code works fine but it generates error when I want to display database
value using "response.write objrs("empno"). O.S I have used is win98
'---------------------------------Code
Started---------------------------------
<%@ Language=3DVBScript %>
<HTML>
<HEAD>
<META NAME=3D"GENERATOR" Content=3D"Microsoft Visual Studio 6.0">
</HEAD>
<BODY>
<%
Dim objRS, objCommand, strConnection
Set objCommand =3D Server.CreateObject("ADODB.Command")
strConnection =3D "Provider=3DMSDAORA.1;User ID=3Dscott;
Password=3Dtiger;"
objCommand.ActiveConnection =3D strConnection
'objCommand.CommandText =3D "DELETE Emp WHERE EmpNo =3D 9000"
'Set objRS =3D objCommand.Execute
objCommand.CommandText =3D "SELECT * FROM Emp"
Set objRS =3D objCommand.Execute
Set objCommand =3D Nothing
While Not objRS.EOF
Response.Write objRS("empno") 'HERE IS PROBLEM
objRS.MoveNext
Wend
Set objRS =3D Nothing
%>
</BODY>
</HTML>
'---------------------------------Code
Ended---------------------------------
.Awaiting prompt reply from all of you.
Yasir
View Cart
