Find Jobs
Hire Freelancers

Linux DOTNET core Sybase connection

$10-150 AUD

Zavřený
Zveřejněno před více než 5 roky

$10-150 AUD

Zaplaceno při doručení
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 [login to view URL] package to establish the connecton. But neither this nor the [login to view URL] 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=[login to view URL];port=2638) Driver=/opt/sqlanywhere16/lib64/[login to view URL] 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/[login to view URL] 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!
IČ projektu: 17977344

O projektu

4 nabídky
Vzdálený projekt
Aktivní před 5 roky

Chcete si vydělat nějaké peníze?

Výhody podávání nabídek na Freelancer

Stanovte si rozpočet a časový rámec
Získejte za svou práci zaplaceno
Načrtněte svůj návrh
Registrace a podávání nabídek je zdarma
4 freelanceři nabízejí v průměru $147 AUD za tuto práci
Avatar uživatele
Hey ! How are you doing? I can help you to fix the issue as I have been working with Linux and .net for up to 7years of experience, be rest assured that i can fix the issue as required. You can also view my portfolio for details. Message me so as to discuss assitional details and probably get started.
$150 AUD v 3 dnech
5,0 (17 recenze)
4,4
4,4
Avatar uživatele
I have 8 years of experience in managing complex linux architectures and managing cloud infrastructures. I have worked on many complex projects ( Private cloud setup on AWS, Load balancing clusters, Replication systems and many more). I have versatile experience in setting up and managing server and also optimising them for best usage and fine tuning the security aspects. I have expertise in below fields :- 1 Linux Administration. 2 Windows Administration (Windows 2008 , 2012 & 2016) and Migration. 3 Cloud computing ( AWS, Azure and Google Cloud). 4 Automation ( Ansible,Puppet and Chef). 5 Application's & Web servers ( Apache, nginx, IIS and Tomcat ). 6 Databases ( Mysql, MsSql, MongoDB, postgresql and Apache CouchDB). 7 Security ( Web Security, Server hardening and IPS && IDS configuration) 8 Virtualization( KVM, Xen, OpenVZ & Parallels Virtuozzo). 9 Control Panels ( Cpanel, website panel, zpanel and parallel plesk panel). 10 Shell scripts, python & Perl etc. 11 Mail servers.
$155 AUD v 1 dni
5,0 (20 recenze)
4,4
4,4
Avatar uživatele
To determine the problem I have to review the server settings, to check the connection port of the database, if you have many services started the ports change, once the port is identified the server's firewall is checked to determine if it allows inbound connection . From then on we review the driver of connection to the database with its respective user and password.
$133 AUD v 6 dnech
0,0 (0 recenze)
0,0
0,0

O klientovi

Pochází z INDIA
faridabad, India
5,0
35
Členem od bře 9, 2017

Ověření klienta

Díky! Poslali jsme vám e-mailem odkaz pro získání kreditu zdarma.
Při odesílání e-mailu se něco pokazilo. Zkuste to prosím znovu.
Registrovaných uživatelů Zveřejněných projektů
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Načítání náhledu
Bylo uděleno povolení ke geolokaci.
Vaše doba přihlášení vypršela a byli jste odhlášeni. Přihlaste se znovu.