OLE/DB for DB2 Does Not Prompt for User Name and Password

Article translations Article translations
Article ID: 244794 - View products that this article applies to.
This article was previously published under Q244794
This article has been archived. It is offered "as is" and will no longer be updated.
Expand all | Collapse all


When you configure the OLE/DB Provider for DB2, if the user name and password are left blank in the Data Link Properties sheet, or if only the password field is blank, SNA Server 4.0 Service Pack (SP) 2 prompts you for the information with a dialog box; however, in this same scenario, SNA Server 4.0 SP3 fails with the following error message:
Test connection failed because of an error in initializing provider. Command syntax error. SQLSTATE: HY000, SQLCODE: -379


This is due to a change in the MDAC DataLink default behavior. With the new MDAC, the default for the DBPROP_INIT_PROMPT is DBPROMPT_NOPROMPT, and not DBPROMPT_COMPLETE.


In order to be prompted for the missing user ID and password, edit the UDL by adding another parameter, "Prompt=2," into the connection string.

To edit the UDL, start Windows Notepad, and open the problem *.udl file. At the end of the connection string, add the following parameter with no spaces between it and the last entry:
Save the *.udl file, and then attempt the test connection again.


Hardcode a user ID and password into the Data Link Properties page.


Article ID: 244794 - Last Review: February 28, 2014 - Revision: 3.1
  • Microsoft SNA Server 4.0 Service Pack 3
kbnosurvey kbarchive KB244794

Give Feedback


Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com