SQL / ODBC avec DSN / authentification windows

Bonjour,

essaye avec le code suivant :

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19

' Visual Basic
Public Sub ConnectToSql()
    Dim conn As New SqlClient.SqlConnection
    ' TODO: Modify the connection string and include any
    ' additional required properties for your database.
    conn.ConnectionString = & _
    "integrated security=SSPI;data source=Nomdel'instance;" & _
    "persist security info=true;initial catalog=TaBase"
    Try
        conn.Open()
        ' Insert code to process data.
    Catch ex As Exception
        MessageBox.Show("Failed to connect to data source")
    Finally
        conn.Close()
    End Try
End Sub

Au besoin un peu d'aide :

https://msdn.microsoft.com/fr-fr/lib...(v=vs.71).aspx
https://support.microsoft.com/fr-fr/kb/308656

Julien