Database Connections Features in Detail

Explore the built-in connection wizard features

In the first part of our Features in Detail series we will show you the built-in connection wizard, where you can connect to a wide range of well-known standard server types of databases as well as custom ones. The Database Connector extension will be available in PHP and ASP version. The wizard provides different options to build your connection string automatically, depending on the chosen database and also lets you test your connection. These and many more features you can check out below!

Stay tuned for part two tomorrow when we will show you the Database Source Query Builder features!

The Story

Built-in connection wizard - The built-in connection wizard allows you to connect to your database easily and get your data the Ajax way. It comes with full support for wide range of well-known databases and uses specific adapters for each type database so that it can use the native power of the database without bothering you with weird SQL syntax!

Support for standard PHP and ASP server types database - The extension comes in PHP and ASP versions. If you have both installed in your HTML5 Data Bindings you can choose between PHP and ASP server technology otherwise the field will only display the installed one.

Select from various database types - The extension supports standard ASP and PHP databases.

PHP database types - MySQL, PostrgeSQL, SQLite, SQL Server and SQL Server Native.

ASP database types - Access, Access ODBC, MySQL ODBC, ODBC File DSN, ODBC System DSN, SQL Server, SQL Server Express.

Custom database and connection strings - In order to connect to your custom developed database you can always enter your custom connection string, which follows the syntax for PDO, if you're using PHP, or ADO if you're using ASP.

Database type properties - Depending on the chosen database, the connection wizard pops up different options to build your connection string automatically so you don't have to worry about weird connection string syntax.

Test your database connection - Once the connection to your database is established, a confirmation window pops up. If it's not connected properly an error message appears on the popup window.

Add, delete and duplicate the current database connection - In the connection wizard you can add as many connections as you want and delete each one of them with a single click. Also you can duplicate connections in order to save time when applying small changes.

Connection wide options - You can set the maximum allowed returned records from this connection as well as to enable the debugging info option that will bring you additional information in the browser and help you in your development process.

Lubov Cholakova

Lubov Cholakova Lubov has been with DMXzone for 8 years now, contributing to the Content and Sales departments. She is bringing high quality content in the form of daily blog updates, reviews, tutorials, news, newsletters,update emails and extensions' manuals. If you have a product that needs publicity or any other questions about the entire DMXzone community, she is the one you can contact.

See All Postings From Lubov Cholakova >>

Comments

Be the first to write a comment

You must me logged in to write a comment.

Database Connections Features in Detail

Explore the built-in connection wizard features

The Story

Related Blog Posts

What You Missed This Week

Database Connector Integration with HTML5 Data Bindings

Table Joins Features in Detail

Database Source Query Builder Features

Lubov Cholakova

Comments