SunQuest
           Beginner Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed ForumsOtherBeginner Programming

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
  #1  
Old August 1st, 2001, 10:15 AM
David Graham David Graham is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
 
Join Date: Jul 2001
Location: cheshire
Posts: 52 David Graham User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 8
Unhappy mysql/ODBC

Hi
I hope my post is going to an appropriate place?
I am a student and have been given a dodgy set of notes relating to MySql
and I can't get help from my lecturer as he is on holiday.
Basically I have only just started with MySql and have a 1001 questions,
below are just a few:

1. I have downloaded a php-triad containing Apache, php, and MySql. I have
managed to get MySql to work via a command prompt. I have made a database
and added a table to it. However, I have no idea where on my PC's HD that
the newly created DB lives!

2. My lecturer's notes dive into something called ODBC so I have downloaded
myodbc but I'm not sure if I needed it or not. Can anyone explain what I can
do with it? In the notes from my lecturer it says go into the control panel
(my OS is Win98) and double click the ODBC icon and check if you have
'MySqlODBC driver' installed. I can't find anything with that exact name
under the drivers tab (one entry says SQL server - is that it?) If I need to
install it - from where? how? (there is no helpful 'add' button it just says
to add drivers use the drivers program?????? - again what?, where? Anyway,
next bit of non - helpful notes says 'Enter a system/user/file DSN entry for
the database' - I assume the database referred to is the one I just created
using mysql>CREATE DATABASE friends(surname CHAR(30) DEFAULT'' NOT NULL,
firstname CHAR(25) DEFAULT''); BTW is it two single qoutes after DEFAULT
as I used or a single double qoute - they look identical on paper?
What do I add for the system/user/file DSN entry?

3. I think phpMyAdmin is a GUI type of interface for creating
databases/tables etc - is that correct? Do I need a host name/user
name/password to use it? Again, where does it put the database that you
create. I asked about host name/user name/password because my ISP has
provided a database facility for my web site and I need those bits of info
for that.

I could go on for ever but I'm conscious of the ever growing length of this
post - well if I get an answer to even some of this stuff I'll be very
pleased.
Thanks
David
__________________
Dave Graham

Reply With Quote
  #2  
Old August 29th, 2001, 09:30 AM
pieux pieux is offline
Seņor Member
Dev Shed Beginner (1000 - 1499 posts)
 
Join Date: Aug 2000
Posts: 1,156 pieux User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: 1 h 17 m 59 sec
Reputation Power: 9
Have you tried reading the documentation? <http://www.mysql.com/>
__________________
Michael

Reply With Quote
Reply

Viewing: Dev Shed ForumsOtherBeginner Programming > mysql/ODBC


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
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 2 hosted by Hostway