=?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