Solved .NET Data Provider under .NET Core 3.1

Discussion forum about all things SqlBase.
isential
Germany
Posts: 16
Joined: 05 Jul 2017, 15:18
Location: Germany

.NET Data Provider under .NET Core 3.1

Post by isential » 06 May 2020, 14:32

Does SQLBase support .NET Data Provider under .Net Core 3.1?

I have created a test project for Framework 4.8 where I connect to SQLBase via .NET Data Provider. For this I have included Gupta.SQLBase.Data.dll as a reference.

I have created the same program for .Net Core 3.1. The program can be compiled, but I get the following exception when connecting:
{"Could not load file or assembly 'System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'. The system can't find the specified file.":"System.EnterpriseServices, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a"} System.Exception {System.IO.FileNotFoundException}
Here is the sample code:

Code: Select all

using Gupta.SQLBase.Data;
using System;

namespace Bsp_05_ConnectSQLBaseDotNetCoreAdoDotNet
{
	class Program
	{
		static void Main(string[] args)
		{
			try
			{
				string cs = "Database=TST; USERNAME=sysadm; PASSWORD=xyz; TRANSPORT=TCP; HOSTNAME=192.168.70.202; PORT=2155";
				var conn = new SQLBaseConnection(cs);
				conn.Open(); // The exception is triggered here.
				conn.Close();
			}
			catch (Exception e)
			{
				Console.WriteLine(e.ToString());
			}
		}
	}
}
I use here Gupta.SQLBase.Data.dll from the newest version 12.2 of SQLBase.

ODBC and OLEDB work, but I want to use the .Net Data Provider for different reasons, but I don't succeed under .Net Core 3.1.

What is the problem and how can it be solved?

Thanks in advance!

René
Last edited by isential on 07 May 2020, 12:35, edited 1 time in total.

isential
Germany
Posts: 16
Joined: 05 Jul 2017, 15:18
Location: Germany

Re: .NET Data Provider under .NET Core 3.1

Post by isential » 06 May 2020, 14:49

While searching the SQLBase directories I came across the DLL "Gupta.SQLBase.Data.Standard.dll". Now I've inserted it as a reference and it seems to work.

However, I could not find anything about it in the SQLBase documentation. Where can I read more about it?

User avatar
Steve Leighton
Site Admin
Site Admin
New Zealand
Posts: 287
Joined: 05 Mar 2017, 20:57
Location: Tauranga, New Zealand <--> Stroud, England

Re: .NET Data Provider under .NET Core 3.1

Post by Steve Leighton » 07 May 2020, 08:57

.
SQLBase manuals here: [url]https://samples.tdcommunity.net/index.p ... ase_Books/[/url]
and then try Chapter 7 - .Net data provider in 'SQLBase Connecting to SQLBase.pdf' from v11.7 onwards
Greetings from New Zealand
Steve Leighton

Bankside Systems Ltd.
UK ♦ Australia ♦ New Zealand

www.banksidesystems.co.uk

Image

isential
Germany
Posts: 16
Joined: 05 Jul 2017, 15:18
Location: Germany

Re: .NET Data Provider under .NET Core 3.1

Post by isential » 07 May 2020, 09:42

OK, thanks a lot! As I read, the support came only with the latest version 12.2. In the manual "SQLBase Connecting to SQLBase.pdf" there is indeed on page 66 the section ".NET Core/Standard Implementation" which explains this.

Now we hope that the implementation is running stable and that EF will be released soon and above all without any major bugs.

Best regards

René

Return to “General Discussion”

Who is online

Users browsing this forum: No registered users and 0 guests