<div>
Try creating another Workspace object, and open the other database in that Workspace.<br />

</div>


Try creating another Workspace object, and open the other database in that Workspace.


<div>
<div class="content wysiwyg-content">
Using ODBC ver2 to connect to an Oracle 7.3 database I get an error if I connect as a second user name, even if it is <br />
a different database object. I can connect to two different<br />
oracle databases without a problem. &nbsp;I am using VB4 and the<br />
standard database object. &nbsp;Is there a way to dissconnect the<br />
first session or something. &nbsp;My code looks something like this:<br />
<br />
dim db1 as database, db2 as database, rs as recordset<br />
<br />
set db = opendatabase(&quot;MyDSn&quot;,false<wbr />,true,&quot;ODB<wbr />C;uid=user<wbr />1;pwd=pwd1<wbr />&quot;)<br />
set rs = db.openrecordset(sql,dbope<wbr />nsnapshot,<wbr />dbsqlpasst<wbr />hrough)<br />
opendatabase(&quot;MyDSn&quot;,false<wbr />,true,&quot;ODB<wbr />C;uid=user<wbr />2;pwd=pwd2<wbr />&quot;)<br />
set rs = db.openrecordset(sql2,dbop<wbr />ensnapshot<wbr />,dbsqlpass<wbr />through)<br />
<br />
The error happens on the last line. If I reverse the order it is always the latter one that fails.
</div>
</div>


Using ODBC ver2 to connect to an Oracle 7.3 database I get an error if I connect as a second user name, even if it is 
a different database object. I can connect to two different
oracle databases without a problem.  I am using VB4 and the
standard database object.  Is there a way to dissconnect the
first session or something.  My code looks something like this:

dim db1 as database, db2 as database, rs as recordset

set db = opendatabase("MyDSn",false,true,"ODBC;uid=user1;pwd=pwd1")
set rs = db.openrecordset(sql,dbopensnapshot,dbsqlpassthrough)
opendatabase("MyDSn",false,true,"ODBC;uid=user2;pwd=pwd2")
set rs = db.openrecordset(sql2,dbopensnapshot,dbsqlpassthrough)

The error happens on the last line. If I reverse the order it is always the latter one that fails.

Connecting to oracle under two different uid's

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.