Forum Discussion
Problem to connect Sybase ODBC driver
Hello,
I'm trying to migrate Qlik Sense report to PowerBI and I have a problem to access to the ODBC Driver.
I use the 64 bit driver provided by Devart. This driver works well with Qlik Sense.
I've no problem to connect to the ODBC source but, I see the databases, tables but when PowerBI tried to browse the content of a table I have the following message :
DataSource.Error : ODBC: ERROR [HY000] [Devart][ODBC][Adaptive Server Enterprise]Incorrect syntax near the keyword 'FOR'.
Détails :
DataSourceKind=Odbc
DataSourcePath=dsn=Topaze64
OdbcErrors=[Table]
Here is what I have in the Advanced editor :
let
Source = Odbc.DataSource("dsn=Topaze64", [HierarchicalNavigation=true]),
Diamant_Database = Source{[Name="Diamant",Kind="Database"]}[Data],
dbo_Schema = Diamant_Database{[Name="dbo",Kind="Schema"]}[Data],
SAM_SAVMAB_Table = dbo_Schema{[Name="SAM_SAVMAB",Kind="Table"]}[Data]
in
SAM_SAVMAB_Table
This is mandatory for me to go further in my migration.
Thank you very much for you help.
Regards,
Thierry
3 Replies
Dear,
Try to connect the Sybase directory from Power BI and access the tables?? The Sybase client is instead?
Regards,
I did not use the sybase client because I seems not to work with my sybase ASE database.
So I try to use direct ODBC driver. I have the 32bits version with works with PowerBI 32bits. Because I wanted to use PowerBI 64bits (the 32bits version crashes all the time...) I tried the 64bits driver version provided by Devart.
This driver works well with QlikSense but not with powerBI. I can browse databases and table name but not table content.
