Configurng Apache

http://webhosting.devshed.com/c/a/Web-Hosting-HowTos/Configuring-Apache-2-0-Beginning/

Apache and ASP

1. ASP pages made in PERL: http://www.bluereef.net/support/extensions/development/asp/index.html
2. ASP to PHP conversion: http://asp2php.naken.cc/ - http://asp2php.naken.cc/download.php
3. Apache::ASP 2.57 for Windows 2000/XP : http://www.devside.net/web/server/windows/apache-asp

Running your own web server

well you dont really need an uptight comp to run your own server i mean its so simple i run to instances of apache on on the default port and the other on port 3000 and they all jus take up 40mb ram each so you see its not that hard well heres part two.
to run your own server you are gonna need.
a server software apache preferable
perl. mysql and python (these are optional)
also if you wish to run a web hosting company you gonna need a webhosting control panel.
a mail server
a ftp server
and the most important thing about running your own server is to have it accessible to other people to see it, and this you are gonna need, a dynamic dns client software and a dynaminc dns provider.


you see when you are on a dial up network your ip address changes every time and you need the dynamin dns client to update you ip to the dynamic dns provider every time it changes.

well sorry for all the linux people but this article is jus gonna really focus on poeple running windows coz when it comes to servers everybody knows that windows people have a disadvantage.


so next im gonna show you 5 simple ways you could get your server online and working

1..download the tsw{the saing wamp}thats basically an acronym for windows apache and mysql / perl installer. it will do everything for the configuration of all that crap and save you days of headaches. trust me been there. you could download this from tsw the saint wamp download page
that is there latest version and it features most of the features i mentioned on the first article. and please note that it also features php 5.

2...just make sure that when you are installing it you do not install the services that it the ftp server and the mail server they got there coz they not so user friendly i will tell you which ones to use . for your mails server i stronly recommend that you use.hmail server and you can find that here. hmail server .com and for the ftp server you could possibly go for cerrubus ftp server according to me its the best just use you favourite search engine to find that.

3....configure both the ftp server and the mails server . that should be a walk through. its really easy .

4....dynamic dns...<> first get a uni.cc account. another domain that is and in the domain setup point it out to dns option. then point the external dns servers to ns1.afraid.org
ns2.afraid.org
then go to www.afraid.organd register for a dns account and add your uni.cc domain name . it will probably take some time for the dns servers to change so be patient. then from there you can configure dynamic dns for your domain name. and for the dns client i insist you use dynsite for window. its the best and the easitest to use.

5..everything is done you got your own domain name webserver and everything there is nothing that the server you just setup . cannot run its mega featured lol. take my word for it.for the webhosting control panel for people using windows there is this great one called the zpanel you can grab it at www.thezpanel.com its for people using windows.

well if you have a problem with setting up any of the above esp the dns (trust me that can really be hektic. )just pm or post in this forum ill be sure to help. well there have fun running your own server.....
if you need any other thing jus pm me i'll be glad to help you..

Reference: http://www.trap17.com/index.php/webservers-ever-thought-running-yours_t424.html

FieldType Comparison MS Access, SQL, Paradox, VBA, Delphi

Url Link: http://68.165.245.242/user/clemenzi/technical/Databases/FieldTypes.html

Quick Comparison

SQL is "supposed" to be a standard. However, the reality is that there are many different versions. The following table only shows a "few" possibilities.

	Paradox	MS Access	SQL	Delphi	Visual Basic
