web.config中配置数据库问题 <add name="aaSQLite" connectionString="Data Source=[DATAPATH]App_Data\aa.db3;"/>在access中不能打开,sql中也不行,这是什么数据库啊,怎么没有见过啊,如何导入sql 或者access中! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 看它程序中用什么数据提供程序连接数据库,不能光看数据库文件名后缀,我的项目中如果用access数据库的话,一般都会把数据库后缀改为dll以防止别人打开或下载===================================================ASP.NET WebForm和ASP.NET MVC分页最终解决之道 <add name="dbSQLite" connectionString="Data Source=[DATAPATH]App_Data\aa.db3;"/>app_Data文件夹有个aa.db3就是不知道怎么打开,看到里面的字段,扩展名.db3好像是SQLLite数据库,就是不知道转换成sql SQLiteConnection,SQLiteCommand用到了这些 常用的数据库链接串 <!-- Access 2007: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False; Access 2000: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=; --> <add name="Access" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\myDatabase.mdb;User Id=admin;Password=;" /> <!--SQL Server 数据库连接方式 SQL Server 2008: Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword; SQL Server 2005: Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword; SQL Server 2000: Provider=SQLOLEDB;Data Source=myservername;Initial Catalog=mydemodb;User Id=myusername;Password=mypasswd; Trusted : Provider=SQLOLEDB;Data Source=myservername;Initial Catalog=mydemodb;Integrated Security=SSPI; --> <add name="SqlServer" connectionString="Provider=SQLOLEDB;Data Source=myservername;Initial Catalog=mydemodb;User Id=myusername;Password=mypasswd; " /> <!-- Oracle数据库连接方式 ms Provider : Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword; Oracle Provider: Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword; --> <add name="Oracle" connectionString="Provider=OraOLEDB.Oracle;Data Source=Db.X.Com;User ID=UID;Password=PWD" /> <!--DB2数据库连接方式 APPC 方式 : Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=myUsername;Password=myPassword; IBM Provider: Provider=IBMDADB2;Database=myDataBase;Hostname=myServerAddress;Protocol=TCPIP; Port=50000;Uid=myUsername;Pwd=myPassword; --> http://blog.csdn.net/fengyarongaa/archive/2011/04/23/6346867.aspx 先判断你的数据库类型然后在写链接字符串写在web.config中后台获取的时候用configurationManager.connectionString["SYXTConnectionString"].ToString()Web.config中加入<connectionStrings> <add name="SYXTConnectionString" connectionString="Data Source=LEIKE;Initial Catalog=SYXT;User ID=sa;Password=sa" providerName="System.Data.SqlClient" /> </connectionStrings> 服务器问题,有时候CPU爆满,是什么问题呢? 求一个后台更新HTML代码里input的值的方法 递归调用 上传到网站上后,JS文件无法执行? 关于WEB程序每个页面权限的管理 为何变量的值SmlImgUrl永远是datalist绑定的最后一个label的值? 如何获取datagrid页面中的文本框,以便赋值? 用什么来代替IIS? objDoc = MyWord.Documents.Open(Filename)出錯,哪 位幫忙看看,謝謝 紧急求救!在Visual studio.net 2003中不能新建项目! 请问C++的struct怎么转换成C#的。 根据地理位置获取经纬度
ASP.NET WebForm和ASP.NET MVC分页最终解决之道
常用的数据库链接串
<!--
Access 2007: Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccess2007file.accdb;Persist Security Info=False;
Access 2000: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\mydatabase.mdb;User Id=admin;Password=;
-->
<add name="Access" connectionString="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|\myDatabase.mdb;User Id=admin;Password=;" />
<!--SQL Server 数据库连接方式
SQL Server 2008: Provider=SQLNCLI10;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;
SQL Server 2005: Provider=SQLNCLI;Server=myServerAddress;Database=myDataBase;Uid=myUsername; Pwd=myPassword;
SQL Server 2000: Provider=SQLOLEDB;Data Source=myservername;Initial Catalog=mydemodb;User Id=myusername;Password=mypasswd;
Trusted : Provider=SQLOLEDB;Data Source=myservername;Initial Catalog=mydemodb;Integrated Security=SSPI;
-->
<add name="SqlServer" connectionString="Provider=SQLOLEDB;Data Source=myservername;Initial Catalog=mydemodb;User Id=myusername;Password=mypasswd; " />
<!-- Oracle数据库连接方式
ms Provider : Provider=msdaora;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
Oracle Provider: Provider=OraOLEDB.Oracle;Data Source=MyOracleDB;User Id=myUsername;Password=myPassword;
-->
<add name="Oracle" connectionString="Provider=OraOLEDB.Oracle;Data Source=Db.X.Com;User ID=UID;Password=PWD" />
<!--DB2数据库连接方式
APPC 方式 : Provider=DB2OLEDB;APPC Local LU Alias=MyAlias;APPC Remote LU Alias=MyRemote;Initial Catalog=MyCtlg;Package Collection=MyPkgCol;Default Schema=Schema;User ID=myUsername;Password=myPassword;
IBM Provider: Provider=IBMDADB2;Database=myDataBase;Hostname=myServerAddress;Protocol=TCPIP; Port=50000;Uid=myUsername;Pwd=myPassword;
--> http://blog.csdn.net/fengyarongaa/archive/2011/04/23/6346867.aspx
<connectionStrings> <add name="SYXTConnectionString" connectionString="Data Source=LEIKE;Initial Catalog=SYXT;User ID=sa;Password=sa" providerName="System.Data.SqlClient" /> </connectionStrings>