Friday, August 9, 2013


Connection Strings:

Good Morning.

The next step in building a website with AlphaFive is to build connection strings.  The connection strings are the method with which AlphaFive connects to the backend database source and builds the grids and dialogs etc.,

Basically, Alpha can connect to many popular SQL databases.  But I am using MySQL for my purpose. So I am going to show you the connection string for MySQL. Also I have included the connection strings for Access and Microsoft SQL Express 2012.

You can build the connection strings by clicking on the "Tools" on the main menu or when you create a component then you can define the new connection string or edit the one you have already created.

Click Tools and ten click on AlphaDAO connection strings.
On the next dialog click New to create a new Connection string.
On the next dialog, you can give some name that you can relate to easily.
Then click on the button that says "Build"
On the next dialog fill in the information needed and click on the test connection button. If the connection succeeded, then click "Refresh" to fresh the database schema. Then select the proper database.
Again test the connection. If successful, save it.

For my project I have the connection string named as "AlphaWeb" and the databse backend is MySQL.

Here is the screencast of the connection strings:

http://screencast.com/t/X9ieiJ6xHg
Updated Video:
Nov 19th 2017
http://www.youtube.com/watch?v=X8arEVAUtr0

No comments:

Post a Comment