how to connect to an Microsoft Sql database 1

[radubalmus]

i know how to connect to an acces database, but i need to switch to Microsoft SQL, knowing the server, database name, user and password..
can give me some pointers..

Thanks in advance

There are simple solutions for almost every problem! The hard part is to see them!!!!

 

[Rofeu]

Start of with something like this:

Const SQLSERVER_CONNECTION As String = "Provider=sqloledb;Data Source=ServerName;Initial Catalog=DataBaseName;Integrated Security=SSPI;"

Dim MyConnection As ADODB.Connection
Dim MyRecordSet As ADODB.Recordset
Dim MyCommand As ADODB.Command
Dim MyMessage As String

Set MyConnection = New ADODB.Connection
With MyConnection
    .ConnectionString = SQLSERVER_CONNECTION
    On Error Resume Next
    .Open
    If Err.Number <> 0 Then
        MsgBox "SQLServer Connection could not be established."
        Err.Clear
        On Error GoTo 0
        blnOffline = True
        GoTo ClearMem
    End If
End With

There's actually a ver clear topic in the Excel help when looking for ADO connections.


Also check

http://www.connectionstrings.com/

for the different connection strings you can use.

Cheers,

Roel

 

[Remou]

You need

http://www.connectionstrings.com

 

[radubalmus]

thanks a lot Remou,
we saved me a lot of time searching the net

There are simple solutions for almost every problem! The hard part is to see them!!!!