Lukket

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!

Evner: .NET, C# Programmering, Databaseudvikling, Linux, Windows Server

Se mere: 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

Om arbejdsgiveren:
( 0 bedømmelser ) Neukirchen-Vluyn, Germany

Projekt ID: #17933528

16 freelancere byder i gennemsnit €162 på dette job

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 Flere

€150 EUR in 3 dage
(127 bedømmelser)
8.3
€100 EUR på 1 dag
(146 bedømmelser)
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 på 1 dag
(26 bedømmelser)
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 Flere

€200 EUR in 3 dage
(9 bedømmelser)
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 in 3 dage
(7 bedømmelser)
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 Flere

€250 EUR in 3 dage
(4 bedømmelser)
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 Flere

€250 EUR in 3 dage
(5 bedømmelser)
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 Flere

€155 EUR in 3 dage
(1 bedømmelse)
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 Flere

€155 EUR in 3 dage
(0 bedømmelser)
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 Flere

€155 EUR in 3 dage
(1 bedømmelse)
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 Flere

€150 EUR in 3 dage
(0 bedømmelser)
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 in 2 dage
(0 bedømmelser)
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 Flere

€66 EUR in 3 dage
(0 bedømmelser)
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 på 1 dag
(0 bedømmelser)
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 Flere

€155 EUR in 3 dage
(0 bedømmelser)
0.0
€155 EUR in 3 dage
(0 bedømmelser)
0.0