Getting error.....Keyword not supported: 'provider'

  • Hello, I am trying to connect to SQLExpress from an ASP.Net web app.

    Here is the connecton string:

    Provider=SQLOLEDB;Data Source=machinename\sqlexpress;Initial Catalog=databasename;User Id=*****;Password=*****;

    With the above connection string I get this error message:

    Keyword not supported: 'provider'.

    So I remove the Provider...

    Data Source=machinename\sqlexpress;Initial Catalog=databasename;User Id=*****;Password=*****;

    This connection string gives me the error...

    An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.

    So I'm damned if I put in the provider and damned if I don't. What am I missing?

    Thanks.

  • rdprecure (5/13/2009)


    Hello, I am trying to connect to SQLExpress from an ASP.Net web app.

    Here is the connecton string:

    Provider=SQLOLEDB;Data Source=machinename\sqlexpress;Initial Catalog=databasename;User Id=*****;Password=*****;

    With the above connection string I get this error message:

    Keyword not supported: 'provider'.

    So I remove the Provider...

    Data Source=machinename\sqlexpress;Initial Catalog=databasename;User Id=*****;Password=*****;

    This connection string gives me the error...

    An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.

    So I'm damned if I put in the provider and damned if I don't. What am I missing?

    Thanks.

    Shouldn't look like this, it is how I'd do it using openrowset in T-SQL:

    'SQLOLEDB','Server=machinename\sqlexpress;Initial Catalog=databasename;User Id=*****;Password=*****;'

  • Thanks for your reply.

    I'm not sure if I've implemented your example properly, but here is what I tried for the connection string (this is VB code in ASP.Net)...

    strConnection = "SQLOLEDB;Data Source=machinename\sqlexpress;Initial Catalog=dbname;User Id=****;Password=****;"

    And I get this error again...

    An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB;'.

  • Is this in a VB.NET or C# application or ASP.NET configuration file?

    Have you looked up Connection Strings in the Visual Studio help files?

  • It is a VB.Net app from within Visual Studio. My first try was from within web.config, but I later moved it into the app to see if it made a difference.

    I got this connection string from ConnectionStrings.com.

  • Hi ,

    I am using MS-Access

    The connection string i have written as followings

    <add key="DBConnString" value="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E:\LIC\Code Base\LICIQuotation_NEW\Quotation_DB_New.mdb;Persist Security Info=False;"/>

    I am getting "Keyword not supported: 'Provider'" What is cause of this. I am not getting resason as well as solution for that

    Thanks,

    Tatoba

    Regards,
    Tatoba

  • i have the same problem here..but i just reinstall the sql and then everything is fine:-)

    graphic design[/url]

  • hi guys

    thats was my problem to,

    thanks for the post

  • thanks watatop

    Regards,
    Tatoba

  • I face a similar issue and got it fixed.

    The below link was useful

    http://a2zmenu.com/Blogs/SQL/Keyword-not-supported-provider.aspx

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply