=?gb2312?q?=BB=D8=B8=B4=A3=BA=20RE:=20=3F=3F:=20RE:=20[freetds]=20I=20can?=
=?gb2312?q?=20not=20use=20freeTDS=20for=20Oracle=20HS?=
Wei Jiang
impc75 at yahoo.com.cn
Fri Jun 17 05:21:49 EDT 2005
--- "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 at 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
More information about the FreeTDS
mailing list