Closed

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 [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!

Skills: .NET, C# Programming, Database Development, Linux, Windows Server

See more: translate windows path linux, threadx driver port linux, linux plesk migration path, sybase doc, sybase documentation 15, sybase books, http www sybase in, sybase online editor, .net core odbc, sybase ase 17, .net core ado net, upgrade php linux fedora core, session save path set, optimization linux servers core, linux service slow odbc connection, check sybase connection, install linux fedora core, linux fedora core vpn server, linux dotnet adobe, desktop application linux app core xml rpc

About the Employer:
( 33 reviews ) faridabad, India

Project ID: #17977344

4 freelancers are bidding on average $147 for this job

reedsystems

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 portf More

$150 AUD in 3 days
(17 Reviews)
4.4
Savstac

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 system More

$155 AUD in 1 day
(20 Reviews)
4.4
Pro4Magento

Can help You fix this problem with connecting with SAP driver for ODBC in your [login to view URL] Application on Debian based system. Small Debug session needed on your live linux system, but in general this problem is fixable More

$150 AUD in 1 day
(12 Reviews)
3.1
yilverguevara

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 chec More

$133 AUD in 6 days
(0 Reviews)
0.0