Skip to Content.
Sympa Menu

freetds - 回复: RE: ??: RE: [freetds] I can not use freeTDS for Oracle HS

freetds AT lists.ibiblio.org

Subject: FreeTDS Development Group

List archive

Chronological Thread  
  • From: Wei Jiang <impc75 AT yahoo.com.cn>
  • To: FreeTDS Development Group <freetds AT lists.ibiblio.org>
  • Subject: 回复: RE: ??: RE: [freetds] I can not use freeTDS for Oracle HS
  • Date: Fri, 17 Jun 2005 17:21:49 +0800 (CST)


--- "ZIGLIO, Frediano, VF-IT"
<Frediano.Ziglio AT vodafone.com>写道:

> > >
> > > You must use a DM to make HS happy.
> > >
> > Sorry, I don't know what's the ODBC Driver
> Manager,
> > could you tell me what's it, how to configure it
> if I
> > use unixODBC.
> >
>
> unixODBC is, in this case, the DM. Simply instead of
> loading
> libtdsodbc.so (that is the ODBC driver) driver
> configure unixODBC to use
> FreeTDS driver and use DM library (usually
> /usr/lib/libodbc.so).
>
> To configure unixODBC you have to chanve your
> odbc.ini. For instance put
> in ~/.odbc.ini
>
> [dsnname]
> Driver = /usr/lib/libtdsodbc.so
> Server = servername
> DataBase = dbname
> Port = 1433
> TDS_Version = 8.0
>
> (replacing dsnname, dbname and servername with
> server name to use in
> Oracle HS, sql database name and real server name
> and changing
> port/tds_version if required)
>
> freddy77
> _______________________________________________
> FreeTDS mailing list
> FreeTDS AT lists.ibiblio.org
> http://lists.ibiblio.org/mailman/listinfo/freetds
>
I have change my config file, but I got these
messages:

SQL> /
select count(d_time) from record@hscwa
*
ERROR at line 1:
ORA-02068: following severe error from HSCWA
ORA-28511: lost RPC connection to heterogeneous remote
agent using SID=%s
ORA-28509: unable to establish a connection to
non-Oracle system

odbc.ini
[ODBC Data Sources]
HSCWA = Check the Work

[HSCWA]
Driver = /usr/local/lib/libtdsodbc.so
Description = Check the Work
Trace = No
Server = 172.16.0.9
Database = JSST
Port = 1433
TDS_Version = 8.0

[Default]
Driver = /usr/local/lib/libtdsodbc.so

odbcinst.ini
[TDS]
Description = v0.63 with protocol v4.2
Driver = /usr/local/lib/libtdsodbc.so
Setup = /usr/local/lib/libtdsodbcS.so
UsageCount = 2
Trace = 1
TraceFile = /tmp/sql.log

[ODBC]
Trace = 1
TraceFile = /tmp/sql1.log
ForceTrace = Yes
Pooling = No

initHSCWA.ini
HS_FDS_CONNECT_INFO = HSCWA
HS_FDS_TRACE_LEVEL = 4
HS_FDS_TRACE_FILE = /tmp/hstrace
#HS_FDS_SHAREABLE_NAME = /usr/local/lib/libtdsodbc.so
HS_FDS_SHAREABLE_NAME = /usr/local/lib/libodbc.so
#<full path name of odbc driver manager or driver>

#
# ODBC specific environment variables
#
#set ODBCINI=<full path name of the odbc initilization
file>
set ODBCINI=/usr/local/etc/odbc.ini

Where is the problem ? Please help me to check it, I
have processed it for 10 days. :(
Thank you .






___________________________________________________________
雅虎免费G邮箱-中国第一绝无垃圾邮件骚扰超大邮箱
http://cn.mail.yahoo.com/?id=77071





Archive powered by MHonArc 2.6.24.

Top of Page