Skip to Content
0

ASE Client 16 Visual Studio 2017 missing Data source

Dec 14, 2017 at 09:10 PM

267

avatar image
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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

7 Answers

Avinash Kothare Dec 14, 2017 at 09:43 PM
0

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

Show 1 Share
10 |10000 characters needed characters left 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

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

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

Share
10 |10000 characters needed characters left characters exceeded
Alberto Merino
Dec 15, 2017 at 10:10 AM
0

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

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 15, 2017 at 03:11 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 15, 2017 at 06:56 PM
0

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

-bhu

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 18, 2017 at 06:12 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Jan 03 at 07:00 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded