• Re: Connecting to SQL Server

    From Enrico Maria Giordano@21:1/5 to All on Tue Feb 6 14:39:02 2024
    Il 31/01/2024 15:54, Jeff Barnes ha scritto:

    So this is going to sound very simple to those of you who use sql but I've have never used sql so here goes....

    All I need to do is:
    -Connect to the SQL server (Microsoft SQL Server)
    -Add a new record
    -Add the data to the record (2 fields "Name" and "ID")
    -Save and close

    I've looked at some posts but I see different people doing things different ways and now I'm confused.
    I should also mention that I've been out of the programming game for a while and am a bit rusty.

    Can anyone point me in the right direction?

    If you already know how to use ADO then you just have to use the correct connection string for MSSQL and maybe install a connector if it is not
    already pre-installed in your Windows system.

    If you don't know how to use ADO then I can provide you some samples.

    --
    Enrico Maria Giordano

    http://www.emagsoftware.it
    http://www.emagsoftware.it/emgmusic
    http://www.emagsoftware.it/spectrum
    http://www.emagsoftware.it/tbosg

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)