If the currently logged in user does not have the necessary rights, you will need to contact the IT administrator to get the proper access or run the following commands. Since SmartConnect is a bit application, it will only work with bit ODBC drivers, so we can add a parameter to look for just bit drivers.
You can use this file on a machine that is running SmartConnect successfully to compare it with a list from a non-working client machine. This shows the function in SmartConnect, the driver and version used and what type of data for the connection. When the Access Drivers are not installed or the bit version only is installed we will get an error regarding the data source not found.
An invalid odbc query syntax will generate a generic error regarding parameters or missing command. Make sure the column names are referenced correctly within the query since SmartConnect removes the spaces when displaying the data. When using the column in a query, the actual name should be used from the Excel column header.
Expected 1. This is an error in the Query being used. If the user does not have access to the file, the following error will appear when trying to Validate the connection or Preview the data. The connection test is successful. However, when you click Next, you receive the following error message: The following is a sample of the connection string that you created:. On several other servers the process cube works fine. Posted: 6 days ago Failed to update data source credentials: ODBC : ERROR [ ] No default role has been assigned to the user, contact a local system administrator to assign a default role and retry.
Set default role for the user. Default role for the user is not granted to the user. The assignment of class and subclass values is defined by SQL Although successful execution of a function is normally indicated by a return I'm not sure what i'd gain from using on-premesis as opposed to personal when it comes to ODBC.
SQL Server Error : If i untick use trusted connection, and enter my own userid in here, I still cannot connect and get the same message but with "The user is not Posted: 1 day ago The website service may be running as x64 process and may not have access to the 32 bit ODBC driver from Sage. That ODBC driver only works via 32bit access. What is the name of the first worksheet? Actual sheets names: "Full", "Lite". I'm trying to access "Full". Did you change the error message as well then? Yes, I substituted 'Full' with 'Sheet1' to be more generic.
As I said it works with an absolute path so the names appear correct. Add a comment. Active Oldest Votes. Improve this answer. Community Bot 1 1 1 silver badge. Sign up or log in Sign up using Google. Updated August 17, Post Link. Sort by: Most popular Most popular Oldest to newest Newest to oldest. You are not allowed to follow up in this post. Sort by: Most popular Newest to oldest Most popular Oldest to newest.
0コメント