<div>
dim MyConn as adodb.connection<br />
dim gConnectString as string<br />
gConnectString = &quot;Provider=SAOLEDB;DSN=Your<wbr />DatabaseOD<wbr />BCNAME;OLE<wbr /> DB Services = 0&quot;<br />
&nbsp;myConn.open gConnectString<br />
<br />
<br />

</div>


dim MyConn as adodb.connection
dim gConnectString as string
gConnectString = "Provider=SAOLEDB;DSN=YourDatabaseODBCNAME;OLE DB Services = 0"
 myConn.open gConnectString




<div>
<div class="content wysiwyg-content">
Could anyone provide a snippet of code that shows how to connect to an SQL Server database using VB6? &nbsp;I assume ODBC is the way to go? &nbsp;Or maybe ADO? 
</div>
</div>


Could anyone provide a snippet of code that shows how to connect to an SQL Server database using VB6?  I assume ODBC is the way to go?  Or maybe ADO? 

Connect to MS SQL Server using VB6

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).