Re: Invoking ADO.NET Connection String dialog?

From: Pablo Castro [MS] (pablocas_at_online.microsoft.com)
Date: 04/13/04 

Date: Tue, 13 Apr 2004 14:02:23 -0700

It just passes that PROMPT option down in the stack so oledb will show the
typical database login dialog. Note that it's not an ADO.NET thing, but an
OLEDB thing. 

-- 
Pablo Castro
Program Manager - ADO.NET Team
Microsoft Corp.
This posting is provided "AS IS" with no warranties, and confers no rights.
"Ben Fidge" <ben.fidge@btopenworld.com> wrote in message
news:OFQOnZxHEHA.700@TK2MSFTNGP09.phx.gbl...
> Pablo,
>
> Thanks for your reponse. I've managed to use the DataLinksClass.PromptEdit
> to retrieve an OLEDB Connection string. I've been advised elsewhere on
this
> newsgroup to check for Sql Server in the return Connection String, and
then
> simply drop the provider section. All seems ok.
>
> I'm just curious what adding "prompt=prompt" to the connection string
before
> calling DataLinksClass.PromptEdit actually does?
>
> Thanks
>
> Ben
>
>
>
> "Pablo Castro [MS]" <pablocas@online.microsoft.com> wrote in message
> news:uBwGjTpHEHA.2836@TK2MSFTNGP11.phx.gbl...
> > The data link dialog is an OLEDB feature. ADO.NET does not have a
similar
> > thing. If you only use the OleDb managed provider in ado.net, you can
> still
> > have the dialog pop-up by using the same oledb services that are
available
> > for native code (a simple way is to add "prompt=prompt" in the
connection
> > string). Note that this won't work for the other providers.
> >
> > -- 
> > Pablo Castro
> > Program Manager - ADO.NET Team
> > Microsoft Corp.
> >
> > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> >
> >
> > "Ben Fidge" <ben.fidge@btopenworld.com> wrote in message
> > news:19e7201c41d49$8efab670$a301280a@phx.gbl...
> > > How do you invoke the connection string builder (Data
> > > Link Properties) dialog box programmatically?
> > >
> > > I need to be able to allow users to manually build
> > > ADO.NET connection strings using the same dialog as the
> > > IDE does when you select "New Connection..." in the
> > > ConnectionString drop-down in SqlConnection Properties
> > > window.
> > >
> > > Thanks
> > >
> > > Ben Fidge
> >
> >
>
>

Relevant Pages

  • paging problem
    ... provider, or of the selected locktype. ... ;password=;Data Source=localhost" (it is oledb) ...
    (microsoft.public.inetserver.asp.general)
  • paging problem
    ... provider, or of the selected locktype. ... ;password=;Data Source=localhost" (it is oledb) ...
    (microsoft.public.sqlserver.programming)
  • ODBC & OLEDB
    ... The codes works fine with OLEDB to connect and run queries but with ODBC it ... What is wrong with the ODBC connection string? ... Security Info=False ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Invoking ADO.NET Connection String dialog?
    ... The data link dialog is an OLEDB feature. ... If you only use the OleDb managed provider in ado.net, ... > How do you invoke the connection string builder (Data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Invoking ADO.NET Connection String dialog?
    ... newsgroup to check for Sql Server in the return Connection String, ... > The data link dialog is an OLEDB feature. ... If you only use the OleDb managed provider in ado.net, ... > Program Manager - ADO.NET Team ...
    (microsoft.public.dotnet.framework.adonet)
Loading