Microsoft released a preview of PowerBI, an authoring tool for visualizing data from a variety of databases as described here: http://hodentek.blogspot.com/2015/02/spin-out-cutting-edge-report-with-power.html I am a Sybase enthusiast and I tested whether or not it can connect to SQL Anywhere 16(being one of the Sybase Databases). However I come up with two different kinds of errors connecting to SQL Anyhwere 16 I have started the demo16 successfully. Now I provide the server name required by PowerBI as demo16 and the database name as demo. It throws an exception as follows: DataSource.Error: Sybase SQL Anywhere: Connection error: No IP address found for demo16 Details: Message=Connection error: No IP address found for demo16 ErrorCode=-2147467259 I go back and look at the properties of the server and I find an IP Adress (NAT) of the computer on which I am running this server. If I use this information for connecting to server from PowerBI, i get a different error as follows: DataSource.Error: Sybase SQL Anywhere: Login mode 'Integrated' not permitted by login_mode setting Details: Message=Login mode 'Integrated' not permitted by login_mode setting ErrorCode=-2147467259 Is the IPAddress of the demo16 server the same as the local machine? Is it possible to run the demo 16 server in Windows authentication mode? Perhaps SQL Anywhere 16 is not supported? |
The "'Integrated' not permitted" error is what you'll see if your connection string does not include UID or PWD. Can you post the entire connection string? Feel free to replace passwords with ***. Besides that, you might make sure you start the demo database on a v16 network server, not on a personal engine - only the network engine will listen for TCP/IP connections by default, and that might be required for the PowerBI tool.
(12 Feb '15, 03:08)
Volker Barth
|
More details of the problem I faced are here with some screen shots: http://hodentek.blogspot.com/2015/02/powerbi-preview-reporting-from-sql.html Finally found an answer that works The server name should be : localhost:2638 the database name is: demo For authentication use database authentication 1
Finally I was able to create a report using PowerBI which was so easy to create. I wonder how far SSRS will go. Here is a link to the report post: http://hodentek.blogspot.com/2015/02/powerbi-preview-reporting-from-sql_13.html
(19 Feb '15, 15:12)
mysorian
|