Re: HS ODBC - DBLINK

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=localhost)
> 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 Tue Sep 21 2004 - 08:28:48 CDT