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 34 35 36 37 38 39 40 41 42 43 44 45 46
| ==========
Option Explicit
main
Function SQL_connect()
Dim connect
Dim recst
Dim connectState
Dim SQLQuery
Dim ConnectionString
Dim get_reslt
Set connect = createobject("ADODB.Connection")
ConnectionString = "Provider=SQLOLEDB; Data Source=SRVPROD1; Initial Catalog=caischdb; uid=xx; pwd=xxx"
connect.Open ConnectionString
If connect.State = 1 Then
connectState = "open"
MsgBox "Connected to database :"
Else
connectState = "closed"
MsgBox "Not connected to database :"
End If
'Construction de la requete SQL
SQLQuery = "Select * from dbo.JTR_matab"
'Ouverture du recorset et execution de la requete sql
Set recst = Connect.Execute(SQLQuery)
If (Err.Number <> 0) Then
err_log "Erreur", SQLQuery, "Impossible d'exécuter la requête"
End If
On Error Resume Next
recst.MoveFirst
Do While Not recst.eof
MsgBox "Result :" & recst("jtr_scdn") & " , " & recst("jtr_name")
recst.MoveNext
Loop
recst.Close
connect.Close
Set connect = Nothing
End Function
Function main()
Call SQL_connect
End Function |
Partager