Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle Generic Connectivity talk to SQL server with free ODBC

Re: Oracle Generic Connectivity talk to SQL server with free ODBC

From: Fabrizio <fabrizio.magni_at_mycontinent.com>
Date: Tue, 19 Jul 2005 04:39:56 GMT
Message-ID: <wu%Ce.83266$h5.3506559@news3.tin.it>


m.fangtao_at_genesis.co.nz wrote:
> But I got an error when I ran select statement.
> ERROR at line 1:
> ORA-28500: connection from ORACLE to a non-Oracle system returned this
> message:
> [Generic Connectivity Using ODBC][H006] The init parameter
> <HS_FDS_SHAREABLE_NAME> is not set. Please set it in init<orasid>.ora
> file.
> ORA-02063: preceding 2 lines from DWHT_SQL
> If I installed datadirect ODBC driver, I can set
> HS_FDS_SHAREABLE_NAME=/odbc/lib/libodbc.sl in init.ora file. But if I
> didn't
> install ODBC driver, how can I config the parameter?
>

Hi,
to set Generic Connectivity you *need* an odbc.

Of course the error you are getting is due to a HS_FDS_SHAREABLE_NAME not pointing to the odbc shared library.

If you wish a free alternatives look for unixODBC (or iODBC) + freeTDS (the latter is the driver needed for sql server and sybase).

Regards

PS: the article you postes invelves the use of ODBC.

-- 
Fabrizio Magni

fabrizio.magni_at_mycontinent.com

replace mycontinent with europe
Received on Mon Jul 18 2005 - 23:39:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US