技术笔记
一名已转行的程序员ACCESS数据库连接代码(CONN.ASP文件)
2017-02-19 / 代码笔记 / 693 次围观 / 0 次吐槽ACCESS数据库接接代码:
dim db,Conn,ConnStr db="您的ACCESS数据库路径" set conn=Server.CreateObject("ADODB.Connection") ConnStr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(db) conn.open ConnStr
MS SQL Server数据库接接代码:
dim SqlDatabaseName,SqlPassword,SqlUsername,SqlLocalName,Conn,ConnStr SqlDatabaseName="SQL数据库名称" SqlPassword="SQL数据库登密码" SqlUsername="SQL数据库登陆用户名" SqlLocalName="SQL服务器IP地址" set conn=Server.CreateObject("ADODB.Connection") ConnStr = "Provider = Sqloledb; User ID = " & SqlUsername & "; Password = " & SqlPassword & "; Initial Catalog = " & SqlDatabaseName & "; Data Source = " & SqlLocalName & ";" conn.open ConnStr
或者ConnStr也可以用:
ConnStr = "driver={SQL SERVER};database=" & SqlDatabaseName & "; uid=" & SqlUsername & "; pwd=" & SqlPassword & "; server=" & SqlLocalName & ""
完整conn.asp代码
<% response.buffer=true '启用缓冲处理 'dim conn,db 'dim connstr db="/data/db1.mdb"'数据库链接路径 connstr = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source = " & Server.MapPath(db) 'connstr="DBQ="+server.mappath(""&db&"")+";DefaultDir=;DRIVER={Microsoft Access Driver (*.mdb)};" set conn=server.createobject("ADODB.CONNECTION") conn.open connstr If Err Then err.Clear Set Conn = Nothing Response.Write "数据库连接出错,请检查数据库连接文件中的数据库参数设置。" Response.End End If %>
推荐您阅读更多有关于“”的文章
Powered By Z-BlogPHP
Copyright 技术笔记 Rights Reserved.
额 本文暂时没人评论 来添加一个吧
发表评论