Public Function Connexion(ByVal DB As String, ByVal User As String, ByVal Pwd As String) As ADODB.Connection Set Connexion = New ADODB.Connection connex.CursorLocation = adUseServer connex.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=127.0.0.1;DATABASE=" & DB & ";USER=" & User & ";PASSWORD=" & Pwd & ";OPTION=35" Connexion.Open End Function
Public Function Connexion(ByVal DB As String, ByVal User As String, ByVal Pwd As String) Set Connexion = New ADODB.Connection 'connex.CursorLocation = adUseServer Connexion.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=127.0.0.1;DATABASE=" & DB & ";USER=" & User & ";PASSWORD=" & Pwd & ";OPTION=35" End Function
Public Function Connexion(ByVal DB As String, ByVal User As String, ByVal Pwd As String) Set Connexion = New ADODB.Connection 'connex.CursorLocation = adUseServer Connexion.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=127.0.0.1;DATABASE=" & DB & ";USER=" & User & ";PASSWORD=" & Pwd & ";OPTION=35" End Function
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim connex As ADODB.Connection Dim serv_db As String Dim datbase As String Dim user_db As String Dim pwd_user_db As String Dim option_db As Integer serv_db = "127.0.0.1" datbase = "essai" user_db = "root" pwd_user_db = "" option_db = 35 Set connex = New ADODB.Connection connex.CursorLocation = adUseServer connex.Open "DRIVER={MySQL ODBC 3.51 Driver};SERVER=" & serv_db & ";DATABASE=" & datbase & ";USER=" & user_db & ";PASSWORD=" & pwd_user_db & ";OPTION=" & option_db