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:
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.
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]
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?
Thanks in advance!