How to create an OLE DB connection to Northwind SQL Server database.
Posted on September 19, 2011
1 2 3 4 5 6 | 'Database - How to create an OLE DB connection to Northwind SQL Server database. 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 |