Connecting to Adaptive Server

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

Prerequisites

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.4.157.Sybase.AdoNet4.AseClient.dll

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

Task

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 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.