Re: HS ODBC - DBLINK

Hello Niall,   

   That's what I've made, of course : I have created an initmsql.ora and set HS_FDS_CONNECT_info = msql. My DSN calls msql too. It's very strange...

Have someone one idea please ?

Thanks

"Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message news:<1095773328.001892.145010_at_k26g2000oda.googlegroups.com>...
> cjn wrote:
> > Hello Glen,
> >
> > I followed your suggestions :
> > a) I set global names=false in my initrefdc.ora
> > b) I rename hs/admin/inithsmqsl.ora to /hs/admin/initmsql.ora
> > c) in my initmsql.ora I set HS FDS CONNECT INFO = hsmsql
> > d) I create a public database link as you tell me to bypass
> tnsnames.ora
> >
> > I got the following error :
> >
> > SQL> CREATE PUBLIC DATABASE LINK msql connect to "admin" identified
> by "admin"
> > 2 using '(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhos
> t)
> > 3 (PORT=1521))(CONNECT DATA=(SID=msql))(HS=OK))';
> >
> > Lien de base de donn es cr .
> >
> > SQL>
> > SQL> select * from toto_at_msql;
> > select * from toto_at_msql
> > *
> > ERREUR la ligne 1 :
> > ORA-28500: la connexion d'ORACLE un syst me non Oracle a
> retourn ce message
> > :
> > [Generic Connectivity Using ODBC][H006] The init parameter
> > <HS FDS CONNECT INFO> is not set. Please set it in init<orasid>.ora
> file.
> > ORA-02063: pr c dant 2 lines de MSQL
> >
> >
> > What is wrong ?
>
> HS FDS CONNECT INFO is not set!
>
> initmsql.ora should include at least the following line
>
> HS FDS CONNECT INFO=MSQL
> assuming that your DSN is called MSQL.
>
> Niall
Received on Wed Sep 22 2004 - 02:59:51 CDT