Text	A	Text	TEXT, ALPHANUMERIC, CHAR, CHARACTER, STRING, VARCHAR	TStringField, TWideStringField	String
1 Byte Int	ns	Number/Byte	BYTE	TBytesField	Byte
2 Byte Int	S	Number/Integer	SHORT	TSmallIntField, TWordField	Integer
4 Byte int	I	Number/Long Integer	LONG, INT, INTEGER	TIntegerField	Long
8 Byte int	ns	ns	?	TLargeIntField	?
4 Byte Float	N	Number/Single	SINGLE, REAL	?	Single
8 Byte Float	ns	Number/Double	DOUBLE, FLOAT, NUMBER	TFloatField	Double
Autoincrement	+	AutoNumber	COUNTER	TAutoIncField	Long
Date/Time	@	Date/Time	DATETIME, TIMESTAMP	TDateTimeField	Date
Date	D	ns	DATE	TDateField	Date
Time	T	ns	TIME	TTimeField	Date
Memo	M	Memo	LONGTEXT, LONGCHAR, MEMO, NOTE	TMemoField	String
Formatted Memo	F	ns	ns	?	ns
Binary	B	ns	BINARY	TBlobField, TGraphicField, TBytesField, TVarBytesField	ns
Boolean	L	Yes/No	BOOLEAN	TBooleanField	Boolean

ns - Not Supported

MYSQL Error 13 when dropping tables

url link: http://dev.mysql.com/doc/refman/5.0/en/file-permissions.html
http://lists.mysql.com/mysql/83797

PHP Runner

http://www.xlinesoft.com/phprunner/index.htm
PHPRunner builds visually appealing web interface for any local or remote MySQL, MS Access, SQL Server and Oracle databases. Your web site visitors will be able to easily search, add, edit, delete and export data in your database. Advanced security options allow to build password-protected members only Web sites easily. PHPRunner is simple to learn so you can build your first project in just fifteen minutes.

Features:

Easy to use wizard-like interface.
Numerous search modes.
Add, view, edit, copy and delete pages.
Built-in FTP Client to upload PHP pages to the Web server.
Multilingual templates. Ability to choose language while logging in.
Creates password protected PHP pages.
User self-register page, password reminder, change password pages.

Benefits of using PHPRunner are:

Can save you time and money.
Improve functionality of your web site.
Create robust, easy to modify code.
Easy to use, you can generate your first PHP web site in just fifteen minutes.
No programming required.

What PHPRunner can do for me:

Collect user's information.
Phone/address book.
News articles.
Products listing.
Web-based database searching & data entry.
Web-based reporting.
Members only password protected web sites.

Build your own server

Starting Out

Before you begin to install Windows 2000 Professional on the older computer, be sure that there are no data files or other important information still being stored on that old computer. Also, make sure you have your Windows 2000 CD and serial number ready. Be sure that you are prepared to sit and attend a 1-2 hour installation process.

More reading:

url: http://www.hotscripts.com/PHP/Scripts_and_Programs/Database_Tools/more8.html

Installing your own Linux Server

Most people think that you need both money and technical skills to set up a Web server. Well folks, the fact of the matter is you don't need either. That's right, you don't need a dime. And who wants to spend all that time gaining skills? Learning can be such a drag. With nothing more than some charm and a copy of this article, you'll be serving up Web pages from a box outfitted with Linux and the most recent versions of Apache Web server, Perl, and Python in a few hours.

The first thing you're going to need to do is get your hands on some free stuff. Here's a rundown of the tools you'll need and some methods for getting them free - and legally.

• A PC - 486-33 or better, 500 MB hard drive, and 16 MB of RAM. Most charities won't even take these. In fact, you're likely to find one in a garbage can outside a large company. I'll assume for the purposes of these instructions that this box contains some version of Microsoft Windows.
• An Ethernet patch cable. At work, follow your sysadmin around for about 20 minutes; she's going to leave one of these lying around at some point.
• Three floppy disks. You've been saving the AOL mailings, haven't you?
• A domain name. I happen to have the privilege of serving the Webmonkey's own illustrious Mattmarg.com. There are some people out there who have registered dozens of domain names. All you need to do is scribble the name Brent Spiner on a scrap of paper and offer it as an even trade.
• Here's the doozy: Access to a high-speed connection along with the following: IP Address, Netmask, Default Gateway, and Nameserver IP. This is stuff you're going to need to get from a sysadmin. Most businesses with high-speed Internet access have more bandwidth and IP addresses than they can use. It's your task to liberate these resources from their overlords. If you've got good skills, offer some of your time. If you're attractive, try flirting. And if you're ugly and inept, try bribery. Or to keep things really low-cost, offer a bribe, record it, then blackmail the SOB.

