I am using Windows 10 and trying to create and ODBC  on SQL Server 2012 for Oracle/MySQL but test result reads "TEST FAILED" as seen in the inserted images. Please note that I am following a book that is using SQL Server 2008 on Windows Server 2008. Therefore, I am not knowledgeable about some other technical details. Please see the below images for some information that MAYBE helpful and I will appreciate your help in solving this.

Try specifying your instance name.

If you don't know your instance name, check the running services. It'll be in there.

server\instance

can check can telnet port number ?

Hi Patrick,

I had a typo with the server/instance name and later made the correction but encountered another problem as seen in the screen shot below: I also created another login with a different name(e.g. VRG-User1) but had the same result as the one below.

Screen shot for server name instance.

Check the file named errorlog in your SQL Server installation. This has the exact reason why the login attempt was refused.

Hi Tibor,

My system was set to Windows authentication mode and I had to switch to SQL Server and Windows authentication mode and also change the user(VRG-User) password. I appreciate your help.