DDEX Provider for Adaptive Server

The DDEX Provider for Adaptive Server enables Visual Studio components, such as Server Explorer, to interact with Adaptive Server and its objects through the Adaptive Server ADO.NET Data Provider. With the DDEX Provider for Adaptive Server, you can:

Connect and log in to Adaptive Server from Visual Studio.
List Adaptive Server objects as hierarchy nodes in Visual Studio Server Explorer.
Drag and drop Adaptive Server tables and views from Server Explorer onto data designers.

The DDEX Provider for Adaptive Server is compatible with Visual Studio 2005, 2008, and 2010.

The DDEX Provider for Adaptive Server has been tested and certified on Adaptive Server 15.5 ESD #2 and later.

Connecting to Adaptive Server

Add a database connection to Adaptive Server using the Visual Studio Server Explorer view.

Before connecting to the Adaptive Server:

Add the driver to the global assembly cache (GAC) if you have not yet installed SDK:
- For Visual Studio 2005 and 2008, enter:
```
AseGacUtility -i Sybase.AdoNet2.AseClient.dll 
```
- For Visual Studio 2010, enter:
```
AseGacUtility4 -i Sybase.AdoNet2.AseClient.dll
```
If your application references a version of the Adaptive Server ADO.NET Data Provider that is earlier than 15.5 ESD #7, run:
- For Visual Studio 2005 and 2008:
```
AseGacUtility -i
   policy.2.155.Sybase.AdoNet2.AseClient.dll 
```
- For Visual Studio 2010:
```
AseGacUtility4 -i
   policy.2.155.Sybase.AdoNet2.AseClient.dll
```
Run AdoNetRegistrar for Visual Studio 2005 and 2008, or AdoNetRegistrar4 for Visual Studio 2010.

In the Server Explorer view, right-click Data Connections.
Select Add Connection.
Select Sybase ASE Database as the data source and .NET Framework Data Provider for Sybase ASE as the data provider.
Enter the Adaptive Server connection properties.

Viewing Adaptive Server objects

View Adaptive Server objects and their related information in Visual Studio Server Explorer.

You need a valid connection to an active Adaptive Server to perform this task.

Connect to Adaptive Server.
Expand the Adaptive Server object to explore.
Click an Adaptive Server object to view its property information.