c#连数据库出现的问题

Question

Provider=SQLOLEDB;Data Source=wushuo;uid=sa;pwd=1;Initial Catalog=JXC;Connect Timeout=30
即可

Answer 1

"Provider=SQLOLEDB;Data Source=wushuo;DataBase=JXC;Integrated Security=SSPI"

Answer 2

或者这样写ＳＱＬ语句也行：
string strSQL = "use JXC select * from TabCGD";
或
string strSQL = "select * from [JXC].[dbo].[TabCGD]";
这就用不着在连接串中指定数据库。甚至可以跨数据库连接：select a.name, b.department
from [JXC].[dbo].[TabCGD] a, [JXD].[dbo].[TabDGD] b
where a.id = b.id

Answer 3

Initial Catalog = JXC 或者 DataBase = JXC

Answer 4

Provider=SQLOLEDB;Data Source=wushuo;uid=yourusername;pwd=yourpassword;Initial Catalog=JXC;Connect Timeout=30

Answer 5

Provider=SQLOLEDB;server=wushuo;uid=yourusername;pwd=yourpassword;database=JXC;Connect Timeout=30