Find Jobs
Hire Freelancers

Linux DOTNET core Sybase connection

$10-150 AUD

Suljettu
Julkaistu yli 5 vuotta sitten

$10-150 AUD

Maksettu toimituksen yhteydessä
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!
Projektin tunnus (ID): 17977344

Tietoa projektista

4 ehdotukset
Etäprojekti
Aktiivinen 5 vuotta sitten

Haluatko ansaita rahaa?

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu
Saa maksu työstäsi
Kuvaile ehdotustasi
Rekisteröinti ja töihin tarjoaminen on ilmaista
4 freelancers are bidding on average $147 AUD for this job
Käyttäjän avatar
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 3 päivässä
5,0 (17 arvostelua)
4,4
4,4
Käyttäjän avatar
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 1 päivässä
5,0 (20 arvostelua)
4,4
4,4
Käyttäjän avatar
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 6 päivässä
0,0 (0 arvostelua)
0,0
0,0

Tietoja asiakkaasta

Maan INDIA lippu
faridabad, India
5,0
35
Liittynyt maalisk. 9, 2017

Asiakkaan vahvistus

Kiitos! Olemme lähettäneet sinulle sähköpostitse linkin, jolla voit lunastaa ilmaisen krediittisi.
Jotain meni pieleen lähetettäessä sähköpostiasi. Yritä uudelleen.
Rekisteröitynyttä käyttäjää Ilmoitettua työtä yhteensä
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Ladataan esikatselua
Lupa myönnetty Geolocation.
Kirjautumisistuntosi on vanhentunut ja sinut on kirjattu ulos. Kirjaudu uudelleen sisään.