Difference between revisions of "Troubleshooting example webvirtualtables"

From Lianjapedia
Jump to: navigation, search
Line 90: Line 90:
  
 
You should now be able to open the App in the Lianja App Center.  If not, check that you have correctly deployed the example_webvirtualtables App and the cloudlibtest database.
 
You should now be able to open the App in the Lianja App Center.  If not, check that you have correctly deployed the example_webvirtualtables App and the cloudlibtest database.
 +
 +
<br clear=all>
 +
 +
==Test Web App==
 +
 +
[[{{ns:file}}:vtweb_deployappweb.png|450px|thumb|left|link={{filepath:vtweb_deployappweb.png}}|Deploy App for Web Client]]
 +
 +
 +
 +
 +
Open the example_webvirtualtables App in the App Builder, click '''Web App View''', then click '''Deploy''' .
 +
 +
<br clear=all>
 +
 +
[[{{ns:file}}:vtweb_browser.png|450px|thumb|left|link={{filepath:vtweb_browser.png}}|Lianja Web Client]]
 +
 +
 +
 +
 +
You should now be able to open the App in your browser.  If not, firstly check that you have correctly deployed the example_webvirtualtables App and the cloudlibtest database.
  
 
<br clear=all>
 
<br clear=all>

Revision as of 08:59, 8 July 2015

Under Construction

See Also

Overview

Please check the following if you are having problems accessing the data from the MS SQL Server AdventureWorks database via the vt_customers Virtual Table.

Test DSN

Test Data Source



Check the following for the DSN:

  • It has been created in the 32 bit ODBC Data Source Administrator

On 64 bit Windows, this is  %windir%\SysWOW64\odbcad32.exe

  • It is a 'System DSN'
  • You are able to successfully connect to the DSN



Test Virtual Table

Open Virtual Table



Check that you can open the cloudlibtest database and the vt_customers Virtual Table.


Modify Virtual Table



You can check or modify the Virtual Table configuration from the right-click context menu or from the Additional Commands cog icon.


DSN name



If you have given your DSN a different name, make sure you update the Virtual Table configuration.


Deploy Database



If you make any changes to the Virtual Table configuration, remember to Deploy the database before trying to access it from the Lianja Web Client or the Lianja App Center Desktop Client.


Test Desktop App

Published



If you want to run the example_webvirtualtables App in the Lianja App Center Desktop Client, first check that the Published App Setting is True.


Deploy App for Desktop



Then Deploy the App.


Lianja App Center



You should now be able to open the App in the Lianja App Center. If not, check that you have correctly deployed the example_webvirtualtables App and the cloudlibtest database.


Test Web App

Deploy App for Web Client



Open the example_webvirtualtables App in the App Builder, click Web App View, then click Deploy .


Lianja Web Client



You should now be able to open the App in your browser. If not, firstly check that you have correctly deployed the example_webvirtualtables App and the cloudlibtest database.