•   over 4 years ago

Connecting to Big SQL from asp.net

I am trying to connect Big SQL from my asp.net application but no luck so far. I have tried to build ODBC connecting string using server id, username and passoword but it's not working. I think we need some provider to interact with bluemix which isn't available right now.

Is there any other way through Rest or OData that I can get data from my BlueMix Big Tables?

  • 8 comments

  •   •   over 4 years ago

    Is this the instruction you are following
    http://www-01.ibm.com/support/knowledgecenter/api/content/nl/en-us/SSPT3X_3.0.0/com.ibm.swg.im.infosphere.biginsights.admin.doc/doc/bsql_odbc_windows.html

    Can you paste your connection string info here? thx

  •   •   over 4 years ago

    Thanks for sharing the drivers link. I have installed them and configured them using ODBC Data source administrator.

    Here is the snapshot. http://imgur.com/xhUMhZh

    Following is error details

    ERROR [ ] [IBM][CLI Driver] SQL1531N The connection failed because the name specified with the DSN connection string keyword could not be found in either the db2dsdriver.cfg configuration file or the db2cli.ini configuration file. Data source name specified in the connection string: "BIGSQLBLUMIX".

    ERROR [HY000] [IBM][CLI Driver] SQL1531N The connection failed because the name specified with the DSN connection string keyword could not be found in either the db2dsdriver.cfg configuration file or the db2cli.ini configuration file. Data source name specified in the connection string: "BIGSQLBLUMIX".

  •   •   over 4 years ago

    I tried to troubleshoot using following link
    http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.swg.im.dbclient.install.doc/doc/r0058814.html

    Here are the content of db2dsdriver.cfg http://pastebin.com/H9PfYvi3 (if XML doesn't show up)












    Following is the result of command "db2cli validate -dsn BIGSQLBLUMIX"

    ===============================================================================
    Client information for the current copy (copy name: IBMDBCL1):
    ===============================================================================

    Client Package Type : IBM Data Server Driver Package
    Client Version (level/bit): DB2 v10.5.500.107 (s141128/64-bit)
    Client Platform : NT 64BIT
    Install/Instance Path : C:\PROGRA~1\IBM\IBMDAT~1

    Common App Data Path : C:\ProgramData\IBM\DB2\IBMDBCL1
    DB2DSDRIVER_CFG_PATH value:
    db2dsdriver.cfg Path : \cfg\db2dsdriver.cfg
    DB2CLIINIPATH value :
    db2cli.ini Path : \cfg\db2cli.ini
    db2diag.log Path : \db2diag.log

    ===============================================================================
    List of all IBM Data Server client packages on the current workstation:
    ===============================================================================

    Copyname Version Package Language Installed-Location
    -------------------------------------------------------------------------------
    IBMDBCL1[C,D] 10.5.05 DSD EN C:\Program Files\IBM\IBM DATA SERVER DRIVER
    -------------------------------------------------------------------------------
    DSD: IBM Data Server Driver Package
    -------------------------------------------------------------------------------

    ===============================================================================
    db2dsdriver.cfg schema validation for the entire file:
    ===============================================================================

    Success: The schema validation completed successfully without any errors.

    ===============================================================================
    db2cli.ini validation for data source name "BIGSQLBLUMIX":
    ===============================================================================

    [ Keywords used for the connection ]

    Keyword Value
    ---------------------------------------------------------------------------
    PWD ************
    UID biblumix
    DESCRIPTION **UNKNOWN**

    ===============================================================================
    db2dsdriver.cfg validation for data source name "BIGSQLBLUMIX":
    ===============================================================================

    Note: The requested data source name or a database name cannot be found in
    db2dsdriver.cfg file. The file is searched at
    "C:\ProgramData\IBM\DB2\IBMDBCL1\cfg\db2dsdriver.cfg".

    ===============================================================================
    The validation is completed.
    ===============================================================================

    I am not sure source cannot found as mentioned in the validate file.

  •   •   over 4 years ago

    Can you try using "bigsql" as the data source name? thx

  •   •   over 4 years ago

    I did and here is error
    ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified

    and I think it is because I haven't any with this name

    Can we use rest or any other approach to fetch the data?

  •   •   over 4 years ago

    There is a DB2 .Net provider which you need to use from .Net (instead of the ODBC driver). The following is a link to our step by step for getting started with the IBM Data Server Driver Package

    http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.swg.im.dbclient.install.doc

    Please give that a try. (Again, the database name should be 'bigsql')

  •   •   over 4 years ago

    Thanks for the link but It is redirecting me to welcome page instead of document

Comments are closed.