<div>
I don't hink it takes some one from mensa to say &quot;Yep, sure looks different to me.&quot;<br />
<br />
I'll be nothing until it's initialized by say something like <br />
set mConnection = new adodb.connection<br />
at that point you will begin to see it as &quot;&quot;
</div>


I don't hink it takes some one from mensa to say "Yep, sure looks different to me."

I'll be nothing until it's initialized by say something like
set mConnection = new adodb.connection
at that point you will begin to see it as ""

<div>
Since mConnection is an Object, clearing it is done by Set mConnection = Nothing. &nbsp;Setting it to an empty string might just be sloppy work on the previous developer's part. 
</div>


Since mConnection is an Object, clearing it is done by Set mConnection = Nothing.  Setting it to an empty string might just be sloppy work on the previous developer's part.

<div>
jim I don't think Tung is setting the connection object to a connection string I think they were just illustrating it's value while looking at it at a certain poink.
</div>


jim I don't think Tung is setting the connection object to a connection string I think they were just illustrating it's value while looking at it at a certain poink.

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I created a variable called:<br />
<br />
Private mConnection As ADODB.Connection<br />
<br />
<br />
At some point of my debugging process, sometimes I see that<br />
<br />
mConnection = &quot;&quot;<br />
<br />
and sometimes <br />
<br />
mConnection = Nothing<br />
<br />
<br />
I know what nothing is, but is there a difference btw mConnection = &quot;&quot;&nbsp;and mConnection = Nothing<br />
<br />
<br />
<br />
Thx
</div>
</div>


Hi,

I created a variable called:

Private mConnection As ADODB.Connection


At some point of my debugging process, sometimes I see that

mConnection = ""

and sometimes 

mConnection = Nothing


I know what nothing is, but is there a difference btw mConnection = "" and mConnection = Nothing



Thx

Question on ADODB.Connection with VB6

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.