Page 1 of 1

Error connecting to DB2

PostPosted: Mon Sep 20, 2010 12:03 am
by samuel
Hi.

I'm getting errors trying to create a new connection to DB2 local databases.
I have tried both OLEDB and ODBC connections from DynamicAI interface but no success.

This is my environment:
Windows 7 Ultimate , 32 bits, English
IIS 7
DB2 9.7 Express-C FP 2
DynamicAI 6.4 Personal Edition

My user id is in Administrator Group, and it has full SYSADM authority in DB2.

I'm able to connect to this database using ODBC and also other applications like VDF and Java.

1. Using OLEDB :
At the first test connection attempt, I get no errors, only a "Processing..." message.
The seccond time I click the "Test connection" button I receive a the following error: "Provider cannot be found. It may not be properly installed." Please, see picture attached (OLEDB_2).
By the third time I click the "Test Connection" button, then I receive "Unspecified error".

2. Using ODBC connection:
I have created and successfuly tested an ODBC connection to my DB2 local database. No error in ODBC Layer. (Look the second picture attached, ODBC_Test).
This time I get the error: "[IBM][CLI Driver] SQL1092N "IUSR" does not have the authority to perform the requested command or operation. "
Please see attachement ODBC_Error.

I have granted IUSR user the most privilege I can, what else is needed.. and why Dynamic is using IUSR (iis user) to conncet to database instead of the user I have supplied in the connection window... ?

Please, what am I missing here ?
I would like to use OLEDB instead of ODBC, but now none is working here...
Thanks

Re: Error connecting to DB2

PostPosted: Mon Sep 27, 2010 9:42 am
by Carsten Sørensen
Hi Samuel,

Were you able to resolve this in the meantime? I'm pretty sure it is a machinename_IUSR rights issue related to the DB2 drivers / OLEDB/ODBC...

To answer your question regarding why Dynamic AI is using the IUSR instead of the database user... - Dynamic AI use the IUSR rights to initiate the connection to the database and use the DB user/assigned DB user-rights to connect to the database. IUSR is the the web-service user and DB user is the database user. In principle we could have a IUSR account in all databases or you could have all needed DB users added as web-service user accounts. In either case you would have to do some additional user rights maintenance. With the current IUSR / DB user rights distribution you - in most cases - don't have to do anything specific for Dynamic AI to function as the IUSR is setup to give you all needed web-services access and whatever existing DB user that you connect with will work underneath that context.

Best regards,
Carsten

Re: Error connecting to DB2

PostPosted: Tue Sep 28, 2010 1:21 am
by samuel
Hi Carsten.

Yes, I was able to fix that. Sorry for taking so long to answer.

I have granted IUSR user connect privilege to database.
But I don't know somehow, It was not working anyway in the same momment I have installed DAI.

It only worked properly, for both errors (ODBC and OLEDB), after I rebooted my machine.

Thanks very much!