Home > How-To Library > Database

How to create an OLE DB connection to Northwind SQL Server database.

****************************************************************
*       © 2007 CodeItBetter http://www.codeitbetter.com        *
*          This notice MUST stay intact for legal use          *
****************************************************************

Dim conn As Connection

DBconn = "Provider=SQLOLEDB;Integrated Security=SSPI;" & "Initial Catalog=Northwind;Data Source=yourserver;"
Set conn = server.CreateObject("ADODB.connection")
conn.Open DBconn

If you would like to submit your code here please us. Do not forget to mention your name. We are always thankful to each and everyone of you who submitted their code here.