Can somebody advice me on how I can connect a Visual Studio 2003 application to a SQL Server 2008 Express database. When I run the application using the string below I recieve an error message stating:

An unhandled exception of type 'System.ArgumentException' occurred in system.data.dll

Additional information: Keyword not supported: 'provider'.


Imports

System.Data.SqlClient

Public

Const SQL_CONNECTION_STRING As String = "Provider= SQLNCLI10.1 ;Server=BTG243451\SQLEXPRESS;DataBase=GKS2008; UID=sa; PWD ="