ASP--连接数据库ACCESS/SQL SERVER

VBScript连接数据库示例

原创于 2005-03-15 20:12:00 发布 · 950 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #sqlserver #microsoft #vbscript #database #sql server

<%@ language=vbscript %>
<%
option explicit
on error resume next
dim conn
dim connstring
dim dbf
dbf="database/%29#get123.mdb"
conn=server.createobject("adodb.connection")
connstring="driver={microsoft access driver (*.mdb)};dbq=" & server.mappath(dbf)
'connstring="provider=microsoft.jet.oledb.4.0;data source=" & server.appath(dbf)
'connstring="provider=sqloledb;database=get123;uid=sa;pwd="
'connstring="driver={sqlserver};server=127.0.0.1;database=get123;uid=sa;pwd="
'connstring="dsn=get123;uid=;pwd=;"//用access
'connstring="dsn=get123;uid=;pwd=;database=databaename;"//用sql server
conn.open connstring
%>