Code for DSN-Less connection not working?

[LisaB]

Code:
tdfCurrent.Connect = "ODBC;" & _
"Driver={Microsoft ODBC for Oracle};" & _
"Server=avidynhealth;" & _
"Uid=myUsername;" & _
"Pwd=myPassword"

Have tried san-oraprod1 and PRDAVDW as the server name and it still doesn't
work.

Get error cannot connect.
Here is my tnsnames.ora
PRDAVDW.avidynhealth.net=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tcp)(HOST = san-oraprod1.fhi.net)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = PRDAVDW.fhi.net)
(INSTANCE_NAME = PRDAVDW)
(SERVER = DEDICATED)
)
)

 

[Douglas J. Steele]

I don't know enough about Oracle to know for certain, but at
http://www.carlprothman.net/Default.aspx?tabid=90#ODBCDriverForOracleFromMicrosoft
Carl Prothman seems to be putting ".world" as part of the server name.