Re: Problem Connecting to Oracle ODBC

thommit_at_americasm01.nt.com said...
> I'm trying to link into an Oracle database through MS Access linked tables
> so I can
> run some reports. I have setup the Oracle database in the tnsnames.ora
> file, and can access the database using SQL Plus. So my permissions and
> everything are there. BUT, when I try to link in using a new DNS or a
> direct ODBC call I get a run time error:
>
> COULD NOT RESOLVE SERVICE NAME
>
> Any suggestions? I am entering the same user ID and password I use to logon
> to SQL Plus.
>
> Thanks,
>
> Thomas
>

You didn't say what O/S or Oracle version you're using.

Did you create a System or User DSN? On Win2k, I was unable to connect using a System DSN, but as soon as I created it as a User DSN, it worked. I think it was because I don't log in as Administrator or some such MS weirdness. Of course, that was with MS Visio instead of Access, so YMMV.

If I'm not mistaken, ODBC doesn't even look at your tnsnames.ora file. So if you're able to connect thru sqlplus to gbv03p.world, then you need to use that (instead of the tnsnames alias) in your "server" entry. However, IIRC, ".world" was the convention used in Oracle7 (so you might want to comment it out in your sqlnet.ora file and cut it from your tnsnames.ora file).

-- 
/Karsten
DBA > retired > DBA