Online Database? HELP!

quote:

---

Original post by amemorex
I''m going to be attempting to make some sort of basic program that can send queries/recieve queries to an SQL server, but I need some major help.

Basically, I am hoping for my program to be able to do the following:

-Login to the SQL database that is stored on a server.
-Send the SQL database your IP address, have it store it under your username
-Have the program be able to recieve a list of all the IPS that are currently connected to the SQL server

Where can I go or what can I read to learn SPECIFICALLY what I stated above? Since I''m a beginner when it comes to online database accessing, I''d rather code this in Visual Basic using some sort of control, but I''m willing to do it from C++ if I must.

My friend is going to learn SQL and program the simple database which stores the usernames/IP''s, is there anything specific he should write in the database to work with the program I want to use?

Should I even be using SQL for the online database?

Basically, give me any pointers on where I can learn how to make my program communicate with the database. Thanks!

---

Public Sub LogUser (UserName as string, IPAddress as string)
    Dim rst as ADODB.Recordset

    set rst = New ADODB.Recordset

    with rst
        .Open "tblLog","provider=sqloledb;" _
            & "Sever=ServerName;Initial Catalog=DatabaseName;" _
            & "User ID=Name;password=whatever;", _
            adOpenDynamic, adOpenForwardOnly
        .AddNew
        !strIPAddress = IPAddress
        !strUserName = UserName
        .Update
        .Close
    end with

    set rst = nothing
End Sub