SQL Connection on SQL Database |
  
|
SQL Connection on SQL Database |
|
When trying to build a SQL connection on a SDE view with the connection type SQL connection, an error occurs. When selecting the data source, the view is selected.
The view is selected. The name contains the scheme name.
If you want to see now a preview of the data with "View Data", an error message appears:
Under the properties of the view the SQL query is checked. This is faulty select * from [dbtune (sde)].
The query is created incorrectly. It would be correct: select * from sde.dbtune
Since the authentication to the SQL server was already done when building the connection, it is not necessary to quote the scheme (the owner) to the view. ->select * from dbtune
The solution of the problem is therefore:
1. Wither changing the SQL query -> either by owner or only the tables or view name.
2. When building the connection you should not select the type SQL connection but an OleDB connection with e.g. a SQL server client. When this connection type is selected, the query is always done correctly on the table and the views -> that is without the scheme.