How to use Multiple database connection using ASP

[balakrish...@gmail.com]

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.

[pa...@bullschmidt.com]

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")