Re: General SQL/ODBC question

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Sue Hoegemeier (Sue_H_at_nomail.please)
Date: 01/14/05 

Date: Fri, 14 Jan 2005 11:15:05 -0700

Hi Margaret,
In order to practice SQL, you will need some type of
relational database to use. Query tools will connect to
databases in different ways - it depends on the tool and it
depends on what database you are trying to connect to.
In terms of MS Query, it comes with Microsoft Office. If you
have installed Office, search for the file MSQRY32.EXE
What database are you trying to use or do you have available
to use. Is Microsoft Access installed on your PC? You could
use that to learn SQL. Otherwise, you can download an
evaluation version of SQL Server. The link to register and
download the evaluation edition is:
http://www.microsoft.com/sql/evaluation/trial/default.asp
There is also a development version of SQL Server that you
can get for pretty cheap - it's just $50.00. You can find
more information on purchasing this version at:
http://www.microsoft.com/sql/howtobuy/development.asp

How you do what and what query tools you use is really going
to be determined by what database you use. So you really
want to start there.

-Sue

On Thu, 13 Jan 2005 13:55:03 -0800, MargaretM
<MargaretM@discussions.microsoft.com> wrote:

>Hello,
>
>I do not have much of a programming background at all, so I am not sure how
>to ask this, so I will try to keep it brief:
>
>I am trying to teach myself SQL programming on my home PC using Windows XP
>(using the book "Teach yourself SQL in 10 min."). I searched my PC and do
>not have MS Query, but I downloaded George Poulose's free Query Tool from the
>web. I am trying to understand the requirements to get started, if that is
>even possible.
>
>I just would like to run the short example scripts in this simple book, to
>create simple tables. So I followed the book's instructions and went to the
>Windows explorer, found the Administrative Tools folder and found "ODBC Data
>Sources". However, this is where I get confused: I apparently need to select
>a driver and a connection to a database here in order to use the Query Tool.
>I am not sure what this means, and the Help menu here was not detailed
>enough. I do not think I have the 'database' required.
>
>Any advice at all would be greatly appreciated.
>Thank you.

Relevant Pages

  • Charonware Announces New Releases of its Database Query Tools
    ... Charonware Announces New Releases of its Database Query Tools ... releases of its database query tools Foxy SQL Pro v. 1.1 and Foxy SQL ...
    (comp.software.shareware.announce)
  • Downloading Files stored in SQL Server
    ... I am trying to download files from my database that I uploaded to it. ... d/l pdf files stored in the file system but not in the database. ... Set rs = db.Execute(SQL) ...
    (microsoft.public.inetserver.misc)
  • Downloading Files stored in SQL Server
    ... I am trying to download files from my database that I uploaded to it. ... d/l pdf files stored in the file system but not in the database. ... Set rs = db.Execute(SQL) ...
    (microsoft.public.inetserver.asp.db)
  • Downloading Files stored in SQL Server
    ... I am trying to download files from my database that I uploaded to it. ... d/l pdf files stored in the file system but not in the database. ... Set rs = db.Execute(SQL) ...
    (microsoft.public.inetserver.asp.general)
  • Re: Which Data Type for Storing Files
    ... to fit in VARBINARY or VARCHAR then you can use those. ... > I'm trying to create a website which I will upload files into a SQL ... > database, and then later be able to download them. ...
    (microsoft.public.sqlserver.server)