access_asp thread: Urgent!Database Connectivity using DSN.
This is a multi-part message in MIME format.
------=_NextPart_000_0072_01C1B60B.BB3CE430
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
charset="iso-8859-1"
Hi Everyone,
Could someone plz. help me with ASP-Oracle8i connectivity code??
I do not have much idea about the oracle8i since i have worked on
asp-access connectivity..
BELOW IS THE CODE FOR DSN less connectivity of asp-access
Sub Application_OnStart
dbPath =3D "DBQ=3D" & Server.Mappath("trial.mdb")
dbConnectionString =3D "DRIVER=3D{Microsoft Access Driver (*.mdb)}; " &
dbPath
Set Application("Conn") =3D Server.CreateObject ("ADODB.Connection")
Application("Conn").Open dbConnectionString
End Sub
My doubt is how to make a database connection using DSN and how can i
define database path of oracle8i in my asp connectivity code??
Thanks,
Manju
------=_NextPart_000_0072_01C1B60B.BB3CE430
Content-Transfer-Encoding: quoted-printable
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html;
charset=3Diso-8859-1">
<META content=3D"MSHTML 5.50.4807.2300" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>Hi Everyone,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Could someone plz. help me with
ASP-Oracle8i
connectivity code??</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>I do not have much idea about the
oracle8i since i
have worked on asp-access connectivity..</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>BELOW IS THE CODE FOR DSN less
connectivity of
asp-access</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV>Sub Application_OnStart </DIV>
<DIV>dbPath =3D "DBQ=3D" & Server.Mappath("trial.mdb") </DIV>
<DIV>dbConnectionString =3D "DRIVER=3D{Microsoft Access Driver (*.mdb)};
" &
dbPath</DIV>
<DIV> Set Application("Conn") =3D Server.CreateObject
("ADODB.Connection")
</DIV>
<DIV>Application("Conn").Open dbConnectionString </DIV>
<DIV>End Sub</DIV>
<DIV> </DIV>
<DIV><FONT face=3DArial size=3D2>My doubt is how to make a database
connection using
DSN and how can i define database path of oracle8i in my asp
connectivity
code??</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT> </DIV>
<DIV><FONT face=3DArial size=3D2>Thanks,</FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Manju</FONT></DIV></BODY></HTML>
------=_NextPart_000_0072_01C1B60B.BB3CE430--