28,406
社区成员
发帖
与我相关
我的任务
分享asp 怎么连接sql2008 我试了很多尝试
这是连接字符串，可是都不行，
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
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
...全文
请发表友善的回复…
发表回复
黑心 2009-09-10
- 打赏
- 举报
connstr = "driver={SQL Server};server=local;UID=sa;PWD=123;database=test1;"
