DDEX Provider for Adaptive Server

The Data Designer Extensibility (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.

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.

• If your application references an earlier version of the Adaptive Server ADO.NET Data Provider, run:

  • For Visual Studio 2005 and 2008:

    AseGacUtility -i
       policy.2.157.Sybase.AdoNet2.AseClient.dll 
    

    AseGacUtility -i
       policy.2.157.Sybase.AdoNet4.AseClient.dll 
    

  • For Visual Studio 2010:

    AseGacUtility4 -i
       policy.2.157.Sybase.AdoNet2.AseClient.dll
    

    AseGacUtility4 -i
       policy.2.157.Sybase.AdoNet4.AseClient.dll
    

• Run AdoNetRegistrar for Visual Studio 2005 and 2008, or AdoNetRegistrar4 for Visual Studio 2010.

1. In the Server Explorer view, right-click Data Connections.

2. Select Add Connection.

3. Select Sybase ASE Database as the data source and .NET Framework Data Provider for Sybase ASE as the data provider.

4. Enter the Adaptive Server additional connection properties.

   • Connection properties can be specified as a semicolon(;)-separated list.

   • Last connection property need not terminate with a semicolon(;).

   • Properties without a value are ignored.

   Currently, there are no warning or error messages to flag incorrect connection specifications.

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.

1. Connect to Adaptive Server.

2. Expand the Adaptive Server object to explore.

3. Click an Adaptive Server object to view its property information.