How to use Multiple database connection using ASP

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

balakrishnan.dinesh@gmail.com - 10 Sep 2008 08:41 GMT

Hi frndz

Im developing a web application.. Here im using oracle as my
database. In each necessary page im creating database connection and
recordset then connecting to database normally as given below.

Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Dim ConnectionString
ConnectionString = "Provider=OraOLEDB.Oracle.1;Persist Security
Info=False;Data Source=WEB;User ID=userid;Password=xxxxx"
Conn.Open ConnectionString

Set recordset = Server.CreateObject("ADODB.Recordset")

-------------------------------

My question is , How to use multiple connection to connect to the
database using ASP for different user login to my web application, or
i need to configure anything in ORACLE console to perform the multiple
connection

Rgrds
Dinesh.

Reply to this Message

paul@bullschmidt.com - 16 Sep 2008 01:38 GMT

On Sep 10, 2:41 am, balakrishnan.din...@gmail.com wrote:

> Hi frndz
>
[quoted text clipped - 20 lines]
> Rgrds
> Dinesh.

Perhaps try something like this:

Dim Conn
Set Conn = Server.CreateObject("ADODB.Connection")
Dim ConnectionString
ConnectionString = "Provider=OraOLEDB.Oracle.1;Persist Security
Info=False;Data Source=WEB;User ID=userid;Password=xxxxx"
Conn.Open ConnectionString
Set recordset = Server.CreateObject("ADODB.Recordset")

Dim Conn2
Set Conn2 = Server.CreateObject("ADODB.Connection")
Dim ConnectionString2
ConnectionString2 = "Provider=OraOLEDB.Oracle.1;Persist Security
Info=False;Data Source=WEB;User ID=userid;Password=xxxxx"
Conn2.Open ConnectionString2
Set recordset2 = Server.CreateObject("ADODB.Recordset")

Reply to this Message

Webmaster Forum / ASP / Database Access / September 2008

How to use Multiple database connection using ASP