Hi friends,

i did a code to link Sql-server database and to get data but it giveing me error,

"Invalid connection string attribute"

my code is as fallows,

var connection = Server.CreateObject("ADODB.Connection");

connection.Open("Provider=SQLOLEDB;Data Source=SW003\SQLEXPRESS;Persist Security Info =True;Initial Catalog=LinkToManifold;Uid = sa; Pwd = sa;");

var rowset = Server.CreateObject("ADODB.Recordset");

rowset.Open("SELECT [Name] FROM [Events] WHERE [Name]='" + addName + "'",connection);

here SW003 is my servername , LinkToManifold is my database and Events is my table name...

plz tell me where i did mistake....

give me some code to do so...