Connection String - Does not conform to the OLE DB specification

I'm trying to build a connection string to SQL Server 7.0 from ASP.net w/ C#

I get the following error:
Format of the initialization string does not conform to the OLE DB specification. Starting around char[100] in the connection string.

What the heck does this mean? What am I doing wrong.. My connection string is below:

string strConnection = "Provider='Provider=SQLOLEDB; server=XXXXXX.XXXXXXXXXXXXX.COM;'UID=XXXXXX;PWD=XXXXXXX;DATABASE=XXXXXX'";

Is there a way to make good connection strings like a tool or something?

Thanks for your time.
thunkYou can add OleDbConnection control from toolbox to your form in Visual Studio .NET project .
Then go to properties -> ConnectionString and choose <New Connection...>
You will get a tool to make connection string and test connection.

Also, you can use Server Explorer (View -> Server Explorer) on the same way.|||A good reference for connection string information can be found athttp://www.connectionstrings.com.

Terri