
M Haseeb Asif • almost 8 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?
Comments are closed.
8 comments
louis mau • almost 8 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
M Haseeb Asif • almost 8 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".
M Haseeb Asif • almost 8 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.
louis mau • almost 8 years ago
Can you try using "bigsql" as the data source name? thx
M Haseeb Asif • almost 8 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?
louis mau • almost 8 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')
M Haseeb Asif • almost 8 years ago
Thanks for the link but It is redirecting me to welcome page instead of document
louis mau • almost 8 years ago
sorry for bad link. Please try this
http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/topic/com.ibm.swg.im.dbclient.install.doc/doc/r0058814.html