Forum Stats

  • 3,767,820 Users
  • 2,252,720 Discussions
  • 7,874,337 Comments

Discussions

ODBC

User_M3LFA
User_M3LFA Member Posts: 7 Green Ribbon

I 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)

The entry in the TNSNAMES.ORA file:

PTU =

 (DESCRIPTION =

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

  (CONNECT_DATA =

   (SERVER = DEDICATED)

   (SERVICE_NAME = PTU)

  )

 )





Any suggestions would be greatly appreciated.