Hi
I am connecting to oracle database in vba via
c.Open "Driver={Oracle in OraClient12Home1_32bit};" & _
"Server=" & sServer & ";" & _
"Uid=" & id & ";" & _
"Pwd=" & pw & ";" & _
"DBQ=" & service_name
However when i copy from the recordset, special characters like æøå (danish language) disappear. Anyone got any idea how i could change this eg. by changing some kind of environemt settings etc?
I am connecting to oracle database in vba via
c.Open "Driver={Oracle in OraClient12Home1_32bit};" & _
"Server=" & sServer & ";" & _
"Uid=" & id & ";" & _
"Pwd=" & pw & ";" & _
"DBQ=" & service_name
However when i copy from the recordset, special characters like æøå (danish language) disappear. Anyone got any idea how i could change this eg. by changing some kind of environemt settings etc?