Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access_asp thread: Urgent!Database Connectivity using DSN.


Message #1 by "manju_jacob" <manju_jacob@m...> on Fri, 15 Feb 2002 10:30:04 +0530
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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</DIV>

<DIV>Sub Application_OnStart </DIV>

<DIV>dbPath =3D "DBQ=3D" &amp; Server.Mappath("trial.mdb") </DIV>

<DIV>dbConnectionString =3D "DRIVER=3D{Microsoft Access Driver (*.mdb)}; 

" &amp;

dbPath</DIV>

<DIV>&nbsp;Set Application("Conn") =3D Server.CreateObject 

("ADODB.Connection")

</DIV>

<DIV>Application("Conn").Open dbConnectionString </DIV>

<DIV>End Sub</DIV>

<DIV>&nbsp;</DIV>

<DIV><FONT face=3DArial size=3D2>My doubt is how to make a database 

connection using

DSN and how can i&nbsp;define database path of oracle8i in my asp 

connectivity

code??</FONT></DIV>

<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</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--




  Return to Index