Home All Groups Group Topic Archive Search About

ADODB VB Code: con.Properties("Prompt") -Anything similar in ADO.N

Author
1 Mar 2006 11:21 PM
SDRoy
Hi:

Can some please tell me if there is a way to invoke the SQL user challenge
dialog from ADO.Net ? I mean what would be the equivalent (if any) code in
ASP.Net/C# or VB.Net for the following VB code using ADODB:

        oConnection.Properties("Prompt") = adPromptAlways
        oConnection.Open "Driver={SQL Server};Server=" & _
                m_Server & ";Database=" & m_DB & ";"
        Set DBConnection = oConnection

Thanks in advance.

--
Thanks,
SDRoy

Author
2 Mar 2006 3:36 AM
Sahil Malik [MVP C#]
I just answered ur other Q.

--

- Sahil Malik [MVP]
ADO.NET 2.0 book -
http://codebetter.com/blogs/sahil.malik/archive/2005/05/13/63199.aspx
__________________________________________________________
Show quote
"SDRoy" <SD***@discussions.microsoft.com> wrote in message
news:AD009A75-797A-4530-A33A-D5A0EBE8ADA0@microsoft.com...
> Hi:
>
> Can some please tell me if there is a way to invoke the SQL user challenge
> dialog from ADO.Net ? I mean what would be the equivalent (if any) code in
> ASP.Net/C# or VB.Net for the following VB code using ADODB:
>
>        oConnection.Properties("Prompt") = adPromptAlways
>        oConnection.Open "Driver={SQL Server};Server=" & _
>                m_Server & ";Database=" & m_DB & ";"
>        Set DBConnection = oConnection
>
> Thanks in advance.
>
> --
> Thanks,
> SDRoy

AddThis Social Bookmark Button