• Home
 · 
• Databases/Data Access/DAO/ADO
 · 
• Connect to a SQL Server

Connect to a SQL Server

Connect to a SQL Server

Rate Connect to a SQL Server

• 1
• 2
• 3
• 4
• 5

(2(2 Vote))

' For more code snippets and 
' forums please visit...
' http://www.coderhq.com


Set Conn = CreateObject("ADODB.CONNECTION")

Server = "MYSERVER"
Database = "MYDATABASE"
Username = "MYUSER"
Password = "MYPASS"

Conn.Open "Provider=sqloledb;SERVER=" & Server & ";DATABASE=" & Database & ";UID=" & Username & ";PWD=" & Password