Re: Robby@Here.Now

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Kevin Yu [MSFT] (v-kevy_at_online.microsoft.com)
Date: 02/20/04 

Date: Fri, 20 Feb 2004 08:38:17 GMT

Hi Robby,

I'm afraid that this is by design. When you use the Data Link Properties
dialog in VS.NET IDE from the properties window to build the connection
string for a SqlConnection object, the generated connection string will not
include Provider=SQLOLEDB.1, as the it is using a provider dedicate to the
SQL server connection. However, in other cases, the property string will be
added, because SQLOLEDB driver is used to access SQL database.

I'm sorry for the inconvenience it has brought to you. If you have any idea
that can make our future products better, please feel free to send your
feedback to mswish@microsoft.com. Your suggestion will be highly
appreciated. Thank you!

If anything is unclear, please feel free to reply to the post.

Kevin Yu
=======
"This posting is provided "AS IS" with no warranties, and confers no
rights."

Relevant Pages

  • Re: ADO connections question
    ... Function CreateADOObjects(ConnectionString as string) ... you'll see this error if the connection has not been ... I have a specific login form that calls the dbLogin function as shown ... Dim strCriteria As String ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Nochmals Treeview
    ... private void button1_Click(object sender, System.EventArgs e) { ... private void TabelleAnlegen(string strDBPfad, string strDB, string strTabellenName){ ... OleDbConnection connection = new OleDbConnection; ... OleDbCommand command = new OleDbCommand; ...
    (microsoft.public.de.german.entwickler.dotnet.csharp)
  • Re: ExecuteReader requires an open and available Connection.
    ... you have ALL your users sharing one connection. ... Public Shared Function GetServerAs String ... Dim theServer As String ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Error using Login control ASP.NET App_Data Folder
    ... the UserInstance type of connection string is for SQLEXPRESS only and is ... Server Management Studio and use a standard connection ... An error has occurred while establishing a connection to the server. ... SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, ...
    (microsoft.public.dotnet.framework.aspnet)
  • Change Connection String during runtime
    ... connection is stored in the app.config file. ... connection string without exiting the application. ... Dim newConnection As String ... Private Sub RecordDatabase_Enter(ByVal sender As Object, ...
    (microsoft.public.dotnet.languages.vb)