Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2002
    Location
    Brazil
    Posts
    7

    Arrow Unanswered: ODBC connection error

    Hi,

    We was instaled and configured the Single-Tier ODBC Driver to connect my ORACLE 8i database (AIX 4.3) with my SQL Server 2000 database. The connection with SQL Server Database was succesfull configured but when i was created the database link to ORACLE, the error below was returned:

    Connected to:
    Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production
    With the Partitioning option
    JServer Release 8.1.7.4.0 - Production

    SQL> create database link hsodbc connect to "dwh01" identified by "xxx1234" using 'hsodbc' ;

    SQL> select * from lcibrh@hsodbc ;
    select * from lcibrh@hsodbc
    *
    ERROR at line 1:
    ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
    [Generic Connectivity Using ODBC][S1000] [9013]General error in nvITrans_BeginT
    - rc = -1. Please refer to the log file for details.
    ORA-02063: preceding 2 lines from HSODBC
    SQL>

    The Oracle 8i & AIX configuration is:

    TNSNAMES.ora :
    ...
    hsodbc=
    (description=
    (address= (protocol=tcp) (host=10.140.192.19) (port=1521) )
    (connect_data=(sid=hsodbc))
    (HS=OK)
    )


    LISTENER.ORA:
    ...
    (sid_desc=
    (sid_name=hsodbc )
    (oracle_home=/oracle/8.1.7)
    (program=hsodbc)
    )


    inithsodbc.ora em /oracle/8.1.7/hs/admin:
    ...
    HS_FDS_CONNECT_INFO=sql_lite
    HS_FDS_TRACE_LEVEL = 0
    HS_FDS_TRACE_FILE_NAME = odbc.trc
    HS_FDS_SHAREABLE_NAME = /oracle/8.1.7/lib/sql_st_lt.so
    set ODBCINI=/oracle/8.1.7/bin/odbc.ini


    odbc.ini :
    ...
    [ODBC Data Sources]
    sql_lite = OpenLink SQL Server Lite Driver
    [Default]
    Driver = /oracle/8.1.7/lib/sql_st_lt.so
    [sql_lite]
    Driver = /oracle/8.1.7/lib/sql_st_lt.so
    ServerType = SQLServer 2000
    Username =
    Password =
    Database = SIMBA
    Options =
    FetchBufferSize = 99
    ReadOnly =
    DeferLongFetch =
    JetFix =
    Description = Sample SQLServer 2000 Lite Connection
    NoLoginBox = Yes

    Regards,

    Délson Castro.
    IT Coordinator.
    R&SA Brasil.

  2. #2
    Join Date
    Jul 2002
    Location
    Brazil
    Posts
    7

    Post ODBC Connection - Bug Fixed

    The Openlink Support has fixed this bug in Single-Tier ODBC release 4.2.7 and the connection has successfully created.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •