Code for DSN-Less connection not working?

  • Thread starter Thread starter LisaB
  • Start date Start date
L

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)
)
)
 
Back
Top