DataSource.Error: Sybase SQL Anywhere: Integrated login failed in Power BI

[Analitika]

Hi,

I would like to ask how I could solve this issue?

Whenever I am trying to refresh report in Power BI, I am getting this 

DataSource.Error: Sybase SQL Anywhere: Integrated login failed
Details:
DataSourceKind=Sybase
DataSourcePath=188.80.4.95:2638;dbname

Message=Integrated login failed
ErrorCode=-2147467259

I tried to set up a new password also to delete global permissions and clean a cache but all of this were unsuccessfull for solving this issue.

[v-luwang-msft]

Hi @Analitika ,

It was another traffic protection tool. Although it was possible to telnet the port, still traffic from app was blocked by another tool.

Similar question refer:

https://stackoverflow.com/questions/65791488/ianywhere-data-sqlanywhere-saexception-connection-error... 

http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01092.0124/doc/html/mqu12... 

https://www.ibm.com/support/pages/how-resolve-sql-anywhere-database-client-communication-errors 

And  could you try using ODBC connector to connect it to see if it works? 

1. Get Data -> ODBC

2. Choose the DSN you have configured.

Best Regards

Lucien

[v-luwang-msft]

Hi @Analitika ，

Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.

Best Regards
Lucien

[v-luwang-msft]

Hi  @Analitika ,

If you are connecting the data base by Sybase database in Desktop, there are some prerequisites for SAP Sybase SQL Anywhere. "This connector requires one or more additional components to be installed before it can be used. "If you have configured ODBC for Sybase, you can use ODBC connector in Desktop to connect data source. And you need make sure the server name and database name correct.

You can check against the prerequisites.

Best Regards

Lucien

[Analitika]

Still not works getting syntax error - 

Also this: DataSource.Error: ODBC: ERROR [42601] ERROR: syntax error at or near "[";.  Error while executing the query. 

[Analitika]

Hello,

My report is based on Sybase Anywhere but I also need connect to PostgreSQL. How to achieve this? Because I am still getting this error message:

And also:

OLE DB or ODBC error: [DataSource.Error] Sybase SQL Anywhere: Connection error: Connection was dropped (may not be a SQL Anywhere server) .

How to solve these issues and properly use Sybase Anywhere and PostgreSQL at the same time in same report in Power BI?

[Analitika]

Hello,

I am getting error OLE DB or ODBC error: [DataSource.Error] Sybase SQL Anywhere: Connection error: Connection was dropped (may not be a SQL Anywhere server) . An unexpected exception occurred.

This happens when I am trying to refresh the report in Power BI. So how to resolve this?

[Analitika]

I am also connected it via ODBC 

But when refreshing is run I am getting:

OLE DB or ODBC error: [DataSource.Error] Sybase SQL Anywhere: Connection error: Connection was dropped (may not be a SQL Anywhere server) . An unexpected exception occurred.

So how to resolve that issue?

[Analitika]

Hello, 

How to resolve this issue? 

I was entered in advanced editor but didn;t find errors in pane.