Set up Query on datalink to SQL Seerver 2005

Permanently deleted user

December 23, 2009 04:38

Hi,   I am in need of setting up a query on a table in sqlserver 2005 database.  I have created a datalink element, but I do not see how to make a query on a specific table at this resource.  I do not want to make a spatial join on any feature class in the mxd, I just want to query a table in sql server.   Is this possible?   Thanks for your time.   Colin

0

• 

  Permanently deleted user

  December 29, 2009 06:54

  It is possible to query a table without creating a spatial join. The Charlotte sample site has a Point of Interest datalink connection and a configurable search. I would refer to this for examples.

   

   

  0
• 

  Permanently deleted user

  January 09, 2010 05:04

  The POI is based on an excel spreadsheet, and I have tried unsuccessfully to emulate it for a sql server table.  I have createed a datalink to a sql server database.  I need to query a specific table and have tried a query in GE thusly:   SELECT * FROM MYDB.MYTABLE WHERE MYFIELD LIKE ? + '%'    and also   SELECT * FROM MYDB.MYTABLE WHERE MYFIELD LIKE '%{0}%'   Does any one have an example for connecting to a specific sql server table via a datalink.  Again this is a non-spatial table in sql server.  I added it to the mxd but it does not show up as a layer resource and I have created a datalink to the database.   Thanks  

   

   

  0

Please sign in to leave a comment.