Quick Guide to setting up ADO.NET

Document ID : KB000055226
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

The Forest & Trees help contains lots of useful information on ADO.NET. This doc skips the multiple options and serves as a quick setup for ADO.NET. For detailed options with ADO.NET, see the F&T help.

Solution:

Assumptions:

This doc assumes that you have Forest & Trees installed and a server with Microsoft IIS up and functioning.

Additional Software Requirements:

ADO.NET requires Windows 2003, Windows 2000 + SP2 or Windows XP Pro. Also Microsoft .NET Framework v1.1 or higher, MDAC v 2.7 or higher and IIS with directory server administration rights. The setup for ADO.NET checks to make sure you meet these requirements and lets you know if something needs to be upgraded or added to meet these requirements..

Installing ADO.NET Server Components

From the Forest & Trees Product Explorer under Data Server Components, select ADO.NET Server Components.

Figure 1
Figure 1

Click Next on the Welcome screen. The next screen will show you the system requirements and if your machine meets these requirements.

Figure 2
Figure 2

If your machine does not meet the requirements, please cancel the install and correct the problem. .NET Framework and MDAC can be installed from the Forest & Trees Product Explorer under System Updates.

Once you have met the requirements, click Next to continue the installation. Choose the default choices and ADO.NET will be setup for you. A virtual directory for ADO.NET will be automatically set up for you in IIS. (See the screen print below)

Figure 3
Figure 3

Now go into Forest & Trees. We will set up a view that uses an ODBC driver on the ADO.NET server. Create a new view and define it with an interface of ADO.NET.

Figure 4
Figure 4

Now go to Modify>Database for this view. Fill in the boxes similar to the screen print below. Click the Options button to get the additional selections.

Figure 5
Figure 5

Make sure that MyDataSource is a System data source on the ADO.NET server machine.

You will now be connected to your database via ADO.NET