如题 :
web config
这段
<appSettings>
<add key =""value=""/>
<add key ="" value=""/>
<add key ="" value=""/>
</appSettings>
改怎么写? <!-- 这是原来连接oracle
<appSettings>
<add key="wisdbConnG" value="Provider=MSDAORA;Data Source=WISDB.WORLD;User ID=*****;Password=*****;DistribTx=0;PLSQLRSet=1"/>
<add key="missps1Conn" value="Provider=SQLOLEDB;Persist Security Info=True;Data Source=127.0.0.1;Initial Catalog=MR;User ID=sa;Password=123456"/>
<add key="FilePath" value="C:/Inetpub/MTCEIPAP/img/MRPic/"/>
</appSettings>
-->
web config
这段
<appSettings>
<add key =""value=""/>
<add key ="" value=""/>
<add key ="" value=""/>
</appSettings>
改怎么写? <!-- 这是原来连接oracle
<appSettings>
<add key="wisdbConnG" value="Provider=MSDAORA;Data Source=WISDB.WORLD;User ID=*****;Password=*****;DistribTx=0;PLSQLRSet=1"/>
<add key="missps1Conn" value="Provider=SQLOLEDB;Persist Security Info=True;Data Source=127.0.0.1;Initial Catalog=MR;User ID=sa;Password=123456"/>
<add key="FilePath" value="C:/Inetpub/MTCEIPAP/img/MRPic/"/>
</appSettings>
-->
using System;
using System.Data.OleDb;
class Test
{
static void Main()
{
try
{
string strCon = "Provider =Microsoft.Jet.OleDb.4.0 ;";
strCon += @"Data Source=E:\book.mdb";
OleDbConnection myConn = new OleDbConnection(strCon);
myConn.Open();
Console.WriteLine("数据库连接成功!");
myConn.Close();
}
catch
{
Console.WriteLine("连接错误!");
}
}
}
using System;
namespace WealthMIS.database
{
/// <summary>
/// dbConnection 的摘要说明。
/// </summary>
public class dbConnection
{
public dbConnection()
{
//
// TODO: 在此处添加构造函数逻辑
//
}
public static string connection
{
get
{
return "Data Source=wealthMIS.mdb;Jet OLEDB:Engine Type=5;Provider=Microsoft.Jet.OLEDB.4.0;";
}
}
}
}
2. //连接sql数据库
using System;
using System.Data.SqlClient;
class Test
{
static void Main()
{
try
{
string strCon = "user id=sa;password=;";
strCon += @"initial catalog=student1;data source=(local)";
SqlConnection myConn = new SqlConnection(strCon);
myConn.Open();
Console.WriteLine("数据库连接成功!");
myConn.Close();
}
catch
{
Console.WriteLine("连接错误!");
}
}
}
using System;
namespace RentManage.database
{
/// <summary>
/// dbconnection 的摘要说明。
/// </summary>
public class dbconnection
{
public dbconnection()
{
//
// TODO: 在此处添加构造函数逻辑
//
} public static string connection
{
get
{
return "data source=(local);user id=sa;password=;initial catalog=RentManage;integrated security=SSPI;";
}
}
}
}
<appSettings>
<add key =""value=""/>
<add key ="" value=""/>
<add key ="" value=""/> </appSettings>
如题,菜鸟借问了...
<appSettings><add key="wisdbConnG" value="Provider=MSDAORA;Data Source=WISDB.WORLD;User ID=*****;Password=*****;DistribTx=0;PLSQLRSet=1"/>
<add key="missps1Conn" value="Provider=SQLOLEDB;Persist Security Info=True;Data Source=127.0.0.1;Initial Catalog=MR;User ID=sa;Password=123456"/>
<add key="FilePath" value="C:/Inetpub/MTCEIPAP/img/MRPic/"/> </appSettings>
这段该怎么改????
菜鸟求教了
你是本机的话,server那里可以填写 主机名\SQLEXPRESS 。或者localhost等等。。试几下就OK了
<appSettings><add key="wisdbConnG" value="Provider=MSDAORA;Data Source=WISDB.WORLD;User ID=*****;Password=*****;DistribTx=0;PLSQLRSet=1"/>
<add key="missps1Conn" value="Provider=SQLOLEDB;Persist Security Info=True;Data Source=127.0.0.1;Initial Catalog=MR;User ID=sa;Password=123456"/>
<add key="FilePath" value="C:/Inetpub/MTCEIPAP/img/MRPic/"/> </appSettings>
这段该怎么改????
菜鸟求教了
private string connStr = ConfigurationManager.ConnectionStrings["DBConnstr"].ConnectionString;
<appSettings>
<add key="Con" value="server=计算机名\SQLEXPRESS;uid=sa;pwd=sa;database=数据库名"/>
</appSettings>
</configuration>
直接在<appSettings>...</appSettings>后加了这段:
<connectionStrings>
<add name="DBConnstr" connectionString="server=***.***.***.**\SQLExpress;user id=sa; password=sa;database=MR"/> </connectionStrings>
运行的时候提示:无法在Web伺服器上启动侦错。在传送侦错HTTP要求时发生伺服器端错误。
再次请教了
<add key="ConnectionString" value="Data Source=IP或者数据库所在主机名;POOLING=FALSE;database=数据库名;User ID=用户名;Password=你的密码"/>
</appSettings>