2 Replies Latest reply: Jul 25, 2012 3:52 AM by 588514 RSS

    DG4ODBC adds black spaces after every character

    588514
      I am trying to set up HS using Oracle 10.2.0.5 on RHEL5 (64 bit), FreeTDS, and MS SQL Server.

      The ODBC Driver works fine:


      [oracle@phsbe1pr ~]$ isql sfasql_freetds_dsn sqlSinfoOne ***
      ---------------------------------------
      | Connected! |
      | |
      | sql-statement |
      | help [tablename] |
      | quit |
      | |
      ---------------------------------------
      SQL> select name, len( name ) from sys.objects where object_id < 20 ;
      ---------------------------------------------------------------------------------------------------------------------------------------------+
      | name | |
      ---------------------------------------------------------------------------------------------------------------------------------------------+
      | sysrscols | 9 |
      | sysrowsets | 10 |
      | sysallocunits | 13 |
      | sysfiles1 | 9 |
      | syspriorities | 13 |
      | sysfgfrag | 9 |
      ---------------------------------------------------------------------------------------------------------------------------------------------+
      SQLRowCount returns 6
      6 rows fetched
      SQL> quit
      [oracle@phsbe1pr ~]$

      [oracle@phsbe1pr ~]$ tsql -S SFASQL_FreeTDSName -U sqlSinfoOne -P ***
      locale is "en_US.UTF-8"
      locale charset is "UTF-8"
      using default charset "UTF-8"
      1> select name, len( name ) from sys.objects where object_id < 20
      2> order by 1
      3> go
      name
      sysallocunits 13
      sysfgfrag 9
      sysfiles1 9
      syspriorities 13
      sysrowsets 10
      sysrscols 9
      (6 rows affected)
      1> exit
      [oracle@phsbe1pr ~]$







      But when I use the dblink i got every string doubled with spaces after every char:



      [oracle@phsbe1pr ~]$ sqlplus / as sysdba

      SQL*Plus: Release 10.2.0.5.0 - Production on Mon Jul 23 17:22:25 2012

      Copyright (c) 1982, 2010, Oracle. All Rights Reserved.


      Connected to:
      Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
      With the Partitioning, OLAP, Data Mining and Real Application Testing options

      SQL> set linesize 120
      SQL> column name format a40
      SQL> select "name", length ( "name" )
      2 from sys.objects@sfasql_link
      3 where "object_id" < 20
      4 order by 1
      5 /

      name LENGTH("NAME")
      ---------------------------------------- --------------
      s y s a l l o c u n i t s 26
      s y s f g f r a g 18
      s y s f i l e s 1 18
      s y s p r i o r i t i e s 26
      s y s r o w s e t s 20
      s y s r s c o l s 18

      6 rows selected.

      SQL>




      What can I do ?

      Mi init.ora is:

      HS_FDS_CONNECT_INFO = SFASQL_DSN
      HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so
      HS_FDS_TRACE_LEVEL = off
      HS_FDS_TRACE_FILE_NAME=/tmp/odbc_hs_sfa.trc
      HS_FDS_SQLLEN_INTERPRETATION = 32
      set ODBCINI=/etc/odbc.ini

      adn odbc.ini contains:

      [SFASQL_DSN]
      Description = sqlserver
      Driver = FreeTDS
      # Servername = SFASQL_FreeTDSName
      Server = phsspbe.perfumeholding.intra
      Address = 172.17.0.45
      Port = 1433
      Database = SFA_INTERSCAMBIO
      TDS_Version = 8.0
      Language = us_english
      TextSize = 1999
      PacketSize = 1470
      ClientCharset = ISO-8859-1
      DumpFile = /tmp/odbc_sfasql_dsn.log
      DumpFileAppend = Yes
      DebugFlags =
      Encryption = off
      #Trace = Yes
      #TraceFile = /tmp/odbc_sfasql_dsn.trc


      Thank you for every answer!

      Andrea