Embarcadero / IB.NETDataProvider

InterBase database .NET Data Provider
Other
12 stars 7 forks source link

Error Connecting to Interbase For Mobile (.Net Maui Blazor IOS) #19

Open TamcoGitHub opened 1 year ago

TamcoGitHub commented 1 year ago

Hello,

Hopefully I can get some help with this when I do a basic connection to my database when I get to the connection open I get this error in my output in Visual Studio 2022 tried in .net6 and .net7 (IOS and ANDROID) but works fine no error on (Windows)

When I run this for windows no error everything connects fine but when I run it for either mobile on physical device or simulator no luck.

**2023-04-26 20:40:58.630 Xamarin.PreBuilt.iOS[2481:621025] System.DllNotFoundException: libdl.so at InterBaseSql.Data.Client.Native.LinuxClient.LoadLibrary(String libName) at InterBaseSql.Data.Client.Native.LinuxClient.LoadIBLibrary() 2023-04-26 20:40:58.630 Xamarin.PreBuilt.iOS[2481:621025] at InterBaseSql.Data.Client.Native.IBClientFactory.GetGDSLibrary(IBServerType id) at InterBaseSql.Data.Client.Native.IBDatabase..ctor(IBServerType serverType, Charset charset) at InterBaseSql.Data.InterBaseClient.ClientFactory.CreateIDatabase(ConnectionString options)

2023-04-26 20:40:58.630 Xamarin.PreBuilt.iOS[2481:621025] at InterBaseSql.Data.InterBaseClient.IBConnectionInternal.Connect() at InterBaseSql.Data.InterBaseClient.IBConnectionPoolManager.Pool.GetConnection(IBConnection owner) at InterBaseSql.Data.InterBaseClient.IBConnectionPoolManager.Get(ConnectionString connectionString, IBConnection owner)

2023-04-26 20:40:58.630 Xamarin.PreBuilt.iOS[2481:621025] at InterBaseSql.Data.InterBaseClient.IBConnection.Open() at MauiApp1.Pages.FetchData.OnInitializedAsync() in C:\Users\Zach\source\repos\MauiApp1\MauiApp1\Pages\FetchData.razor:line 66

The app has been terminated.**

This is the basic code I am using to connect (I replaced user and password with holders)

string connectionstring = @"data source=tamrds01/interbase09;initial catalog=C:\Sales\Tamco_SC\TAMCO_SC.ib;user id=sample;password=sample"; var conn = new IBConnection(connectionstring); conn.Open(); IBCommand command = new IBCommand("select * from sxpwd", conn); IBDataAdapter dt = new IBDataAdapter(command); dt.Fill(Test);

Any help would be great thanks!