It's also worth mentioning that the cost of DSL connections is plummeting. Here in the San Francisco Bay Area, service is offered for about US$40 a month. These are "always on" connections, so if you can buy an additional IP address, you could serve out of your home while still having the resources to browse, email, and all that other good stuff.

Once you finish your tool-gathering, we'll be ready to start. If you have a T1 connection and can proceed without snags, setup will take about two hours. However, to be safe, set aside most of a day.

But before you act, you should know your hardware. Tear open the case and take a look inside. The most important piece of information is your Ethernet card type. Write it down. The model number and manufacturers name should be visible with a flashlight. Linux is not like Windows, where you can shove in any $8 card. There are only a couple of dozen network cards that will work. I did my install with a 3Com 3c509b. I strongly suggest you get yourself a 3Com before you attempt this.

These instructions will not allow for dual booting. When done, this will be a Linux box and nothing else.

Though you don't really need to know Linux to get this working, it definitely wouldn't hurt. Linux rules. When you have this box functioning, take some time and learn it.

More on:
url: http://webmonkey.wired.com/webmonkey/99/08/index3a.html

Connecting to MYSQL via ODBC

Microsoft Access 2000 works great as a general front end and IDE for client or server databases. You can use it to manage not just data, but also the table definitions, stored procedures, indexing, and other DBMS-related functions required of a DBA. Follow these steps to access a MySQL database (for the UNIX crowd) over the Web and manage the tables and data with Access.

Connecting to a database
First, keep in mind that Access 2000 is not a database; it is a tool for managing databases. If you run Access, and don't plan on manipulating or viewing data, you're probably running the wrong application. When you get to the Create/Open option in Access, examine the Open section. You are presented with a list of recently accessed files (even if you have since deleted some of them).

At the top of that list is the option More Files.... If this option is selected, you'll be presented with the common dialog box for browsing the file system. This is where you can select either a local database, or a remote one. A variety of formats are available (e.g., dBase, Access, Excel, Paradox, and csv/text) in this dialog box. If you look at the very bottom of the file types list, you'll see an option for ODBC Databases().Open DataBase Connectivity (ODBC) lets you connect to remote databases.

Connecting to a remote MySQL database
I chose MySQL to connect to a remote database server simply because I have quick-and-easy access to a MySQL server. However, connecting to any other remote database via ODBC and Access 2000 would work very much the same way.

OSI considerations
One of the things to consider, when connecting to remote database servers, has to do with the OSI model. You need to look at OSI because when you're dealing with remote connectivity, you must consider all the routers, gateways, domains, etc. that your connection will pass through; and the security measures implemented by each of them. Almost all firewalls (gateways and routers) allow Web traffic, but not all necessarily allow ODBC traffic.

On the network and data link layers (NIC), you must actually be connected to your service provider. But, on the transport and network layer (protocol), you need to be using the Internet's TCP/IP. On the session and presentation layers (operating system) user/password authentication becomes more of a factor—especially if you're dealing with Microsoft databases. Microsoft databases can make use of a proprietary, OS-level authentication and permissions scheme (e.g., Kerberos, NTLM/NTFS).

Also, on the application layer, the database server software authenticates the user and determines what permissions to grant or block. This is the only security scheme I'm concerned with, because the MySQL server is on the Internet, and it is not a Microsoft product. That means that my ISP has already authenticated me for the connection, and I won't be using NTLM security.

Making the ODBC connection
If you're going to make an ODBC connection to a non-Microsoft database server, you need the ODBC driver for that particular database software. The driver for MySQL is MyODBC. If you haven't already, you'll need to download it, install it, and add the server name and username/password and other properties of the connection to your database server (Figure A).
More info here.

Installing your own DSL Web server

