Share via

ODBC Connection to Oracle SQL Developer

Anonymous
2021-08-10T15:39:15+00:00

I had posted this in the Oracle Community. They closed my post and told me to check with the .Net/Windows community.

am developing an app for a client that will be using Oracle for the back end and MS Access for the front end.

The attached image is the error I get when attempting to test the connection in the ODBC Data Sources (64-bit) Administrator.

For username/password, I've tried: case as created, all lower case, all upper case, and other combinations.

Windows 10 Pro, Version 21H1, Build 19043.1110

Oracle SQL Developer Version 20.2.0.175, Build 175.1842

MS Access 2019 Version 2107, Build 14228.20226 (standalone - not part of Office 365)

TNSNAMES.ORA file. This is the entry:

PTU =

 (DESCRIPTION =

  (ADDRESS = (PROTOCOL = TCP)(HOST = ASUS_G703GX)(PORT = 1521))

  (CONNECT_DATA =

   (SERVER = DEDICATED)

   (SERVICE_NAME = PTU)

  )

 )

Any suggestions would be greatly appreciated.

Windows for home | Windows 10 | Settings

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-08-10T17:21:50+00:00

    Hi @Joe, your post is very welcome in our community.

    My name is Wiliam and I am grateful to be able to help you today.

    I understand how difficult it is when the device or app won't work in the way you expect, but this forum is intended for consumers (home users) and this is not something they normally do.

    Given the scope of your question, you will be better assisted if you post your question on the Technet Forum which is aimed at IT professionals and problems related to the corporate environment. Certainly someone in that sister community will be able to help you with your question, because it is a more common theme among that audience:

    [https://social.technet.microsoft.com/Forums/en-...](https://social.technet.microsoft.com/Forums/en-us/home)

    Thanks for your time, have a great day and stay safe.

    Best Regards

    Wiliam D.

    0 comments