Function test()
On Error Resume Next
Set obj = CreateObject("ADODB.Connection")
Set obj1 = CreateObject("ADODB.RecordSet")
Dim dbquery
dbquery = "INSERT INTO test (firstname,lastname) VALUES ('neha','deshmukh');"
obj.Open "Server=db4free.net;Data Source=mysql; Database=sumit1234; User=sumit1234; Password=sumit1234;"
MsgBox obj1.State & ""
MsgBox Err.Description
obj1.Open dbquery, obj
MsgBox Err.Description
obj.Close
obj1.Close
Set obj1 = Nothing
Set obj = Nothing
End Function
On Error Resume Next
Set obj = CreateObject("ADODB.Connection")
Set obj1 = CreateObject("ADODB.RecordSet")
Dim dbquery
dbquery = "INSERT INTO test (firstname,lastname) VALUES ('neha','deshmukh');"
obj.Open "Server=db4free.net;Data Source=mysql; Database=sumit1234; User=sumit1234; Password=sumit1234;"
MsgBox obj1.State & ""
MsgBox Err.Description
obj1.Open dbquery, obj
MsgBox Err.Description
obj.Close
obj1.Close
Set obj1 = Nothing
Set obj = Nothing
End Function
No comments:
Post a Comment