Cette action est irreversible, confirmez la suppression du commentaire ?
Signaler le commentaire
Veuillez sélectionner un problème
Nudité
Violence
Harcèlement
Fraude
Vente illégale
Discours haineux
Terrorisme
Autre
Guy DETIENNE
Salut ;O)
Voilà comment je me connecte via OleDB.
Dim ADO_Connection As ADODB.Connection Set ADO_Connection = New ADODB.Connection
Dim NETWORK_LIBRARY as String Dim DATASOURCE as String Dim INITIALCATALOG as String Dim USERID as String Dim PWD as String
NETWORK_LIBRARY = "DBMSSOCN" '-> Cette valeur ne change a priori rarement DATASOURCE = "MonServeurSQL" '-> L'adresse IP ou le HostName INITIALCATALOG = "LeNomDeLaDB" USERID ="ADMIN" PWD = "MonPassword"
mais je ne sais pas comment remplacer UID et PW tout en gardant le servr
et
la database ?
Merci d'avance Muller Guy
Salut ;O)
Voilà comment je me connecte via OleDB.
Dim ADO_Connection As ADODB.Connection
Set ADO_Connection = New ADODB.Connection
Dim NETWORK_LIBRARY as String
Dim DATASOURCE as String
Dim INITIALCATALOG as String
Dim USERID as String
Dim PWD as String
NETWORK_LIBRARY = "DBMSSOCN" '-> Cette valeur ne change a priori rarement
DATASOURCE = "MonServeurSQL" '-> L'adresse IP ou le HostName
INITIALCATALOG = "LeNomDeLaDB"
USERID ="ADMIN"
PWD = "MonPassword"
Dim ADO_Connection As ADODB.Connection Set ADO_Connection = New ADODB.Connection
Dim NETWORK_LIBRARY as String Dim DATASOURCE as String Dim INITIALCATALOG as String Dim USERID as String Dim PWD as String
NETWORK_LIBRARY = "DBMSSOCN" '-> Cette valeur ne change a priori rarement DATASOURCE = "MonServeurSQL" '-> L'adresse IP ou le HostName INITIALCATALOG = "LeNomDeLaDB" USERID ="ADMIN" PWD = "MonPassword"