see the easyGen online Training videos

[Back to top]

Also see the easyGen online Training videos
[Back to top]

There is also no limit on the size of the web application you can create.

[Back to top]

See http://www.easygen.com/demo_musicbox/ for a demo
[Back to top]

See the easyGen user manual for more information
[Back to top]

A SQL database is something that is installed on a server or computer, the computer administrator or service provider will create you a database for you to use within the database software. a new database is an empty shell and contains no information, easyGen will then build the database structure for you and the web pages so you can add information to the database
[Back to top]

If you are wanting to connect your web pages to a database so people can access it via the internet you will need to have your database online. Typically this would be a SQL type database but for small application you could use Access.

For a SQL database your service provider will set this up for you and provide your with detail of how to connect. If you want to use an Access database you will need a to be hosted on a NT server and create your web pages in ASP. Ask your service provider to create you a folder called db where you can store your database and ask them to give it read/write privileges. NOTE: An online Access database is also less secure than a SQL database.

By far the easiest way to set up an online database is to use a service provider like ourselves. We will set up a PHP website and a MySQL database, ready for you to use with easyGen. See www.easygen.com/hosting for more information
[Back to top]

Then see the install instructions http://dev.mysql.com/doc/mysql/en/Windows_start_command_line.html

You may also find this admin program useful to help you configure and use the MySQL database. http://dev.mysql.com/get/Downloads/MySQLAdministrationSuite/mysql-administrator-1.0.17-win.msi/from/pick

NOTE: If you want to run PHP or ASP files on your computer you will need to be using Windows XP PRO, 2000 or NT and have IIS installed.

Also see http://www.easygen.com/faq/index.php?p=default&cat=11

Also see http://www.easygen.com/faq/index.php?p=default&cat=11
[Back to top]

Databases

A database is a software application or enviroment that is designed to store information. Over the years databases have evolved from nothing more than a text file to very powerful storage tools. There are many different types of databases and all have there own unique good and bad points. For online web application the most popular type of database is called a SQL (see-quill). Microsoft’s SQLserver and Oracle are the 2 favored by corporates but these are very expensive and in most cases have far more features than the user requires.

The most popular SQL database is called MySQL, it doesn’t have all the advanced features found in Oracle and SQLserver but it is more than powerful enough to suit most users needs and it’s free. However if you are wanting to use a MySQL database hosted on a web server you will need to pay for the hosting of the database.

For people who have little or no computer skills we would advise they use a hosted database solution, mainly because the hosting company will set up your database for you and then just tell you how to connect to your database (server – username – password – database name) and this is the only bit of information easyGen needs to start building your database. You can set up a PHP web site and MySQL database at http://www.easygen.com/hosting/

NOTE: A SQL database is a software environment that has to be installed on a server. You can't just create a database of your choice, the software (MySQL, SQLserver, Oracle, etc) needs to be installed on the server you are going to use. If you don't have a host that offers a SQL database or don't want to pay for a SQL database to be hosted, use the Access database that comes with easyGen.

You can also use the Access database that comes with easyGen, this can be found in your easyGen folder under access db, (C:/Program Files/Symbiant/easyGen 2/access db).

Access is a Microsoft software package but you can build and store information in an Access database without the need to buy or use the Access program. Access can only be used with ASP and is ideal for low user sites. However it’s not as robust as a SQL database and also not as secure. An experienced hacker could easily tap in to an online Access database. But if your not storing sensitive data and don’t expect more than 10 people trying to access the database at the same time it is a good low cost choice. Also if you want to create your own application, such as on a PC or Intranet, this again is a good choice.

Using an Access database is the same as any other database except you are working with a file rather than a server. If you have a copy of Access you can simply create a new Access mdb file to link your project to, if you don't we supply a blank access database file you can use. However, there is an important differance to remember when exporting projects that use an Access database. Because the Access database is a file, it needs to be exported with your project, easyGen will manage all this for you and export the database to your designated web server or folder in a directory called ds. All you need to do is set the permission of this directory to allow full read and write privilages for internet guest users (IUSER), so Windows knows to allow data entered on your web site to update the database. For instructions on how to do this, see http://www.easygen.com/faq/index.php?p=default&cat=10#a34.

Experienced computer users can set up SQL databases on their own PC or server, such users can find instruction on how to do this from the provider of the database they wish to use. See page 18 of the user manual, Using Your Own PC to run ASP or PHP pages, for more on that topic.

As a general rule the following databases use these programming languages with easyGen.

Access – ASP

1 A poorly configured DNS server which is the most likely cause of a connection failed, you can fix this by using the IP address of the server that hosts your database.

2 You are not using the correct connection details or the user you are trying to access with does not have the required permissions.

3 Your MySQL databases does not have remote access.

To resolve the above please contact the company who hosts your MySQL database and ask them what the problem is and how to resolve it.

As a test you can connect to our demo MySQL database and if you can connect to that you will have proof the problem is with your current host. http://www.easygen.com/help/test_db/

If your current host is unable to offer you a suitable MySQL connection or is unable to rectify your problem we suggest finding a new service provider, see http://www.easygen.com/hosting/
[Back to top]

If you are having problems connecting to your database with the Data Source Manager first make sure the user details you are using have full permissions (Modify, Update) and have remote access which is % in the host settings for that user and database.

COMMON PROBLEMS and Errors:-

• If it says 'No such host known' it is likely the server name is incorrect (try connecting via the IP address)
• If it says 'could not initiate communication with the server' it is likely the user details are incorrect.
• If it says 'Access denied .....' you either don't have permission to access the database or the database name is wrong.
  

Then see the install instructions  http://dev.mysql.com/doc/mysql/en/Windows_start_command_line.html

