Data Link Wizard Fails

Permanently deleted user

March 20, 2017 19:10

I have a data connection to an .xls file and when I test the connection it is successful.

 

Then, I'm attempting to create a data link to this excel file, but the data link wizard fails with the following error:

 

"Unable to initialize the selected data connection"

 

The data link uses the 64x bit Microsoft Excel Driver for *.xls

 

And even though I've attempted to rebuild the sql statement anything that uses this data connect fails.

 

Walter

0

• 

  Zack Robison

  March 21, 2017 23:03

  Did ou try sticking the table and/or field name in [brackets]?  That is all I have.

  0
• 

  Permanently deleted user

  May 10, 2017 15:30

  Hi Walter,

   

  Did you ever get this solved?  If not, can you please post a screenshot of your data connection as well?  

   

  The other thing you might have some luck with, is examining the xslx datalink in the LA County demo site, and comparing it to your's (Check the Police Departments layer).  

   

  If all else fails, please open a support case, so we can assist you directly!

   

  Thanks,

   

  Danny

  0
• 

  Permanently deleted user

  September 14, 2017 20:23

  This is my first time trying data links and I get the same message about "unable to initialize...". Here is a screenshot of my data connection.

   

  Any ideas?

   

  

  0
• 

  Permanently deleted user

  September 15, 2017 14:13

  One step further. I defined a name for selected cells in the Excel file and was able to create the proper SQL through the wizard. However, I am unclear how the linked data are supposed to show up in the application. When I identify one of the locations that is supposed to be linked, no information is given in the feature details. Is there something I have to configure?

   

  Cheers.

  0
• 

  Permanently deleted user

  September 15, 2017 15:13

  Here is my data link config.

   

  

  0
• 

  Permanently deleted user

  September 22, 2017 14:42

  Just to follow-up. I contacted support and Ali pointed me to the correct place in the documentation to find data link field tokens (https://docs.geocortex.com/essentials/4.8/install-help/Default.htm#ge/admin/replacement-tokens.htm%23field-tokens) for use in the feature details and description. I knew it was something obvious!

   

   

  0
• 

  Permanently deleted user

  September 27, 2017 18:36

  Thanks for following up, Heather!

  0
• 

  Permanently deleted user

  March 25, 2019 22:53

  Hi Heather,

   

  When you said you were able to create the SQL query through the wizard by defining an excel sheet name, did you use this excel sheet name after FROM in your query? I'm having the same issue.

   

   

  0

Please sign in to leave a comment.