VB6. DataEnvironment: How to Configure/Set Trusted Connection?

Question

Hi,

I have a DataEnvironment component in my VB 6 application. I cant configure the DataEnvironment connection to use trusted connection without ask me how to connect. I could set prompt to never appear, but it doesnt connect becouse it doesnt use trusted.

In this link you could see the screens of DataEnvironment Connection Options and the prompt.

Google Presentation Link

I need this program to be executed from a D.O.S console without prompt anything.

Thanks a lot!

Answer 1

Seems like you have to do it in code: See: http://support.microsoft.com/kb/195982

DataEnvironment1.Connection1.Properties("Prompt") = adPromptNever.

Answer 2

By Trusted do you mean you want to connect using Windows Authentication? If so how about adding ;Integrated Security=SSPI to your ConnectionSource?