Setup a Linked Server to MS Access from SQL Server – Beat the errors

Normally, it is easy enough to setup a Linked Server on SQL Server to other data sources. Problems are usually caused by¬†one of the usual culprits that have to be addressed SQL Logins simply do not work well when trying to do this type of setup The Windows login has to have permissions to the … Continue reading Setup a Linked Server to MS Access from SQL Server – Beat the errors

SQLPlus, TNSPing & everything just hang without errors

Usually, when you connect to Oracle, you get errors that give you some feedback on what is happening. Today, I ran into an issue where everything just hung. TNSPing, SQLPlus... you name it. The issue had to be connectivity related but what is it? In our case, we use an LDAP server as a directory … Continue reading SQLPlus, TNSPing & everything just hang without errors