different Connection string

StatusIDPriorityType
Closed29644BlockerQuestion
ProfileReply
Micah ArmantroutClient

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

Provider=MSOLAP.4; Data Source=https://bi.galaktikasoft.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 ?

Replies

UserDescriptionPosted On
Micah ArmantroutClient

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

PetrAdministrator

Hi Micah Armantrou!

Do you want to change the connection string on our demo server (in app https://bi.galaktikasoft.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

Petr

 

 

Micah ArmantroutClient

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.galaktikasoft.com/js/ranetolap/ ) to test on my server ?

Micah ArmantroutClient

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.

PetrAdministrator

Hi, Micah Armantrou!

Tomorrow our administrators will fix the problem on our demoserver.

Deploy the Ranet application on your server.

Best regards

Petr

 

Micah ArmantroutClient

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

Micah ArmantroutClient

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 ?

PetrAdministrator

Download the archive HTML5.Pivot.Table 5.7.150 https://galaktikasoft.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 ArmantroutClient

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

PetrAdministrator

The documents in section Support Materials HTML5

https://galaktikasoft.com/ranet-olap/download

  • 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.

https://www.youtube.com/watch?v=t9fXu1lDsEA

× This ticket is closed.

Write US