How Do I Learn MS SQL and What Is With This Server Stuff ??

[TNN]

I am new to SQL and ADO. Can anyone tell me the best way or any way to learn MS SQL and how to use it with ADO in VB6.0
and an access database.

What is this SQL server and MS SQL 7.0 server stuff?? I am using VB6.0 professional version and have met with limited success with my limited knowledge in using SQL with my access database. I don't think I have SQL 7.0 server unless it came with VB6.0 ??? Do I need it ???? If so Why??

I'm sure my ignorence is showing. But we all have to start somewhere. Any enlightening is appreciated.

Thank You,
TNN Tom

http://WWW.TNPAYROLL@AOL.COM

[sig]<p>TOM<br><a href=mailto:WWW.TNPAYROLL@AOL.COM>WWW.TNPAYROLL@AOL.COM</a><br>[/sig]

 

[Invicta]

Hi. That's a lot of questions.

SQL is &quot;Structured Query Language&quot; and it is used to query a database. It's a little like a programming language but it is very specialised.

An SQL Server is a server running a database management system (or database engine) that responds to SQL statements. &quot;MS SQL&quot; is Microsofts offering. Another very popular database management system is &quot;Oracle&quot;.

Access is also a database management system but it is primarily intended to run on a PC and serve just a few (often 1!) users simultaneously. The two I mentioned previously (MS SQL & Oracle) are designed to serve hundreds or even thousands of simultaneous users.

ADO (Active-x Data Objects) is one of a number of data access technologies. It provides the ability to connect to a database. This is an over simplification but it'll do for our purpose.

When you buy VB you don't get SQL Server just as you don't get Access with VB.

Now back to your first question. You can in fact start to learn SQL with what you already have because Access also supports a flavour of SQL. You need a trip to your local book store to find a book on SQL. You can also use ADO within VB to connect to your Access database and again you need a book on ADO.

You can of course buy SQL server but it isn't cheap and you'll need a fairly good machine to run it on. You can run it on your PC or a on separate server which is how it is intended to be run.

In any event it sounds like you have a long way to go and you should try to get involved with people who do this kind of thing. Good Luck. [sig][/sig]

 

[dneufarth]

Tom,

Microsoft was offering a free evaluation of SQL Server 7.0 Personal Edition (or something like that) that ran under Win98. Don't know if you can still get it or not. You can order an evaluation copy of SQL Server 2000 for $10. Try

http://www.microsoft.com.

Dave [sig][/sig]

 

[JohnAtSporgit]

There is a desktop verson of SQL Server 7.0 that comes many packages (MSDE.) Check the MS site to see if a package you own entitles you to a free copy. I imagine VB does.

Get a book on VB and SQL, I like books by WROX. Also, their ADO book teaches some SQL too. [sig][/sig]

 

[WP]

Try BEGINING Visual Basic SQL Server 7.0 by Thearon Willis. I bought this from Amazon for about GBP 25.00 [sig]<p>Bill Paton<br><a href=mailto:william.paton@ubsw.com>william.paton@ubsw.com</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

[/sig]