In different cases in our everyday life, among other, we face different technical challenges. These challenges, might have to do with a task we are trying to perform at work, an error we get on our smartphone, etc.
In this single post, I will be providing short solutions and tips, to different technical challenges I face throughout the day. These solutions, will be categorized accordingly.
A. Tech Challenges on Android Devices
Challenge 1: What to do when an App doesn’t start on my Android device?
In case where an app on your Android device, suddenly stops from launching, here’s what you can try:
Go to settings – apps, then force stop the app, and clear the cache
Restart the phone
If the problem is not resolved, you can try uninstalling and re-installing the app be careful not to lose any data – backup your data before this step
If nothing of the above helps, and you suspect that your application, is the type of application that displays web content (example: security camera viewer app, etc.), then you can try uninstalling and installing again, the latest version of “Android System Webview”. Android System Webview, is a system component powered by Chrome that allows Android apps to display web content.
B. Tech Challenges in SQL Server
Challenge 1: Your SQL Server linked server to Oracle database gives an error message…
In case where you have just set up a linked server in SQL Server that points to an Oracle database, and when trying to list the remote database’s tables you get the below error message, read on to see what you can try.
Error Message
“The OLE DB provider “OraOLEDB.Oracle” for linked server “” reported an error. Access denied.”
Cannot obtain the required interface (“…”) from OLE DB provider “OraOLEDB.Oracle” for linked server “…”.
How to Resolve it
If all is good with the user credentials set in the linked server and the given user indeed has access to the remote database, then the next step to do, in order to resolve the issue, is via SQL Server Management Studio, to navigate to “Server Objects”, “Linked Servers”, “Providers” and enter the properties of provider “OraOLEDB.Oracle”. In there, you can check the “Allow inprocess” option and click “OK”.
You can then try again to use the linked server and see if it works.
Challenge 2: Which is the latest version of SSMS that supports 32-bit Windows OS?
SQL Server Management Studio (SSMS), can only be installed on a 64-bit Windows OS.
However, if you are using a 32-bit version of Windows and you are looking for the latest version of SSMS that can be installed on your 32-bit Windows machine, then you can download SQL Server 2014 Express and you will be able to install that version of SSMS on a 32-bit Windows machine.
More tips are coming soon!
Strengthen your SQL Server Administration Skills – Enroll to our Online Course!
Via the course, you will learn essential hands-on SQL Server Administration tips on SQL Server maintenance, security, performance, integration, error handling and more. Many live demonstrations and downloadable resources included!
(Lifetime Access/ Live Demos / Downloadable Resources and more!)
Sharpen your SQL Server database programming skills via a large set of tips on T-SQL and database development techniques. The course, among other, features over than 30 live demonstrations!
(Lifetime Access, Certificate of Completion, downloadable resources and more!)
Artemakis Artemiou is a Senior SQL Server Architect, Author, a 9 Times Microsoft Data Platform MVP (2009-2018) and a Udemy Instructor. He has over 15 years of experience in the IT industry in various roles. Artemakis is the founder of SQLNetHub and TechHowTos.com. Artemakis is the creator of the well-known software tools Snippets Generator and DBA Security Advisor. Also, he is the author of many eBooks on SQL Server. Artemakis currently serves as the President of the Cyprus .NET User Group (CDNUG) and the International .NET Association Country Leader for Cyprus (INETA). Moreover, Artemakis teaches on Udemy, you can check his courses here.
This site uses cookies for personalized content and the best possible experience. By continuing to browse this site, you agree to this use. Find out more.
Loading...
