Keyword not supported: 'provider'

Topics: Developer Discussion, Request
Jan 22, 2008 at 5:45 PM
Edited Jan 22, 2008 at 5:49 PM
Installed the files on WebHost4Life.
(version: Club starter Kit 2.0 Release 1911 Source: source code, 4044K, uploaded May 11 2007 - 3760 downloads )
Ran the scripts for SQL.
Changed web.config for my connection.

I now get the following error:

Keyword not supported: 'provider'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.ArgumentException: Keyword not supported: 'provider'.
Source Error:

Line 59: end if
Line 60:
Line 61: throw
Line 62:
Line 63: end try

Source File: c:\hosting\webhost4life\member\membername\tbp\UserControls\WebContent.ascx Line: 61
Jan 22, 2008 at 6:12 PM
OK - narrowing this down...

My connection string provided by WebHost4Life for my SQL server was as follows:
"Provider=SQLOLEDB;
Data Source=mssqlxxxx.mysite4now.com;
User Id=MSSQLUserName;
Password=MSSQLPassword;
Initial catalog=MSSQLName;"

Provider is incorrect.

Anyone have any clues as how to word the connection string for a SQL2k server on WebHost4Life account?