this is ASP.NET, not ASP"Provider=SQLOLEDB;User ID=YourSQLLoginID;Password=YourSQLLoginPassword;Initial Catalog=YourDBName; Data Source=YourServerNameOrUselocalhost;"
"server = local host;initial catalog = master;user id =sa;password =sa" 其中master,sa,sa是我假设的数据库名称,用户名和密码
to saucer(思归, .NET MVP)asp.net 也可以用这个连吧?<% dim conn,rs conn=server.createobject("ADODB.connection") rs=server.createobject("ADODB.recordset") conn.open("DSN=CAALISC;") %>
<% dim conn,rs conn=server.createobject("ADODB.connection") rs=server.createobject("ADODB.recordset") conn.open("DSN=CAALISC;") %> 在asp.net里面这么用不好,还是用直接的sql命名空间来做吧 sqlConnection.ConnectionString="server=localhost;database=test;uid=sa;pwd=123";
其中master,sa,sa是我假设的数据库名称,用户名和密码
dim conn,rs
conn=server.createobject("ADODB.connection")
rs=server.createobject("ADODB.recordset")
conn.open("DSN=CAALISC;")
%>
dim conn,rs
conn=server.createobject("ADODB.connection")
rs=server.createobject("ADODB.recordset")
conn.open("DSN=CAALISC;")
%>
在asp.net里面这么用不好,还是用直接的sql命名空间来做吧
sqlConnection.ConnectionString="server=localhost;database=test;uid=sa;pwd=123";