I'm not sure it will help, but on my site, under Tips, Administration,
Advanced Stuff, there's a paper on setting up a database link. You may find
it of some use in determining precisely what is going wrong in your specific
case.
Regards
HJR
--
----------------------------------------------
Resources for Oracle: http://www.hjrdba.com
===============================
"Srinivas" <pabbathi_at_yahoo.com> wrote in message
news:ee91da38.0203080613.1cde8ef2_at_posting.google.com...
> Ok...now the "TNSping Entry1 " says OK.
>
> Then, I created database link as -
>
> create database link entry1 connect to sa identified by password using
> 'entry1'
>
> Note that the 'entry1' matches with the tnsnames.
> sid in tnsnames matches with listener sid which matches with
> init'sid'.ora file name in oracle_home\hs\admin.
> initentry1.ora has entry for dsn called entry1 which has default
> database as DBName
>
> But, when I query - select * from tablename_at_Entry1
>
> or
>
> select * from tablename_at_Entry1.dbname
>
> I get the error 12514 "TNS could not resolve service name in the
> connect descriptor"
>
> Where is the error? I am baffled.
>
> srinivas
>
> "kkrause" <kkrause.nospam_at_homesourcecapital.com> wrote in message
news:<L0Sh8.15741$Yd.602905_at_e3500-atl1.usenetserver.com>...
> > just a quick sanity check...have you stopped & re-started the listener?
> >
> > "robert malikian" <robertmalikian_at_hotmail.com> wrote in message
> > news:3c87d228_at_news1.homechoice.co.uk...
> > > Start=>run=>cmd
> > > now do a "lsnrctl status" if doesn't look good then do a "lsnrct
start".
> > In
> > > addition to this check the services see if it is running.
> > > Robert
> > > "Srinivas" <pabbathi_at_yahoo.com> wrote in message
> > > news:ee91da38.0203070803.4ae1f5dd_at_posting.google.com...
> > > > Oracle Gurus,
> > > >
> > > > I am having trouble connecting to a SQL Server 2000 database from
> > > > Oracle 8.1.7 (on Windows 2000) using generic connectivity.
> > > >
> > > > These are my configurations on the 8.1.7 server -
> > > >
> > > > tnsnames.ora
> > > >
> > > > Entry1 = (Description =
> > > > (address = (protocol=tcp)(host=entry1)(port=1521))
> > > > (connect_data=(sid=Entry1))(HS=ok)
> > > > )
> > > >
> > > >
> > > > listener.ora
> > > >
> > > > sid_list_listener=
> > > > (sid_list =
> > > > (sid_desc =
> > > > (program=hsodbc)
> > > > (sid_name=entry1)
> > > > (oracle_home=f:\oracle\ora81)
> > > > )
> > > >
> > > > initentry1.ora in $oracle_home\hs\admin\
> > > >
> > > > hs_fds_connect_info = entry1
> > > > hs_fds_trace_level = OFF
> > > > hs_fds_trace_file_name = NONE
> > > >
> > > > I have a DSN called Entry1 pointing to the SQL Server 2000 that I
want
> > > > to connect to.
> > > >
> > > > When I "TNSPING ENTRY1"
> > > >
> > > > I get the error - TNS-12541: TNS:no listener
> > > >
> > > > What did I do wrong to cause this error?
> > > >
> > > > srinivas
> > >
> > >
Received on Fri Mar 08 2002 - 13:47:03 CST
