Hi all,
I'm trying to make Cognos work with my application MySql database, and I fail to create the ODBC DataSource.
Setup description:Server A - UBUNTU with my application and MySql 5.1 running on it.
Server B - Redhut 6 64, with Cognos 10.1 installed on it.
I have installed myodbc package on server B, and defined the following odbc.ini settings:
[ODBC Data Sources]
otipo = Otipo odbc connection
[otipo]
Driver = /usr/lib64/libmyodbc5.so
Description = ODBC for MySQL Otipo
SERVER = xxx.yyy.zzz.rrr
PORT = 3306
USER = eeee
Password = cccc
Database = dbname
To test the settings I have activated
isql otipo
Every thing works well until now.
Next, I went to Cognos -->Administration -->Configuration --> DataSource Connection
and no matter how I defined the DataSource, when I test it I get the same annoying result:
"DPR-ERR-2002 Unable to execute the request because there were no connections to the process available within the configured time limit."
The stack trace is :Handler trace back:
[the_dispatcher] com.cognos.pogo.handlers.performance.PerformanceIndicationHandler
[the_dispatcher] com.cognos.pogo.handlers.logic.ChainHandler
[service_lookup] com.cognos.pogo.handlers.engine.ServiceLookupHandler
[load_balancer] com.cognos.pogo.handlers.logic.ChainHandler
[lb_forwarder] com.cognos.p2plb.clerver.LoadBalanceHandler
[mdaChainHandler] com.cognos.pogo.handlers.logic.ChainHandler
[asyncMetadataServiceHandler] com.cognos.pogo.async.impl.AsyncHandler
[metadataServiceHandler] com.cognos.metadataService.bibusHandler.MDSRVHandler
In the cogserver log , I see this error message:
Process BmtMDProviderMain failed to start properly.
Is it an installation problem or an ODBC problem?
These are the connection string I tried:
- ;LOCAL;OD;DSN=otipo;@ASYNC=0@0/0@COLSEQ=
- Driver=/usr/lib64/libmyodbc5.so;Server=the_server;User=the_user;Password=the_password;Database=db_name
- ;LOCAL;OD;DSN=OtipoDB;Server=the_server;Port=3306;Database=the_db;Uid=the_user;Pwd=the_password;@ASYNC=0@0/0@COLSEQ=
Any help will be appreciated.
Golan