1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33
| Dim strDriver As String, strAttr As String, retVal As Long
Dim pfErrorCode As Long, pcbErrorMsg As Long, lpszErrorMsg As String, i As Integer
' Nom du pilote ODBC
strDriver = "MySQL ODBC 5.1 Driver" & vbNullChar
' Minimum fonctionnel requis
strAttr = "DSN=" & "ESSAI MySQL" & vbNullChar
' facultatif
strAttr = strAttr & "SERVER=LZ2" & vbNullChar
strAttr = strAttr & "DATABASE=medipacs" & vbNullChar
strAttr = strAttr & "Description=ESSAI DSN MySQL" & vbNullChar
strAttr = strAttr & "OPTION=3" & vbNullChar
strAttr = strAttr & "UID=root" & vbNullChar
strAttr = strAttr & "PWD=toto" & vbNullChar
' Terminaison
strAttr = strAttr & vbNullChar
retVal = SQLConfigDataSource(0, ODBC_ADD_SYS_DSN, strDriver, strAttr)
If retVal = 0 Then
i = 0
Do
i = i + 1
lpszErrorMsg = String(2048, vbNullChar)
retVal = SQLInstallerError(i, pfErrorCode, lpszErrorMsg, 2047, pcbErrorMsg)
If retVal = SQL_SUCCESS_WITH_INFO Then retVal = SQL_SUCCESS
If retVal = SQL_SUCCESS Then MsgBox Left(lpszErrorMsg, pcbErrorMsg)
Loop Until (retVal <> SQL_SUCCESS Or i = 8)
End If
End Function |
Partager