Post reply

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

  • May 13, 2009 at 4:20 pm

    #75466

    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.

  • May 13, 2009 at 4:30 pm

    #994186

    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=*****;'

  • May 13, 2009 at 9:07 pm

    #994248

    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;'.

  • May 14, 2009 at 7:08 am

    #994474

    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?

  • May 14, 2009 at 4:01 pm

    #994954

    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.

  • October 6, 2010 at 1:26 am

    #1232280

    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

  • October 13, 2010 at 10:15 pm

    #1236613

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

    graphic design[/url]

  • October 14, 2010 at 1:48 am

    #1236663

    hi guys

    thats was my problem to,

    thanks for the post

  • October 14, 2010 at 2:17 am

    #1236668

    thanks watatop

    Regards,
    Tatoba

  • September 7, 2011 at 12:54 pm

    #1378230

    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