Quick Guide to setting up ADO.NET
Article ID: 55226
Updated On:
Products
Issue/Introduction
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.
<Please see attached file for image>
Figure 1
Click Next on the Welcome screen. The next screen will show you the system requirements and if your machine meets these requirements.
<Please see attached file for image>
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)
<Please see attached file for image>
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.
<Please see attached file for image>
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.
<Please see attached file for image>
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
Environment
Component:
Feedback
