sqlsever的连接字符串

Question

<add key="ConnectString" value="server=192.168.2.3; user id=sa; password=aaaa; Database=aaaaa;"></add>
不少呀！你还需要什么信息？？？

Answer 1

oSQLConn.ConnectionString = "Network Library=DBMSSOCN;" & _
                            "Data Source=xxx.xxx.xxx.xxx,1433;" & _
                            "Initial Catalog=mySQLServerDBName;" & _
                            "User ID=myUsername;" & _
                            "Password=myPassword"

Answer 2

<appSettings>
        <add key="ConnectionString" 
value="Data Source=YourDataBaseServerName;database=YourDataBaseName;user id=lgscms;Password=lgscms2002"/> 
    </appSettings>

Answer 3

<add key="strcon" value="Provider=Microsoft.Jet.OLEDB.4.0 ;Data Source=C:\\szforum\\DataBase\\db.mdb" />  oledb
<add key="strcon" value="server=server;database=databasename;user id=id;password=psd;integrated security=false" /> sql