Projetex 2006 – access through the ODBC

Projetex 2006 enables its users to access a database of the program through the ODBC.

The ODBC (Open Database Connectivity) of the Microsoft Corporation represents a general interface for access to SQL-compatible databases. In this technology, the SQL language is used as a standard mechanism for data access. The interface ensures a high degree of interaction: one application can refer to different SQL-compatible DBMS (Data Base Management System) by means of generic code. This allows a developer to create and distribute “client/server” applications without taking into consideration characteristics of specific DBMS. To connect an application with any chosen by user DBMS, it is enough to have a corresponding ODBC driver. In spite of the fact, that the ODBC is considered to be a good data transfer interface, nevertheless, it has many restrictions as a program interface.

This document is provided to give you some basic ideas on the work of this function.

So, how does it work? First of all, open the access in the administration program. For this purpose, launch Projetex 2006 Server Administrator and click the Corporate Settings tab in the ODBC Access menu module. You can see the administration program view the following screenshot.

It is not hard to do as everything else in Projetex 2006. You can see here only one check box, which is cleared by default. By selecting this box, you will switch this option on, and a dialogue view will appear, prompting you to set a password and to confirm it:

Enter a password and remember it. Click OK, and you will access the database through the ODBC. The ODBC login is fixed. It is “ODBC” for user. Take into consideration that this user account was created for the Firebird server, and it was given rights to read data from the database.

Now, after all that, we need to customize the ODBC driver itself. A free driver can be downloaded from http://ibphoenix.com/main.nfs?a=ibphoenix&page=ibp_60_odbc

The driver is constantly upgraded; therefore, we do not provide you with direct links – look and choose a version for yourself. You can also find document files on this page, which will help you to fine tune the driver. Though, we will provide only a brief description of installation here. For this instruction, a beta of the second driver version was downloaded. Here is a direct link:

http://www.ibphoenix.com/downloads/Firebird_ODBC_2.0.0-Win32.exe

Now, after we have installed all this, let us check the access. For this purpose, find the ODBC Data Source Administrator on Control Panel

It is necessary for us to be able to add our new ODBC data source. Click the Add... button and choose the just downloaded driver for the Firebird.

After the connection has been customized, click Test Connection button to check it:

If the customization was performed in the right way, the following dialogue will appear:

See Also:

System Administrator Basic working procedures