There's no such thing as a stupid question, but they're the easiest to answer.
JoinTour
Login
 
Tag Cloud
access audio avg avg 8 bios blue screen boot bsod computer connection cpu crash css dell desktop dma driver drivers dvd email error excel explorer firefox firefox 3 freeze gimp graphics hard drive hardware hijackthis hjt install internet internet explorer itunes keyboard laptop macro malware monitor motherboard network networking outlook outlook 2003 outlook 2007 outlook express pio problem problems router seo server slow sound sp3 spyware trojan usb video virtumonde virus vista vundo windows windows vista windows xp winxp wireless
Web Design & Development
Search
Search in:
 
Advanced Search
Tech Support Guy Forums > Internet & Networking > Web Design & Development >
My SQL


HELLO AND WELCOME! Before you can post your question, you'll have to register -- it's completely free! Click here to join today! We highly recommend that you print a copy of our Guide for New Members. Enjoy!

 
Thread Tools
reaper616's Avatar
Senior Member with 336 posts.
 
Join Date: Jul 2006
Location: Lincoln, United Kingdom
Experience: Self taught/teaching
12-May-2007, 03:58 PM #1
My SQL
Just got an apache server working with PHP working, and downloaded phpbb.....now when I run the installer for the phpbb through the ftp it comes up with this:


Could not connect to the database, see error message below
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified


I have downloaded phpbb version 3.0....could someone help me?
doctoremote's Avatar
Computer Specs
Junior Member with 23 posts.
 
Join Date: May 2007
Experience: Advanced
12-May-2007, 04:06 PM #2
Why bother with all this. You can download the full package preintergrated FREE (donations if you want) for Apache webserver PHP and Mysql. Goto http://www.wampserver.com/en/ and all your problems will be fixed.

If you start getting errors after this then its your PHP programming. :-)
reaper616's Avatar
Senior Member with 336 posts.
 
Join Date: Jul 2006
Location: Lincoln, United Kingdom
Experience: Self taught/teaching
12-May-2007, 04:09 PM #3
I got Wamp working thanks for that

But once again, I am stuck. Pretty much all I need help with is setting up and SMF forum using Wamp.....I have got to the config/install page where it asks for the sql database name and everything but I don't know how to set this up

Would someone be kind enough to guide me through this?

Last edited by reaper616 : 13-May-2007 03:05 AM.
reaper616's Avatar
Senior Member with 336 posts.
 
Join Date: Jul 2006
Location: Lincoln, United Kingdom
Experience: Self taught/teaching
13-May-2007, 08:35 AM #4
Any help on this one?
doctoremote's Avatar
Computer Specs
Junior Member with 23 posts.
 
Join Date: May 2007
Experience: Advanced
13-May-2007, 08:57 AM #5
If you download Mysql Admin you can set up your database name, back it up alter permissions etc. dowload here http://www.softpedia.com/get/Interne...-Windows.shtml
With Mysql you need the server IP address
This will be the local ip address of your machine. Mysql will allocate the correct ports for you. You must allow the port 3306 on the server machine through the firewall else nothing will happen.
What exactly are you trying to do as wamp does most things for you including PHPadministrator?
reaper616's Avatar
Senior Member with 336 posts.
 
Join Date: Jul 2006
Location: Lincoln, United Kingdom
Experience: Self taught/teaching
13-May-2007, 11:41 AM #6
All I am trying to do is install SMF forums. I get the the install working but it asks me for:
MySQL server name:
MySQL username:
MySQL password:
MySQL database name:
MySQL table prefix:

Could you tell me what to put in these fields, and if something needs setting up for one of the fiels what is it

Thanks for you help so far
doctoremote's Avatar
Computer Specs
Junior Member with 23 posts.
 
