Connect Sybase Ads v9.0 with Power BI x64

[RennDoug]

Hello everyone
I need a lot of help. I'm working with a database called SYBASE ADS version 9.0, I haven't found an ODBC or OLE DB version 64bit, only 32bit, so I can't use POWER BI 64bit to connect to the database, so I can't update through GATEWAY. Has anyone managed to connect to this bank in this version with POWER BI 64bit?

I need to connect the SYBASE ADS version 9.0 with POWER BI x64

[v-deddai1-msft · Accepted solution]

Hi @RennDoug ,

Would you please try to use Advantage ODBC Driver Release 10 ? http://devzone.advantagedatabase.com/dz/content.aspx?key=20&Release=15&Product=14&Platform=14

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Best Regards,

Dedmon Dai

[RennDoug]

Yes, the solution of I find, was update database to v10.10.0.49, where have drive x64, and now I can do automatic updates. Thanks for everyone

[amitchandak]

@RennDoug , 64-bit power bi will connect with 64-bit database driver only. On another machine, you can install 32 bit power bi and try .

In this link just before Aug 2020, release you will get link for 32 bit sep release of power bi  -https://docs.microsoft.com/en-us/power-bi/fundamentals/desktop-latest-update-archive

[RennDoug]

Thank for reply, I seek for drive x64 to connect into ADS  v9 but I not find. Because the gateway works only x64, I can't do automatic updates.