Hai,

  Can anyone tell what is adPromptAlways and what is the purpose?

Hi

adPromptAlways will always prompt you for connection information even if you
have specified it in the connection string, usually it would mean that you
want to user to log in using a their own username and password.

These may help:
http://support.microsoft.com/kb/195982
http://support.microsoft.com/kb/200886


John

Show quoteHide quote

used within ADO connections via ODBC.A prompt for missing paramters when
making a connection,
Avoid using in trusted connections

Show quoteHide quote

Stop & Start SQL Server for using scm
expectations for SUM query on 50+ million rows
Internal SQL Server error
Trusted Connection failing
Why do Ado.net don't use execution plan that Query Analyzer
Move 2000 to 2005
Query suddenly becomes very slow
Page coruption
Management Studio Question....
Stored procedures in master database SQL Server 200/2005