May 13, 2009 at 4:20 pm
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
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
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
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
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
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
October 14, 2010 at 1:48 am
hi guys
thats was my problem to,
thanks for the post
October 14, 2010 at 2:17 am
thanks watatop
Regards,
Tatoba
September 7, 2011 at 12:54 pm
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