al4629740

<div>
I added it to my computer but that didn't work once I looked in the Connect field of VB6. &nbsp;Am I suppose to do this within the VB6 editor?&nbsp; I don't know where to look.
</div>


I added it to my computer but that didn't work once I looked in the Connect field of VB6.  Am I suppose to do this within the VB6 editor?  I don't know where to look.

<div>
I think I found it. &nbsp;I had to the Data Environment under Components. &nbsp;The only question is which one of these OLE DB Providers do I choose to connect to an MS SQL Server?<br><br><a href="https://filedb.experts-exchange.com/incoming/2020/11_w47/1542698/1605495236425.png" rel="ugc"><br><img src="https://filedb.experts-exchange.com/incoming/2020/11_w47/1542698/1605495236425.png" class="fr-fic fr-dib"></a><br>
</div>


I think I found it.  I had to the Data Environment under Components.  The only question is which one of these OLE DB Providers do I choose to connect to an MS SQL Server?


[https://filedb.experts-exchange.com/incoming/2020/11_w47/1542698/1605495236425.png]https://filedb.experts-exchange.com/incoming/2020/11_w47/1542698/1605495236425.png


1605495236425.png

<div>
Ok I chose OLE DB for SQL Server
</div>


<div>
<div class="content wysiwyg-content fr-view">
I have never used the data control in VB6. &nbsp;I am trying to make my form function just like MS Access so a person can scroll thru their records and make adjustments easily. &nbsp;The problem is I don't know how to connect to my database since I use a remote SQL database. &nbsp;How would I connect using this control?<br><br><a href="https://filedb.experts-exchange.com/incoming/2020/11_w46/1541287/1605296088079.png" rel="ugc"><img src="https://filedb.experts-exchange.com/incoming/2020/11_w46/1541287/1605296088079.png" class="fr-fic fr-dib"></a><br>
</div>
</div>


1605296029436.png

1605296088079.png


I have never used the data control in VB6.  I am trying to make my form function just like MS Access so a person can scroll thru their records and make adjustments easily.  The problem is I don't know how to connect to my database since I use a remote SQL database.  How would I connect using this control?

Data Control connection to SQL in 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.