Hi,
I am working with an applications developer who is deploying an internal app to a test and production server. We have a picklist field connected to a SQL database that is supposed to pull a list of employee names. However, when we publish the application to our Test server we see ONLY the error message below as an option to pick in this picklist field. The employee names do show when in Alpha and previewing the SQL query/data coming in from the employee name SQL database.
Error showing in picklist field instead of employee names from connected database:
Error: Database API specific error Your database has returned the following error code and description to Alpha Anywhere. Consult your database documentation for further information. 11001 - '[Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: No such host is known. SQL State is: 08001 [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired SQL State is: HYT00 [Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. SQL State is: 08001'
Please advise on troubleshooting tips and solutions.
Thank you,
R
I am working with an applications developer who is deploying an internal app to a test and production server. We have a picklist field connected to a SQL database that is supposed to pull a list of employee names. However, when we publish the application to our Test server we see ONLY the error message below as an option to pick in this picklist field. The employee names do show when in Alpha and previewing the SQL query/data coming in from the employee name SQL database.
Error showing in picklist field instead of employee names from connected database:
Error: Database API specific error Your database has returned the following error code and description to Alpha Anywhere. Consult your database documentation for further information. 11001 - '[Microsoft][ODBC Driver 17 for SQL Server]TCP Provider: No such host is known. SQL State is: 08001 [Microsoft][ODBC Driver 17 for SQL Server]Login timeout expired SQL State is: HYT00 [Microsoft][ODBC Driver 17 for SQL Server]A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online. SQL State is: 08001'
Please advise on troubleshooting tips and solutions.
Thank you,
R
Comment