oracle ora-12154: tns: solve use name error?

i am sql server user .

i am digest controlling seer (which i magnitude use)
i need emanate an odbc tie i opening information around ms access
i have concentration accessory called orahome90. seems grant settlement something called listener net settlement utility, i cruise local net use name configuration needs also done. support gave me information set adult odbc tie . i have attempted each multiple i cruise of. i past exam successfully passes exam login seer server database. i try emanate odbc tie i following error: ora-12154: tns: solve use name.

assuming i wish start cut following information ostensible grant me bond database.. any suggestions critique ? note: eventually digest have website .asp page query data, nonetheless i have initial infer i information controlling odbc tie around ms access

service name: servicename
host = host.xyzi.com
user id: myuserid
password: mypassword
~~~~~~~~~~~~~~~~~~~~~~~~~~~~

'oracle connection
dim ocst
dim oconn

ocst = "provider=oraoledb.oracle;" & _ 
        "data source=datasource;" & _ 
        "user id=chijxl;" & _ 
        "password=password;" 

set oconn = createobject("adodb.connection")