(Moving your post to the VS Code forum)
I don't know the first thing about LINQPad but I googled a bit and it appears there is a SERVICE NAME field in the Advanced tab.
Once you have that you can use Basic connection and you have all the info you need to fill in the fields.
If that doesn't work, show me the contents of your Advanced tab.
I updated the original post. Hope that helps. Can you help me understand the relationship between servername and service name?
Rather than updating the original post, please just reply with info. Otherwise it is hard to follow this thread later for others.
Can you give me the connection string field in the advanced tab? (obfuscated as needed). That is likely where the needed info is.
Server name is the machine name., Service name is the name of Oracle's endpoint, listening for a connection.
If this helps. my sqlnet.ora has
and my ldap.ora has:
DEFAULT_ADMIN_CONTEXT = "dc=bkng,dc=net"
DIRECTORY_SERVERS = (bngoradir.bkng.net:389:636, bngoradir2.bkng.net:389:636, bngoradir3.bkng.net:389:636)
DIRECTORY_SERVER_TYPE = OID
I don;'t have a tsnames.ora file
You are correct, that is not enough info.
I suspect that LINQPad is getting the info elsewhere (config file?) but googling has failed me there.
Here is one more thing you can try: Oracle Client has a file called TNSNAMES.ORA that it can use to store for aliases to connections.
Search your whole disk drive for TNSNAMES.ORA and see if you can find one. When you do, look inside as see if you see a connect descriptor that connects to the machine you want. You should be able to find the service name there.
If that does not exist on your machine, the next step is to email your DBA
If you are truly using LDAP, then you are unfortunately out of luck as these tools do not currently support LDAP (we hope to in a coming release).
Try searching your whole hard drive for TNSNAMES.ORA in case you have a copy where you don't expect to see if you can get a service name there. Also try contacting your DBA to see if you can connect using a service name rather than LDAP.
Yeah I don't have a tsnames.ora. have to wait until you support ldap! Thanks for helping me understand better
We have a workaround that could get you going with this.
Could you email me at christian (dot) shay (at) oracle (dot) com?
In your email, please let me know the OS version you are using, and I will provide the details. Assuming the workaround works with you we can publicize this more widely a little later on.
We have a workaround that should allow LDAP to work on the current version. Please email me at email me at christian (dot) shay (at) oracle (dot) com if you would be interested in testing this out.