Re: Invoking ADO.NET Connection String dialog?

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

  • Next message: Pablo Castro [MS]: "Re: Using one instance of SqlConnection in an ASP.NET page" 
    Date: Fri, 9 Apr 2004 17:43:45 -0700

    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
  • Next message: Pablo Castro [MS]: "Re: Using one instance of SqlConnection in an ASP.NET page"

    Relevant Pages

    • 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?
      ... 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)
    • 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)
    • RE: OleDb for VFP very slow on simple select
      ... I saw that you include the collating seq. ... in your connection string but you could try also to execute the following command on your connection: ... Since we moved to OLEDB we've had a huge decrease in performance. ... I've seen many posts regarding poor performance from VFPOLEDB but no answers yet. ...
      (microsoft.public.data.oledb)