data link error

Permanently deleted user

August 03, 2017 19:38

Hello,

 

I ran into this problem today. I have been able to set up data links to other sql databases no problem. However today I was not able to set up a data link to this one sql database. The data connection is fine it connects successfully. However when setting up a data link the below error occurs.

 

Other databases on the same server have no issues setting up data links.

 

Is there a setting in that database that is blocking data links? Just to say again the data connection the database connects successfully.

 

_img_ alt="User-added image" src="https://latitudegeo--c.na53.content.force.com/servlet/rtaImage?eid=906f20000000CMF&feoid=Body&refid=0EMf2000000E3xn" _/_img_

0

• 

  Permanently deleted user

  November 23, 2017 00:05

  Hi Rick,

   

  There are many reasons why we may not be able to connect to the database for a data link, even if you can connect from the Data Connection wizard.

   

  To help troubleshoot I recommend enabling the DEBUG log in Managers' Application Settings, and then try to set up your Data Link again.  Essentials Manager should write to its SYSTEM log if it cannot make a connection to the database (or issue a SQL command) for some reason.

   

  More information on logging and the location of log files is in the (https://docs.geocortex.com/essentials/4.9/admin-help/Default.htm#ge/admin/logging.htm#Change_the_Log_Levels%3FTocPath%3DReference%7CLogging%2520and%2520Log%2520Levels%7C_____1) Online Help .

   

  Regards,

   

  -Malcolm

  0

Please sign in to leave a comment.