Unanswered: DNSless connection to Oracle not working
I can successfully link to an Oracle table from MS Access. It uses a TNS file. I now want to link to the same table via VBA and a DNS-less mode since I want the MS Access DB to be used on several computers.
I have been to CarlProthman's WEB site, to 4GuysfromRolla, I have KB193332 from MS, etc., etc. etc.
My successful DNS connection uses the following:
[copied from my TNSNAME.ORA file]
SOXP, SOXP.GES.SYMANTEC.COM = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ustu-soxdbspdin02.ges.symantec.com)(PORT=1531))(CONNECT _DATA=(SID=SOXP)))