versaSRS Knowledge Base

 

 

versaSurvey Error on Launch - Invalid object name 'tbl_VSCTForms'

Article ID: Q731194

Category: FAQ - Knowledge Base

The information in this article applies to:

  • versaSRS
  • versaSurvey

This error occurs due to versaSRS not having the correct connection string to connect to the versaSurvey database.

You can resolve this issue in two ways, either within versaSRS or directly via the database.

versaSRS Method:

1. Go to the Global Settings menu within versaSRS and locate the Application Property versaSurveyDSN

2. Set the values for the server, database, and authentication

Global Settings versaSurveysDSN

3. Ensure the Application Property versaSurveys is not set to 'Disabled'

Global Settings versaSurveys

4. Set the Application Property versaSurveyURL to the URL for your instance

Global Settings versaSurveyURL

5. Reload the Global Settings by pressing the Reload Global Settings reload icon icon

Database Method:

NOTE: VersaDev takes no responsibility for any data corruption or loss incurred, be sure to take extra care not to remove or change any data by mistake when running queries directly on the database, we recommend performing a backup and implementing on a test environment before performing on production.

  1. Open SQL Management Studio and connect to versaSRS database

  2. Go to database table tbl_ApplicationSettings

  3. Locate property versaSurveyDSN (ID: 141)

  4. Set the server name in column Value1

  5. Set the versaSurvey database name in column Value2

  6. Set SQL username in column Value3

  7. Set SQL password in column Value4 NOTE: If using Integrated Security then set the values for username and password to SSPI

  8. Locate the property versaSurveys and ensure this is set to 1 (Survey (classic)) or 2 (Survey (versaForms))

  9. Locate the property versaSurveyURL and to your public survey URL. By default it should be http://localhost/versaSurvey/view_survey.aspx

  10. In IIS recycle the Application Pool(s) for versaSRS to see the changes reflected in the application

358 Survey Buttons Not Working - v6

401 View Feedback from versaSurveys

581 Classic Survey Submit and Close browser button fix

584 Survey link issue

Did the information in this article help answer your question?

Yes
No
Did not apply

Last Reviewed: 07/08/2024
Powered By VersaDev Pty Ltd Copyright 2022
Last Reviewed:
07/08/2024

Provided by
VersaDev Support Services