Alpha Software is focused on enabling developers to create robust, data-driven business applications that run on any PC, Tablet or Smartphone in the fastest, most efficient and cost-effective manner possible.

Share this blog:

Wednesday, November 21, 2007

New tutorials to solve SQL stews

For developers, it seems like the more they can do with Alpha Five, the more they want to do. And with this desire comes the challenge of figuring out +how+ to do anything for the first time.

SQL is one such challenge. SQL opens the door to a universe of database back-ends, but it also stands as a barrier to developers who are accustomed to building native databases. Common beginner questions include, "How do I connect to a SQL data source?" and "How do I create a Web app that leverages a SQL database?"

We just posted a new tutorial video that deals with these topics. This video uses report generation to illustrate how to create the connection string, define the data you want to use, connection options (ADO, AlphaDAO, etc.), how to log in, what database to use, what table, what fields, etc.

Another covers questions regarding using Web applications with SQL data. You'll find the steps for connecting to the database are similar for Web components, imports, reporting, etc., because they all use the same interface.

Our complete tutorial library is located here. If you can't find the topic you're looking for, let me know.

3 comments :

William Terry said...

Excellent training.......

Everett said...

When attempting to access the videos from this page,

http://alphasoftware.blogspot.com/
search/label/AlphaADO

I received this message:

You are not authorized to view this page
The Web server you are attempting to reach has a list of IP addresses that are not allowed to access the Web site, and the IP address of your browsing computer is on this list.

Please try the following:

* Contact the Web site administrator if you believe you should be able to view this directory or page.

HTTP Error 403.6 - Forbidden: IP address of the client has been rejected.
Internet Information Services (IIS)

Technical Information (for support personnel)

* Go to Microsoft Product Support Services and perform a title search for the words HTTP and 403.
* Open IIS Help, which is accessible in IIS Manager (inetmgr), and search for topics titled About Security, Limiting Access by IP Address, IP Address Access Restrictions, and About Custom Error Messages.

On this page

http://dweb.alphasoftware.com/
AlphaFive/video/connect_string/

Now, I have been registered with Alpha for many years and this is the first time that I have run into this.

Blogmaster said...

Everett,

I am looking into this for you. Thanks for the heads up.

Related Posts Plugin for WordPress, Blogger...