asp 怎么连接sql2008 我试了很多尝试

[abcwps]

这是连接字符串，可是都不行，

sql版本: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

系统xp3

PROVIDER=SQLOLEDB.1;Data Source='127.0.0.1\SQL2008';Initial Catalog=MyData;Persist Security Info=True;User ID=sa;Password=123456;Connect Timeout=30

Provider=SQLNCLI10;Server=127.0.0.1;Database=test1;Uid=sa; Pwd=123


Driver={SQL Server};SERVER='127.0.0.1\YSERVER\SQLEXPRESS';UID=sa;PWD=123;DATABASE=test1

[黑心]

connstr = "driver={SQL Server};server=local;UID=sa;PWD=123;database=test1;"