Kbase P183462: Qualifer field does not seem to be working when specifying database in MSSQL DataServer Update / Add
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/9/2011 |
|
Status: Unverified
SYMPTOM(s):
Qualifer field does not seem to be working when specifying database in MSSQL DataServer Update / Add Table Definitions
Getting message "There are no objects in the select MSS database that satisfy the selected criteria" when using asterisk as value in Qualifier Pre-Selection field
Using Microsoft SQL Server Native ODBC driver.
FACT(s) (Environment):
Windows Server 2008
MS SQL DataServer
All Supported Operating Systems
DataServers
CAUSE:
When specifying "*" in any of the fields in the Pre-selection screen, the ABL passes '?' to the ODBC catalog API to get the name of all the objects and then the ABL code filters the result based on what was specified in the pre-selection screen.
If the ODBC driver was specified to connect to a specific database within SQL Server, or the User has a defined default database (when no database is set within the ODBC datasource) then the ABL code may not have the rights to perform a selection or the tables requested may not be in the database that has been connected to.
FIX:
Review the datasource definition to see what "Database Name" is referenced.
If the database name does not match the expected database, change it within the datasource.
If no database name is defined, then within the database itself check if the user that was selected to connect to the database has an assigned default database that it connects to.