I am running vscode 1.102.1 with SQL developer extension 25.2.1.
Once the
Activating SQL developer extension for VSCode
message disappears, I get the following error, and cannot connect to any databases. Even using a basic connection type, which shouldn't use a tnsnames.ora returns the below error:
TNS Configuration has a syntax error. The following error occurred when parsing: DESCRIPTION=(ADDRESS_LIST, error: TNS-04610: No literals left, reached end of NV pair. Ensure the TNS configuration resource is well-formed
Opening a powershell prompt I can see my TNS_ADMIN variable is set, and there is a tnsnames.ora there which looks OK to me (Though it has hundreds of databases in it), I can do a tnsping of databases in there for example.
Is there a way for me to check that the tnsnames.ora file is well formed? Or to get more information about which entry it is complaining about? Or even to check I am looking at the correct file?