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

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