Message-ID:

A LISP programmer knows the value of everything, but the cost of nothing. -- Alan Perlis

devel / comp.lang.xharbour / Connecting to SQL Server

Connecting to SQL Server

<9fcddc7b-b00b-4312-a940-4b6ab8aa8f20n@googlegroups.com>

https://www.rocksolidbbs.com/devel/article-flat.php?id=18632&group=comp.lang.xharbour#18632

copy link Newsgroups: comp.lang.xharbour

X-Received: by 2002:a05:620a:4155:b0:785:3f1b:e8b8 with SMTP id k21-20020a05620a415500b007853f1be8b8mr37837qko.11.1706712884167;
Wed, 31 Jan 2024 06:54:44 -0800 (PST)
X-Received: by 2002:a05:6808:3187:b0:3be:c44b:fc6c with SMTP id
cd7-20020a056808318700b003bec44bfc6cmr67011oib.5.1706712883569; Wed, 31 Jan
2024 06:54:43 -0800 (PST)
Path: i2pn2.org!i2pn.org!weretis.net!feeder8.news.weretis.net!proxad.net!feeder1-2.proxad.net!209.85.160.216.MISMATCH!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: comp.lang.xharbour
Date: Wed, 31 Jan 2024 06:54:43 -0800 (PST)
Injection-Info: google-groups.googlegroups.com; posting-host=76.71.160.186; posting-account=FST9bwoAAACq2TGYm2d5gcKLEXjRVWoI
NNTP-Posting-Host: 76.71.160.186
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <9fcddc7b-b00b-4312-a940-4b6ab8aa8f20n@googlegroups.com>
Subject: Connecting to SQL Server
From: cansoft6363@gmail.com (Jeff Barnes)
Injection-Date: Wed, 31 Jan 2024 14:54:44 +0000
Content-Type: text/plain; charset="UTF-8"

by: Jeff Barnes - Wed, 31 Jan 2024 14:54 UTC

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?

Re: Connecting to SQL Server

<uptcpl$t8ih$1@dont-email.me>

copy mid

https://www.rocksolidbbs.com/devel/article-flat.php?id=18633&group=comp.lang.xharbour#18633

copy link Newsgroups: comp.lang.xharbour

Path: i2pn2.org!i2pn.org!eternal-september.org!feeder3.eternal-september.org!news.eternal-september.org!.POSTED!not-for-mail
From: e.m.giordano@emagsoftware.it (Enrico Maria Giordano)
Newsgroups: comp.lang.xharbour
Subject: Re: Connecting to SQL Server
Date: Tue, 6 Feb 2024 14:39:02 +0100
Organization: A noiseless patient Spider
Lines: 31
Message-ID: <uptcpl$t8ih$1@dont-email.me>
References: <9fcddc7b-b00b-4312-a940-4b6ab8aa8f20n@googlegroups.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Injection-Date: Tue, 6 Feb 2024 13:39:01 -0000 (UTC)
Injection-Info: dont-email.me; posting-host="d5479f03f5aa8165d9f2373ff21989f3";
logging-data="959057"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19xS5WZf4H68i/nvwQ3qt6a"
User-Agent: Mozilla Thunderbird
Cancel-Lock: sha1:UL6s5E5ySkKUDqrH4RIvNMifg1w=
In-Reply-To: <9fcddc7b-b00b-4312-a940-4b6ab8aa8f20n@googlegroups.com>
Content-Language: it

by: Enrico Maria Giordan - Tue, 6 Feb 2024 13:39 UTC

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

Subject	Author
Connecting to SQL Server	Jeff Barnes
Re: Connecting to SQL Server	Enrico Maria Giordano