Skip to Content
avatar image
Former Member

ASE Client 16 Visual Studio 2017 missing Data source

i have installed ASE client 16 and we have VS 2017 i am trying to create EF project but i cannot see the Data source to connect to ASE in the list. Can you let us know what need to be done.

-bhu

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • Dec 14, 2017 at 09:43 PM

    Did you add the reference to ASE ADO.NET data provider ?

    This is what I have from old notes from ASE 12.5 document but steps should be on similar lines

    ===============================================================================================

    Adding a reference to the ASE ADO.NET Data Provider assembly in a project

    Adding a reference tells Visual Studio .NET which assembly to include to find the code for ASE ADO.NET Data Provider.

    Adding a reference to ASE ADO.NET Data Provider in a Visual Studio .NET project

    1.Start Visual Studio .NET and open your project.

    2.In the Solution Explorer window, right-click the References folder and choose Add Reference from the pop-up menu.

    The Add Reference dialog box appears.

    3.On the .NET tab, scroll through the list of components until you locate the Sybase.Data.AseClient component. Select this component and click Select.

    4.Click OK.

    If you do not find the ASE ADO.NET Data Provider assembly listed in the components, browse to locate Sybase.Data.AseClient.dll in the <install dir>\dlldirectory. Select the dll and click Open. Then click OK.

    The default location is C:\Sybase\ADO.NET\dll.

    The assembly is added to the References folder in the Solution Explorer window of your project.

    ===============================================================================================

    HTH

    Avinash

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      I believe this is still the same steps provided above.

      Our sample %SYBASE%\DataAccess\ADONET\simple\Csharp\simple.

      You have to add this to the top of your application:
      using Sybase.Data.AseClient;

      You also need to register the Solution > Project > References > Add Reference Sybase.Data.AseClient

      You pick the client from %SYBASE%\DataAccess\ADONET\dll

      select the framework driver you are using.

      Regards,
      Ryan

  • avatar image
    Former Member
    Dec 15, 2017 at 08:34 AM

    Avinash as per your suggestion i added the reference but when i click on Add Connection i don't see the ASE connection in the GUI, how can i get that.

    -bhu

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 15, 2017 at 10:10 AM

    Please check https://msdn.microsoft.com/en-us/library/mt710791.aspx

    Can you see the provider? Have you restarted Visual Studio?

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 15, 2017 at 03:11 PM

    Alberto Merino yes, the visual studio/OS is restarted, i thought the issue could be that the order of installs and tried on another machine too, one machine Sybase was installed first and then VS the other machine VS and then sybase , both don;t show the ASE as the provider. Is there any tool or script which will fix the issue ?

    -bhu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 15, 2017 at 06:56 PM

    i reinstalled ASE Client 16 SDK and still no good the Data Source don;t show ASE provider.

    -bhu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 18, 2017 at 06:12 PM

    i was able to connect here are some of the steps:

    downgraded to 15.7 this creates registry entry with 10.0_Config in the regular registry need to copy those and import it in

    AppData\Local\Microsoft\VisualStudio\15.0_ea23524a privateregistry.bin registry using load hive and also edit the necessary path.

    -bhu

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 03 at 07:00 PM

    okay the data provider is visible on the IDE but is having issues, i can connect to db and see the table but when i execute the Query on the IDE i get this error any idea, what the issue could be ?

    : Faulting application name: devenv.exe, version: 15.0.27130.2010, time stamp: 0x5a31e4ea Faulting module name: sybdrvado20.dll, version: 2.157.1360.0, time stamp: 0x55e54cc4 Exception code: 0xc0000005 Fault offset: 0x0000cbe7 Faulting process id: 0x2720 Faulting application start time: 0x01d384c41ca1feaf Faulting application path: C:\Program Files (x86)\Microsoft Visual Studio\2017\Professional\Common7\IDE\devenv.exe Faulting module path: C:\Users\xxxxx\AppData\Local\Temp\Sybase.AdoNet4.AseClient.32bits.4.157.1360.0\sybdrvado20.dll Report Id: a1bb820b-f0b7-11e7-8d6c-00059a3c7a00 Application: devenv.exe Framework Version: v4.0.30319 Description: The process was terminated due to an unhandled exception. Exception Info: System.AccessViolationException at Sybase.Data.AseClient.Unmanaged.CMD_PerformGetNextResultSet(IntPtr, IntPtr ByRef, Int32 ByRef, Int32 ByRef, Int32 ByRef, Byte ByRef) at Sybase.Data.AseClient.AseDataReader.RetrieveNextResult() at Sybase.Data.AseClient.AseDataReader.GetNextResult(Boolean) at Sybase.Data.AseClient.AseDataReader.NextResult() at Sybase.Data.AseClient.AseDataReader.CloseUrsHandle() at Sybase.Data.AseClient.AseDataReader.Close() at Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetDataReader.Close() at Microsoft.VisualStudio.Data.AdoDotNet.AdoDotNetDataReader.Terminate() at Microsoft.VisualStudio.Data.Compatibility.NewReader.Terminate() at Microsoft.VisualStudio.Data.Package.Client.DataReader.Terminate() at Microsoft.VisualStudio.Data.Compatibility.OldReader.Terminate() at Microsoft.VisualStudio.DataTools.UI.QueryResult.DiskDataStorage.CleanUpDataReader(Microsoft.VisualStudio.Data.Interop.IVsDataConnection ByRef, Microsoft.VisualStudio.Data.Interop.IVsDataCommand ByRef, Microsoft.VisualStudio.Data.Interop.IVsDataReader ByRef) at Microsoft.VisualStudio.DataTools.UI.QueryResult.DiskDataStorage.SerializeData() at System.Threading.ThreadHelper.ThreadStart_Context(System.Object) at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean) at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object) at System.Threading.ThreadHelper.ThreadStart()

    Add comment
    10|10000 characters needed characters exceeded