connection string provider

Results 1 to 3 of 3

Thread: connection string provider

  1. #1
    Join Date
    Dec 1969

    Default connection string provider

    Exception Details: System.ArgumentException: Unknown connection option in connection string: provider.<BR><BR>Source Error: <BR><BR><BR>Line 9: Sub BindData()<BR>Line 10: <BR>Line 11: Dim con As New SqlConnection("Provider=SQLOLEDB.1;Password=asd;Pe rsist Security Info=True;User ID=sa;Initial Catalog=twac;Data Source=twac")<BR>Line 12: Dim cmd As SqlCommand<BR>Line 13: con.Open()<BR><BR>Source File: c:inetpubwwwroot Line: 11 <BR><BR>I am getting this error, can any one see what is wrong with the provider part of my connection string or is that not the problem<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: connection string provider

    SQLOLEDB instead of SQLOLEDB.1

  3. #3
    Join Date
    Dec 1969

    Default No

    this is a connection string for the native SQL Server objects for .NET. The Provider arguement isn&#039;t valid here.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts