Ditutup

Linux DOTNET core Sybase connection

We are trying to connect to a Sybase database using .NET Core on a Debian 9 server.

The .NET Core application is working fine under Linux but not the database connection. Under Windows we use [login to view URL] to connect to the database, but under Linux this package is not useable.

Tried to use [login to view URL] but we get an error, that the database is not found. I think there is something wrong with the connection string.

The connection string under Windows looks like this:

"ENG=SERVER;Links=tcpip;UID=Username;PWD=password;DBN=NAME;DBF=C:\Path\To\The\DB\FILE"

As you can see there is no need to give any IP or something like that. "ENG=SERVER" is the name of the database Server not the FQDN. So somehow iAnywhere knows how to find the right way to the server.

The connection string under Linux looks like this:

Data Source=[login to view URL];Port=2638;UID=Username;PWD=password;Database=NAME

Here we need to set an IP but no path to the file is given.

Anyone an idea how we can solve the issue?

Thanks in advance.

Hi there,

still trying to establish a connection to SAP SQL Anywhere 16 Database with Linux.
We have a asp.net core application which needs a connection to a database.
Usually we use the iAnywhere.Data.SQLAnywhere package to establish the connecton. But neither this nor the AdoNetCore.AseClient package are working under Linux. So we tried to use ODBC.
We use SAP driver for ODBC which we downloaded here (https://wiki.scn.sap.com/wiki/display/SQLANY/SAP+SQL+Anywhere+Database+Client+Download)
This is our ODBC configuration:
[ODBC Data Sources]
Test=SQLAnywhere 16.0
[Test]
ServerName=name
CommLinks=tcpiip(host=xxx.xxx.xxx.xxx;port=2638)
Driver=/opt/sqlanywhere16/lib64/libodbc16.so
When I try to connect to this DataSource with the "dbisqlc" (this is a SAP SQL Central Client for Linux console) I can connect to the db.
This ODBC configuration is stored in the home dir of root. So this is just used by root. When starting the asp.net core application the error is that it can't find the ODBC connection. Of course it can't find it because the config file is at root's home dir. But when copying the config file to /etc/odbc.ini and trying to access the application in a webbrowser we get a "502 - Bad gateway" error.

So question is still: how we can connect to a database, which is running under a windows server, with a asp.net core application using ODBC?
Any ideas?

Thanks in advance!

Keahlian: .NET, Pemrograman C#, Pengembangan Database, Linux, Server Windows

Lihat lebih lanjut: linux cron script daily copy file fromone server, upgrade php linux fedora core, file transfer server server linux, .net core sql connection, .net core sql server, .net core odbc, sybase ase .net core, .net core data access layer, sybase books, sybase doc, oledb .net core, linux tracking file downloads server, port access database linux, optimization linux servers core, linux service slow odbc connection, check sybase connection, import text file sql server dotnet, install linux fedora core, linux fedora core vpn server, linux dotnet adobe

Tentang Pemberi kerja:
( 0 ulasan ) Germany

ID Proyek: #17933528

16 freelancer menawar dengan rata-rata €162 untuk pekerjaan ini

OShuqair

Hi there, this kind of issues is not predictable, I am an expert in .net and .net core and I can try fixing this for you. if I fail then I will refund the milestone payment for you. - can you give access to the env Lebih banyak

€150 EUR dalam 3 hari
(127 Ulasan)
8.3
€100 EUR dalam 1 hari
(146 Ulasan)
5.9
MoustafaS

Hello there Can you try this format please? Data Source=\\myserver\myvolume\mypat\[login to view URL];User ID=myUsername; Password=myPassword;ServerType=LOCAL; This should do it, let me know! Regards

€50 EUR dalam 1 hari
(26 Ulasan)
5.0
schoudhary1553

This is Vibrant Webtech and I was glad to see that you're looking for help for project Linux DOTNET core Sybase connection. I've delivered more than 400 + projects in the last 5 years and this makes me very confident Lebih banyak

€200 EUR dalam 3 hari
(9 Ulasan)
4.5
leemilun

hi, dear. nice to meet you. i'm c#, c++ expert. please discuss more details by chatting. regards. Gao M.

€250 EUR dalam 3 hari
(7 Ulasan)
3.7
DevStar925

Hi, I read your project description and I am very interested in your project. I am a C/C++/C# developer and have a lot of experience of Linux Dot Net Project. So I am sure to provide the perfect project . I hope to Lebih banyak

€250 EUR dalam 3 hari
(4 Ulasan)
3.2
Cognegic

Dear Sir/Ma'am, I hope you are doing well! I and Chiranjeeb have walked through this job description carefully and we are capable to deliver exactly what you are looking to be done My skills:- NodeJS, J query, P Lebih banyak

€250 EUR dalam 3 hari
(5 Ulasan)
1.7
salexfarm

hello,how are you. i read your bid carefully. i am c/c++, linux expert and have full experience for 10 years. c/c++, linux is my top skill and i can complete your project fully. i can provide most quality and high s Lebih banyak

€155 EUR dalam 3 hari
(1 Ulasan)
1.2
sitanmishra

Respected Sir , Warm Greetings , As i have gone through your initial requirements and have understood that you need an excellent developer for design and development of your website application and i am confident Lebih banyak

€155 EUR dalam 3 hari
(0 Ulasan)
0.0
humrobo

Hi, Hope you doing well sir , I go through your project description in given below . I can work on Linux DOTNET core Sybase connection . I can work with you to accomplish your project. as well superior for yo Lebih banyak

€155 EUR dalam 3 hari
(1 Ulasan)
0.0
Bidding5

Dear Hiring Manager, This is [login to view URL] for posting your requirement on Freelancer. My qualification is MCA which from Utkal University, Orissa, India. I am used to working under pressure and I am very keen on Lebih banyak

€150 EUR dalam 3 hari
(0 Ulasan)
0.0
AlishaK1986

Hi I have checked your requirement and can fix that issue in 2 days come to inbox so can discuss and start immediately.

€200 EUR dalam 2 hari
(0 Ulasan)
0.0
WebAndProgram

If you are using Adaptive Server Anywhere ASA, that is, not ASE, then you probably need to first install ASA ODBC for Linux. I didn’t work with .Net Core, but if you don’t solve your problem, please contact me, I’ll fi Lebih banyak

€66 EUR dalam 3 hari
(0 Ulasan)
0.0
som4paul

HI I am an expert in linux platform domain you might consider me paying only when your are satisfied consider it done once you assign it to me Regards Somnath ...

€155 EUR dalam 1 hari
(0 Ulasan)
0.0
meksiu

Hi, I can take a look for the problem for you, and try to solve Can not guarantee anything. I work on Debian since version 1.2 Thank you, Mike PS. Have you tried to use sources for SQL driver? Relevant Skills and Lebih banyak

€155 EUR dalam 3 hari
(0 Ulasan)
0.0
€155 EUR dalam 3 hari
(0 Ulasan)
0.0