Re: Invoking ADO.NET Connection String dialog?

From: Ben Fidge (ben.fidge_at_btopenworld.com)
Date: 04/10/04 

Date: Sat, 10 Apr 2004 17:10:45 +0100

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?
    ... It just passes that PROMPT option down in the stack so oledb will show the ... > to retrieve an OLEDB Connection string. ... If you only use the OleDb managed provider in ado.net, ... >> Program Manager - ADO.NET Team ...
    (microsoft.public.dotnet.framework.adonet)