ASE Client 16 Visual Studio 2017 missing Data source

[Former Member]

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

[Former Member]

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()

[Former Member]

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

[Former Member]

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

-bhu

[Former Member]

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

[alberto_merino]

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

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

[Former Member]

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

[former_member89972]

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

[ryan_hansen]

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