Join Date: May 2007
Experience: Advanced
13-May-2007, 11:58 AM #7
You need to set up the database in mysql this is what the package is doing.
the meanings for the above are :-
MySQL server name: This is where we specify the location of the MySQL database.. 99% of the time this will be localhost if run on the same machine or the ip address if another machine on the network.
MySQL username: This is the Username for your MySQL database. You set this up with Mysql Admin or PHP Admin
MySQL password: This is the password for your MySQL database. You set this up with Mysql Admin or PHP Admin
MySQL Database name: This is the name of your MySQL database. call this what you like.
MySQL Database prefix: This is a prefix to the table names in your database. It enables you to run more than one application on a single MySQL database. You should generally leave it as smf_, unless you are installing a second copy of SMF on the same database.
There is a full manual about this package at http://docs.simplemachines.org/index.php
reaper616's Avatar
Senior Member with 336 posts.
 
Join Date: Jul 2006
Location: Lincoln, United Kingdom
Experience: Self taught/teaching
13-May-2007, 05:13 PM #8
Ok, I have one up and running now but for some reason when some accesses it from a different pc to mine all they get is html looking one it does have the graphics or anything it's a white back ground with links, text and text antry boxes laid out in roughly the same way.

Whats happening?
MMJ's Avatar
MMJ MMJ is offline
Distinguished Member with 3,208 posts.
 
Join Date: Oct 2006
14-May-2007, 02:18 AM #9
Quote:
Originally Posted by reaper616
Ok, I have one up and running now but for some reason when some accesses it from a different pc to mine all they get is html looking one it does have the graphics or anything it's a white back ground with links, text and text antry boxes laid out in roughly the same way.

Whats happening?
This is on a local server?

When you run the setup for mysql it asks you to enter in a username and password.
doctoremote's Avatar
Computer Specs
Junior Member with 23 posts.
 
Join Date: May 2007
Experience: Advanced
14-May-2007, 04:13 AM #10
I suggest you go onto the SMF Forums this may well be a common problem with this package. If it is displaying then it will be the way the PHP is being written or set up
reaper616's Avatar
Senior Member with 336 posts.
 
Join Date: Jul 2006
Location: Lincoln, United Kingdom
Experience: Self taught/teaching
14-May-2007, 10:13 AM #11
Yes this is on a server in my house, and I entered the user and password.

@ doctoremote: Ok will do

Also can anyone suggest a good secure forum?
MMJ's Avatar
MMJ MMJ is offline
Distinguished Member with 3,208 posts.
 
Join Date: Oct 2006
14-May-2007, 02:31 PM #12
Is the server connected to the net?

If not how would a user connect to it?
reaper616's Avatar
Senior Member with 336 posts.
 
Join Date: Jul 2006
Location: Lincoln, United Kingdom
Experience: Self taught/teaching
15-May-2007, 10:02 AM #13
The server is online and I have it set up so when people goto http:\\madmandans.hopto.org they arrive at the forum......I have found out what I need to to do; I need to tell the connecting people where to find the theme, but I don't know what to type there I have tried:
http:\\localhost\forum\themes\default
http:\\madmandans.hopto.org\forum\themes\default
http:\\My-ip\forum\themes\default

This is where I am changing them by the way:


Can someone please tell me what to enter?

Last edited by reaper616 : 15-May-2007 11:45 AM.
reaper616's Avatar
Senior Member with 336 posts.
 
Join Date: Jul 2006
Location: Lincoln, United Kingdom
Experience: Self taught/teaching
15-May-2007, 11:45 AM #14
*BUMP* Sorry
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are Off
Refbacks are Off

You Are Using:
Server ID
Advertisements do not imply our endorsement of that product or service.
All times are GMT -4. The time now is 05:29 AM.
Copyright © 1996 - 2008 TechGuy, Inc. All rights reserved.
Powered by vBulletin, Copyright © 2000 - 2008, Jelsoft Enterprises Ltd.
Search Engine Optimization by vBSEO 3.1.0
Powered by Cermak Technologies, Inc.