You may also find this admin program useful to help you configure and use the MySQL database. http://dev.mysql.com/get/Downloads/MySQLAdministrationSuite/mysql-administrator-1.0.17-win.msi/from/pick

 NOTE: If you want to run PHP or ASP files on your computer you will need to be using Windows XP PRO, 2000 or NT and have IIS installed.
[Back to top]

If you are looking for a MySQL online database for yourself see http://www.easygen.com/hosting/
[Back to top]

First Scan for updates

Then select the .NET framework 1.1 in the Windows folder.

You can install the framework by running Windows Update
http://windowsupdate.microsoft.com/

easyGen requires Microsoft MDAC 2.6 or later to update your version of MDAC free CLICK HERE and download and install the latest version.
[Back to top]

1. Open the file explorer
2. Tools menu
3. Options menu
4. Click the [View] tab
5. Uncheck "Use simple file sharing"
6. Click OK
7. Find the folder in which your MDB file is kept
8. Right-click the folder
9. Select "Sharing and security"
10. Click the [Security] tab
11. Click the Add button
12. Click the Advanced button
13. Click the Find Now button
14. Select the IUSER_{COMPUTER NAME} user and click OK
15. In the checkboxes at the bottom of the form, give this user Full Control
[Back to top]

http://www.easygen.com/formtest/?testCode=Y35MX45776

Then load easyGen and try registering again.
[Back to top]

To register and unlock your copy of easyGen first make sure you have an open Internet connection, then open easyGen, on the start page click on Register easyGen And fill in the online form, entering your License/serial number in to the 3 box's at the top of the page.

When you have done this your copy of easyGen will ask you if you want to update your copy, click yes and easyGen will download and install all the new updates. Make sure your copy of easyGen closes before downloading the updates. If your computer fails to download all the updates you can run Check for Updates found in the Help menu. Make sure you keep running this until it says there are no more updates.
[Back to top]

Your database will be hosted on a server, this server will have a name or a IP address which identifies it over the Internet. It is it's address so your applications know where to find your database.

For instance our test server is called ns1.symshop.com and has a IP address of 213.129.69.61 so you could enter either of these to connect to our server.

Ask you hosting company for either the name of the server or the IP address of the server your database is hosted on.

If your database is hosted on your own pc you would enter localhost for MySQL and (local) for SQL Server
[Back to top]

Extract the contents of the zip file to your easyGen directory (this is normally c:\Program Files\Symbiant\easyGen 2.3)

Please note this updater is for easyGen 2.3 only, DO NOT use it with a different version of easyGen.
[Back to top]

If you continue to have problems with the updater please remove your current version of easygen and install the latest version, see How do I upgrade easyGen or re-install it above
[Back to top]

If you you haven't got a website we can provide you with a PHP website and an online MySQL database see HERE for more.
[Back to top]

If you you haven't got a website we can provide you with a PHP website and an online MySQL database see HERE for more.
[Back to top]

What’s the difference between ASP and PHP? Well, besides the obvious which is they are two different languages, the main difference is, it depends on what type of server you are going to host your website on. If you are being hosted on a UNIX server then you want to use PHP, if your webserver is Windows based (NT server) use ASP. Your hosting company will tell you which language you should use.

People building applications, which will be run on a PC or home network, will again choose ASP as the chances are it will be a Windows operating system you are using.

PHP is also the newer of the two languages and many programmers now prefer it, for many different reasons. Because we only run UNIX servers all our websites use PHP and MySQL databases, including all the easyGen ones. So when you purchase your easyGen and your license is issued and emailed to you, that’s PHP. But it should also be said that it could also be done in ASP.

At the end of the day it comes down to personal preference and the type of server you’re being hosted on. Because NT servers have a reputation for being a little temperamental and always needing a reboot many people prefer to be hosted on UNIX servers as they are more reliable and have a higher up time rate. It is for this reason we only host on UNIX servers
[Back to top]

We put a maximum of 100 sites on our servers, thus ensuring fast connections and reliability. We also only use UNIX servers as they are more robust than NT. So if you are looking for a PHP and MySQL site we can help you, see http://www.easygen.com/hosting/ for more details.
[Back to top]

ASP runs as standard on the above operating systems if you have installed IIS from the O/S set up disk
[Back to top]

If you have closed one of the side windows and would like it back go to View from the main menu and select the item. If this fails to work then you will need to reset the layout, to do this follow the below instructions

Using Windows Explorer you need to find a folder called "IsolatedStorage" which will probably be at this path
C:\Documents and Settings\{user name}\Local Settings\Application Data\IsolatedStorage

and then delete all the contents of that folder so it is empty, NOTE do not delete the folder "IsolatedStorage" just it's contents..

This will reset easyGens windows layout

If you can not see the Local Settings folder you will need to change your settings in Windows Explorer to show hidden files, to do this from the main menu in explorer. Tools > Folder Options then choose the View tab and check the radio button for Show hidden files and folders

Yes, to download the user manual Click Here

So if you have a home PC and work PC and forget to unregister one of them, you will not be able to register and use the other copy.
[Back to top]

Extract the contents of the zip file to your easyGen directory
(this is normally c:Program Files Symbiant easyGen 2.3 )

Please note this updater is for easyGen 2.3 only, DO NOT use it with a different version of easyGen.
[Back to top]

Your may also need to update your windows software as the problem could be something to do with a Microsoft component. To Run windows update see Installing
[Back to top]

To install this patch, simply extract the contents of the zip file to your easyGen installation directory (it will replace the existing easyGen2.exe file).

Please make sure you are logged into Windows with full administrational privileges before attempting to install this patch.
[Back to top]

This will reset the layout so you can see the project explorer window
[Back to top]