Microsoft SQL Server
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
User Name:
Password:
Remember me
 
Go Back   Dev Articles Community Forums > Databases > Microsoft SQL Server
Reload this Page

Basic Questions...

Discuss Basic Questions... in the Microsoft SQL Server forum on Dev Articles.
Basic Questions... Microsoft SQL Server forum discussing this extremely popular DBMS for the Windows operating system. Learn to optimize your SQL Server database for optimum application performance.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Display Modes
 
Unread Dev Articles Community Forums Sponsor:
  #1  
Old April 12th, 2002, 09:54 PM
wAr-AnGeL wAr-AnGeL is offline
Forum Security
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Apr 2002
Location: Behind You
Posts: 479 wAr-AnGeL User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 m 50 sec
Reputation Power: 7
Send a message via ICQ to wAr-AnGeL Send a message via AIM to wAr-AnGeL
Basic Questions...
I've never worked with Access/SQL Server before, only MySQL. Looking at the name, is SQL server similar to MySQL? What is an Access server? What is ODBC? Do they have tools like phpMyAdmin?

Thanks
__________________




"Only Linux users see the end of crashes."
- Pl4t0
Reply With Quote
  #2  
Old April 13th, 2002, 06:27 AM
» Matt M « » Matt M « is offline
red house painter
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Apr 2002
Location: South east England
Posts: 46 » Matt M « User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
Send a message via ICQ to » Matt M « Send a message via AIM to » Matt M «
odbc stands for open database connectivity

you get this control panel thing in windows to create data sources and specify drivers and paths

you can then use these from asp scripts and all sorts of other stuff.

SQL server can handle far larger databases and its more robust, access is a very good program for creating database functionality without any coding knowledge, so its more accessible to the world.

SQL server is a much more advanced step, but if you're good with MySQL then you could probably pick it up.

http://foldoc.doc.ic.ac.uk/foldoc/foldoc.cgi?query=odbc

thats my limited database knowledge out in the open!
Reply With Quote
  #3  
Old April 13th, 2002, 12:21 PM
mytch mytch is offline
Dev Articles Novice (500 - 999 posts)
  
Join Date: Apr 2002
Location: Sydney, Australia
Posts: 589 mytch User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 7
you may also like to read my article on beginning sql server. it'll clear up everything for you. just goto the sql server category on this site.
Reply With Quote
  #4  
Old April 13th, 2002, 11:51 PM
wAr-AnGeL wAr-AnGeL is offline
Forum Security
Dev Articles Newbie (0 - 499 posts)
  
Join Date: Apr 2002
Location: Behind You
Posts: 479 wAr-AnGeL User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 6 m 50 sec
Reputation Power: 7
Send a message via ICQ to wAr-AnGeL Send a message via AIM to wAr-AnGeL
On a Windows system, can I use php to query a MS SQL database? Would I still use the same kind of syntax?
Reply With Quote
Reply

Viewing: Dev Articles Community Forums > Databases > Microsoft SQL Server > Basic Questions...

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 6 hosted by Hostway. 
Stay green...Green IT