different Connection string

Profile Reply
Micah Armantrout Client

I would like to change my connection string in the HTML demo of RanetPivotTable from

Provider=MSOLAP.4; Data Source=https://bi.galaktika-soft.com/olap/2012/msmdpump.dll; Catalog=AdventureWorksDW2012 MD-EE;

to something like

connectionString="Data Source=https://xxxx.xxxx.com/;Initial Catalog=PADataStore; Provider=MSOLAP.6; User Id=XXXXXX; Password=XXXXXX; MDX Compatibility=1;

but it says it can't find the server. A server exists at that address as I am using it currently in my production application an ideas ?


User Description Posted On
Micah Armantrout Client

I do get this error

Microsoft.AnalysisServices.AdomdClient.AdomdConnectionException: The connection either timed out or was lost. ---> System.Net.WebException: Невозможно соединиться с удаленным сервером ---> System.Net.Sockets.SocketException: Попытка установить соединение была безуспешной, т.к. от другого компьютера за требуемое время не получен нужный отклик, или было разорвано уже установленное соединение из-за неверного отклика уже подключенного компьютера X.X.X.X:443
в System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
в System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)
--- Конец трассировки внутреннего стека исключений ---
в System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)
в System.Net.HttpWebRequest.GetRequestStream()
в Microsoft.AnalysisServices.AdomdClient.HttpStream.GetRequestStream()
в Microsoft.AnalysisServices.AdomdClient.HttpStream.Write(Byte[] buffer, Int32 offset, Int32 size)
--- Конец трассировки внутреннего стека исключений ---
в Microsoft.AnalysisServices.AdomdClient.XmlaClient.EndRequest()
в Microsoft.AnalysisServices.AdomdClient.XmlaClient.SendMessage(Boolean endReceivalIfException, Boolean readSession, Boolean readNamespaceCompatibility)
в Microsoft.AnalysisServices.AdomdClient.AdomdConnection.XmlaClientProvider.Microsoft.AnalysisServices.AdomdClient.AdomdConnection.IXmlaClientProviderEx.Discover(String requestType, IDictionary restrictions, InlineErrorHandlingType inlineErrorHandling, Boolean sendNamespaceCompatibility)
в Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ReadDataSourceInfo()
в Microsoft.AnalysisServices.AdomdClient.AdomdConnection.ConnectToXMLA(Boolean createSession, Boolean isHTTP)
в Microsoft.AnalysisServices.AdomdClient.AdomdConnection.Open()
в Ranet.Analytics.PivotGrid.Controllers.DataSourceController.GetAdomdConnection(String connection, String contextId, Boolean tryOpenAgain) в c:\Builds\7\11\src\Projects\Ranet.Mobile.Analytics\Ranet.Analytics.PivotGrid\Controllers\DataSourceController.cs:строка 979
в Ranet.Analytics.PivotGrid.Controllers.DataSourceController.CheckConnection(ConnectionCheckingRequestModel request) в c:\Builds\7\11\src\Projects\Ranet.Mobile.Analytics\Ranet.Analytics.PivotGrid\Controllers\DataSourceController.cs:строка 534

Petr Administrator

Hi Micah Armantrou!

Do you want to change the connection string on our demo server (in app https://bi.galaktika-soft.com/js/ranetolap/ )?

If so - the application will not work. The current server settings do not allow this. We will discuss this problem with system administrators and, perhaps, they will offer a solution.

If Ranet App is deployed on your server - connect to the source from another application, for example Excel or Management Studio.

Best regards




Micah Armantrout Client

Hey Petr I just realized that the demo is hosted on your server not mine. Is there a way I can have that(https://bi.galaktika-soft.com/js/ranetolap/ ) to test on my server ?

Micah Armantrout Client

Also the other demos do not appear to be connecting you your servers. I'd would like to be able to demo something this week and it if works we could move forward on purchasing the software.

Petr Administrator

Hi, Micah Armantrou!

Tomorrow our administrators will fix the problem on our demoserver.

Deploy the Ranet application on your server.

Best regards



Micah Armantrout Client

what should I deploy to our server ? is that after your administrator fixes the problem on your demoserver ?

Micah Armantrout Client

I also realized that my cube is behind our firewall so your server is not going to be able to talk to our cube. Can I deploy what is on your server you my server ?

Petr Administrator

Download the archive HTML5.Pivot.Table 5.7.150 https://galaktika-soft.com/download-all/31694/  and deploy the application to IIS

  • Save the archive to a folder on the local disk
  • Run IIS Manager
  • Default Web Site -> Add Application...
  • select Application pool: ASP NET v4.0 Classic


Micah Armantrout Client

Alright cool I have that working is there documentation for this control I can look to ?

Petr Administrator

The documents in section Support Materials HTML5


  • ASP.NET MVC App Integration Example
  • ASP.NET MVC App Integration Manual
  • HTML5 PivotTable Quik Start
  • Using Ranet OLAP HTML Front-End API
  • Using Ranet OLAP HTML Server AP

Documentation for the end user is now in work.

We have an overview video, but it's made for older versions. Although in the new all the main functions are the same.


× This ticket is closed.

Write US