Dim db As MSSQL
Dim L As List
db = setDatabase("Server IPNUMBER (not name)","databasename","username","password")
Try
'select query
L = db.Query("select * from tablename") '--> return rows as a LIST
L = db.TableList '--> return table list in database
' or update query (True: If need transactional query)
db.ExecuteNonQuery("update tablename set fieldname = 'forexample' where key=1",True)
Catch
MsgBox(LastException.Message,"Error Occured")
End Try
.
.
.