28,402
社区成员
发帖
与我相关
我的任务
分享求一段asp连接数据库实例代码
我有一本ASP教程，但是很粗糙，我现在要自己开发一个学生查分系统，包括数据库的录入，查询，删除，更改等，但是ASP连接数据库的实例代码，我是想模仿着做出来，现在我想找一个随便什么系统的ASP数据库连接代码，谢谢了（越详细越好哦）
...全文
请发表友善的回复…
发表回复
若白师妹 2006-06-27
- 打赏
- 举报
万事开头难
FlashK 2006-06-27
- 打赏
- 举报
连接ACCESS
Db = "data/dvbbs7.mdb"
ConnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(db)
连接SQL SERVER
Dim SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName
SqlDatabaseName = "database"
SqlPassword = "sa"
SqlUsername = "sa"
SqlLocalName = "127.0.0.1"
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";"
Db = "data/dvbbs7.mdb"
ConnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(db)
连接SQL SERVER
Dim SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName
SqlDatabaseName = "database"
SqlPassword = "sa"
SqlUsername = "sa"
SqlLocalName = "127.0.0.1"
ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";"
itzhiren 2006-06-27
- 打赏
- 举报
ConnStr="Driver={SQL Server};Server=192.168.xx.xx;DataBase=test;Uid=sa;Pwd=;"
set Conn=server.CreateObject("adodb.connection")
Conn.open ConnStr
set Conn=server.CreateObject("adodb.connection")
Conn.open ConnStr
笨笨兔兔兔兔兔 2006-06-27
- 打赏
- 举报
www.connectionstrings.com