Welcome to DSL/Cable Webserver! Here you will find all the information you need to setup and maintain your own webserver at home or office on your DSL or Cable connection. If you already have DSL or Cable modem, you already have most of the necessary equipment; all you need to do is set it up.

DSL/Cable Webserver is hosted on DSL and you may have visited many other websites that were also run on either DSL or Cable and never knew it! Running your own webserver is easier than you may think and might be a cost effective way for you or your company to establish a web presence.

If you happen to get stuck along the way, our online forums are a great place to ask your questions and get real working answers. If this all sounds good to you, follow along and you'll be running your own webserver from your DSL/Cable connection in no time!

"The Guide" will give you a detailed explanation of what you need to setup your own webserver. If you want to jump right in and start running your own server, then the "Quick Start" is for you. For more in-depth articles on how to configure the different aspects of your website, go to "Step-by-Step" which has tons of screen shots and detailed explanations.

Register here to receive weekly updates about the newest articles and guides from DSL/Cable Webserver!

Read more....Click here

Installing PHP MyAdmin

Intro:
phpMyadmin is a web base GUI interface for MySQL.
You can create database and user even without knowing SQL language.
You can download phpmyadmin from http://www.phpmyadmin.net/home_page/downloads.php

1. Source Download:http://www.phpmyadmin.net/home_page/downloads.php
2. copy config.default.php to config.inc.php
3. Edit config.inc.php
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['auth_type'] = 'http';
$cfg['PmaAbsoluteUri' ] = 'http://host ip address/pma/';
4. Restart Apache
5. Verify that MySQL and Apache are running and go to http://localhost/pma/index.php

Putting Apache, MYSQL and PHP together

I had been looking around for best possible scenarios of installing apache, mysql and php with the versions compatible for ez publish and dreamweaver mx. This is the compilation I got:

Byteinstead - Installing Apache, MYSQL and PHP

1. Combination compatible for EZ Publish and Dreamweaver MX
http://bytewebdev.blogspot.com/2005/12/ez-publish-content-management-system.html
> Download [ 4.4.1 ] : http://www.php.net/downloads.php
> Download [ 2.0.55 ] : http://httpd.apache.org/download.cgi
> Download [ 4.0.26 ] : http://dev.mysql.com/downloads/mysql/4.0.html

2. Installing Apache
Directory convention: c:\server\apache2
http://www.webmasterstop.com/48-1.html

3. Installing MYSQL
Directory convention used for installation is like the one of mike: c:\server\mysql
http://www.webmasterstop.com/48-2.html
Help on Installation: http://dev.mysql.com/doc/refman/4.1/en/windows-install-wizard.html

4. Installing PHP 4
Directory convention: c:\server\php
http://bytewebdev.blogspot.com/2005/12/configuring-apache-2-and-php-4-for.html

5. Installing PEAR by Hugh William and David Lane
Page 691 Web Database applications with PHP and MYSQL O'Reilly
> 5.1 Edit C:\server\php\go-pear.bat
>>> Change set PHP_BIN=cli\php.exe to set PHP_BIN=php.exe
>>> Save changes

> 5.2 Click on Run in the Start Menu and enter:
>>> C:\server\php\go-pear.bat
>>> Click OK. Press enter to proceed. Enter web procy server or just press enter.

> 5.3 A list of 7 options comes up. Set 1 and 7 to have the appropriate path
>>> For 1 press 1 and press enter. Key-in: C:\server\php\PEAR and press enter
>>> For 7 press 7 and press enter. Key-in: C:\server\php and press enter

> 5.4 Press enter to continue installation. Make sure your are connected to the Internet.

> 5.5 At the end you will be prompted to modify c:\winnt\php.ini
>>> Type Y and press enter this will put the pear path in the include_path of php.ini
>>> Your php.ini should have this line:
>>> include_path = ".;c:\server\php\PEAR\pear"

> 5.6 Modify c:\winnt\php.ini
>>> Set the SMTP = "your mail host"
>>> Set sendmail_from = "yourmail@address.com"

> 5.7 Save the file and exit editor

> 5.8 Restart Apache