IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Expand all | Collapse all

X-Node- ODBC error

  • 1.  X-Node- ODBC error

    Posted Wed August 21, 2002 11:03 AM

    when i tried to define my schema which is mapped to x-node, to the database i got this error.

    ERROR:
    ODBC error occurred ;X-Node license missing for Microsoft SQL

    How can i get out of this error.

    additional info.
    1. i’m using Windows NT server.
    2. DSN is a System DSN.


    #API-Management
    #Tamino
    #webMethods


  • 2.  RE: X-Node- ODBC error

    Posted Wed August 21, 2002 12:40 PM
    1. i’m trying to connect to Microsoft SQL Server Service Manager version 8.x
      4. i’m using Tamino Developer Edition

    #API-Management
    #Tamino
    #webMethods


  • 3.  RE: X-Node- ODBC error

    Posted Thu August 22, 2002 01:17 PM

    You need X-Node for Microsoft SQL ennabled in your Tamino License file.
    You can see it in Tamino Manager, click on
    hostname-Tamino-Versions-YourVersion
    and there your license appears.
    Look for:
    -Component | TaminoXnode
    --DBMS | SQL DBMS enabled in your license.


    #Tamino
    #webMethods
    #API-Management


  • 4.  RE: X-Node- ODBC error

    Posted Thu August 22, 2002 02:02 PM

    SoftwareAG_License

    - Component TaminoXNode
    - - DBMS SQL Server, Informix, ACCESS, DB2, Microsoft SQL Server, Oracle, ADABAS D, ADABAS
    - Component TaminoSQL
    - - SQL no

    when i define the schema to a database it is giving me the error.

    i’m using Microsoft SQL Server Service Manager
    version 8.00.194


    #webMethods
    #API-Management
    #Tamino


  • 5.  RE: X-Node- ODBC error



  • 6.  RE: X-Node- ODBC error

    Posted Wed August 28, 2002 09:15 AM

    while defining schema to database i got this error:

    ODBC error occured;State: HYC00Native Error:106 [Microsoft][ODBC Microsoft Access Driver]Optional feature not implemented

    what does this error signify?

    i followed your suggestion and gave it as
    database:DSN.

    regards.


    #Tamino
    #API-Management
    #webMethods


  • 7.  RE: X-Node- ODBC error

    Posted Fri August 30, 2002 03:22 PM

    I’ve got entangled
    Do you use MS SQL Server or MS Access?


    #webMethods
    #API-Management
    #Tamino


  • 8.  RE: X-Node- ODBC error

    Posted Mon September 02, 2002 08:24 AM

    First i did with sql server and later tried with access but the error is same for both…


    #Tamino
    #webMethods
    #API-Management


  • 9.  RE: X-Node- ODBC error

    Posted Mon September 02, 2002 10:12 PM

    I’ve tried both with MS SQL Server and Access. Everything seems to be OK.

    For MS SQL Server:
    Microsoft SQL Server:Northwind

    For MS Access:
    ACCESS:Northwind

    The first part of datasource property is DBMS name (or driver name). The string must be exactly the same as in your licence file. The second part is DSN.

    In almost cases you can use just DSN. But there is a problem with MS SQL Server 2000. Specifying correct driver name solves it.

    My configuration:
    Tamino 3.1.2.1
    MS SQL Server 2000 (SP2) v8.00.534
    MS Access XP


    #webMethods
    #API-Management
    #Tamino