Are you using SQL Server 2008 Express? Don't miss the server name syntax Servername\SQLEXPRESS where you substitute Servername with the name of the computer where the SQL Server 2008 Express installation resides.
When to use SQL Native Client?
This connection string (Standard security using SQLNCLI10 OLEDB) can be used for connections to
SQL Server 2000, SQL Server 2005, SQL Server 2008 and SQL Server 7.0.
Start over in the connection string reference index.
You can also get help in the Q&A forums where you can ask your own question.
The kb articles contains how-tos and instructions and you can search for anything if you're not sure were to look.