Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Getting error.....Keyword not supported: 'provider' Expand / Collapse
Author
Message
Posted Wednesday, May 13, 2009 4:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 1, 2013 10:48 AM
Points: 7, Visits: 23
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.
Post #716534
Posted Wednesday, May 13, 2009 4:30 PM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:22 PM
Points: 20,680, Visits: 32,279
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=*****;'




Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #716541
Posted Wednesday, May 13, 2009 9:07 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 1, 2013 10:48 AM
Points: 7, Visits: 23
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;'.



Post #716614
Posted Thursday, May 14, 2009 7:08 AM


SSC-Insane

SSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-InsaneSSC-Insane

Group: General Forum Members
Last Login: Today @ 7:22 PM
Points: 20,680, Visits: 32,279
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?



Lynn Pettis

For better assistance in answering your questions, click here
For tips to get better help with Performance Problems, click here
For Running Totals and its variations, click here or when working with partitioned tables
For more about Tally Tables, click here
For more about Cross Tabs and Pivots, click here and here
Managing Transaction Logs

SQL Musings from the Desert Fountain Valley SQL (My Mirror Blog)
Post #716891
Posted Thursday, May 14, 2009 4:01 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, July 1, 2013 10:48 AM
Points: 7, Visits: 23
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.

Post #717461
Posted Wednesday, October 6, 2010 1:26 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, February 1, 2012 9:18 PM
Points: 22, Visits: 42
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
Post #999009
Posted Wednesday, October 13, 2010 10:15 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, October 13, 2010 10:11 PM
Points: 1, Visits: 0
i have the same problem here..but i just reinstall the sql and then everything is fine

graphic design
Post #1004106
Posted Thursday, October 14, 2010 1:48 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, October 14, 2010 1:48 AM
Points: 1, Visits: 20
hi guys

thats was my problem to,
thanks for the post
Post #1004163
Posted Thursday, October 14, 2010 2:17 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, February 1, 2012 9:18 PM
Points: 22, Visits: 42
thanks watatop

Regards,
Tatoba
Post #1004169
Posted Wednesday, September 7, 2011 12:54 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, February 7, 2012 10:14 AM
Points: 27, Visits: 30
I face a similar issue and got it fixed.

The below link was useful

http://a2zmenu.com/Blogs/SQL/Keyword-not-supported-provider.aspx
Post #1171363
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse