Re: generic connectivity: ORA-12541

Srinivas,

note the following 2:
- hostname in listener.ora ("entry1") should point to where the tns listener is running, not the sqlserver database The only thing that should point to sqlserver is the ODBC DSN "entry1" in the line hs_fds_connect_info = entry1 in %oracle_home%\hs\admin\initentry1.ora The rest of the sqlnet setup has to do with getting hsodbc to use this entry. - you can skip the tnsnames.ora entry if you create the database link like CREATE DATABASE LINK entry1
CONNECT TO sa IDENTIFIED BY <password> USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<your TNS listener host>) (PORT=1521))(CONNECT_DATA=(SID=entry1))(HS=))' /
This will work if "lsnrctl services" shows that the TNS listener knows about the "entry1" service.

If it fails send me a mail directly, maybe we can debug this further. I've done it a hundred times succesfully.

Best regards,
Andre van Winssen

"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 Mon Mar 11 2002 - 04:36:05 CST