VC如何连接网页 VC如何连接网页 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 1) MS Access数据库连接 用DSN连接并且没有用户名和密码: <% set conn = Server.CreateObject( "ADODB.Connection ") conn.open "YourDSNName " %> 2) 用DSN连接并且有用户名和密码: <% set conn = Server.CreateObject( "ADODB.Connection ") conn.open "YourDSNName ", "username ", "password " %> 3) 用实际的数据库绝对路径连接: <% Set conn = Server.CreateObject( "ADODB.Connection ") Strconn= "DRIVER={Microsoft Access Driver (*.mdb)}; " Strconn=Strconn & "DBQ=e:\yanhang\database.mdb " conn.Open Strconn %> 4) 用实际的数据库相对路径连接: <% Set conn = Server.CreateObject( "ADODB.Connection ") Strconn= "DRIVER={Microsoft Access Driver (*.mdb)}; " Strconn=Strconn & "DBQ= " & Server.MapPath( "/database/yanhang.mdb ") conn.Open Strconn %> 5) MS SQL Server数据库连接 用DSN连接: <% set conn = Server.CreateObject( "ADODB.Connection ") conn.open "DSN=MyDSN;UID=user;PWD=password;DATABASE=databasename " %> 6) 不用DSN连接: <% Set conn = Server.CreateObject( "ADODB.Connection ") DSNtemp= "DRIVER={SQL Server};SERVER=ServerName;UID=USER;PWD=password;DATABASE=databasename " conn.open DSNtemp %> 7) FoxPro数据库连接 <% Set Conn = Server.CreateObject( "ADODB.connection ") ConnStr= "Driver=Microsoft Visual Foxpro Driver; UID=userID;SourceType=DBC;SourceDB=C:\yanhang\database.dbc " Conn.Open ConnStr %> 8) Oracle数据库连接: <% set conn=server.createobject( "adodb.connection ") conn.cursorlocation=adUseClient DSNTemp= "Provider=MSDAORA.1;Password=xxxxx;User ID=yanhang;Data Source=xxx.world " conn.open DSNtemp %> 9) Paradox数据库连接: <% set conn=server.createobject( "adodb.connection ") conn.cursorlocation=adUseClient DSNTemp= "driver={Microsoft Paradox Driver (*.db)};DriverID=538;Fil=Paradox 5.X;DefaultDir=c:\dbpath\;Dbq=c:\dbpath\;CollatingSequence=ASCII; " conn.open DSNtemp %> 10) Sybase数据库连接: <% set conn=server.createobject( "adodb.connection ") conn.cursorlocation=adUseClient DSNTemp= "Driver={SYBASE SYSTEM 11};Srvr=myServerName;Uid=myUsername;Pwd=myPassword; " conn.open DSNtemp %> 11) Text数据库连接: <% set conn=server.createobject( "adodb.connection ") conn.cursorlocation=adUseClient DSNTemp= "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\somepath\;Extensions=asc,csv,tab,txt;Persist Security Info=False " conn.open DSNtemp '调用 test.csv 的文件 Set rs=server.createobject( "adodb.recordset ") rs.open "select * from test.csv ",conn,1,3 %> 原始套接字CHttpConnection。。多得很,网上代码也是多得很 对话框:CDHtlmDialog视图:CHtmlView 就是涉及到CHtmlView 类,你在msdn中看看方法。 读取文件前256个位元的资料,并用十六进制显示 工程设不了断点怎么解决? SDI的项目,手动创建了一个视图后这个视图无法处理消息。 ScreenToClient? 请教 opengl上如何把文本绘上去呀 ? 请教ADO高手~~ ListCtrl 的使用 在WINDOWS 2000/NT下如何用VC++实现对端口的操作 本人想购买一台打印机打印编程文档资料,不知哪一款打印机较为适合又实惠。 vc++ 6.0问题 MoveWindow坐标设定的问题 新人问题,关于连接字符串
用DSN连接并且没有用户名和密码:
<%
set conn = Server.CreateObject( "ADODB.Connection ")
conn.open "YourDSNName "
%> 2) 用DSN连接并且有用户名和密码:
<%
set conn = Server.CreateObject( "ADODB.Connection ")
conn.open "YourDSNName ", "username ", "password "
%> 3) 用实际的数据库绝对路径连接:
<%
Set conn = Server.CreateObject( "ADODB.Connection ")
Strconn= "DRIVER={Microsoft Access Driver (*.mdb)}; "
Strconn=Strconn & "DBQ=e:\yanhang\database.mdb "
conn.Open Strconn
%> 4) 用实际的数据库相对路径连接:
<%
Set conn = Server.CreateObject( "ADODB.Connection ")
Strconn= "DRIVER={Microsoft Access Driver (*.mdb)}; "
Strconn=Strconn & "DBQ= " & Server.MapPath( "/database/yanhang.mdb ")
conn.Open Strconn
%>
5) MS SQL Server数据库连接
用DSN连接:
<%
set conn = Server.CreateObject( "ADODB.Connection ")
conn.open "DSN=MyDSN;UID=user;PWD=password;DATABASE=databasename "
%> 6) 不用DSN连接:
<%
Set conn = Server.CreateObject( "ADODB.Connection ")
DSNtemp= "DRIVER={SQL Server};SERVER=ServerName;UID=USER;PWD=password;DATABASE=databasename "
conn.open DSNtemp
%>
7) FoxPro数据库连接
<%
Set Conn = Server.CreateObject( "ADODB.connection ")
ConnStr= "Driver=Microsoft Visual Foxpro Driver; UID=userID;SourceType=DBC;SourceDB=C:\yanhang\database.dbc "
Conn.Open ConnStr
%>
8) Oracle数据库连接:
<%
set conn=server.createobject( "adodb.connection ")
conn.cursorlocation=adUseClient
DSNTemp= "Provider=MSDAORA.1;Password=xxxxx;User ID=yanhang;Data Source=xxx.world "
conn.open DSNtemp
%> 9) Paradox数据库连接:
<%
set conn=server.createobject( "adodb.connection ")
conn.cursorlocation=adUseClient
DSNTemp= "driver={Microsoft Paradox Driver (*.db)};DriverID=538;Fil=Paradox 5.X;DefaultDir=c:\dbpath\;Dbq=c:\dbpath\;CollatingSequence=ASCII; "
conn.open DSNtemp
%> 10) Sybase数据库连接:
<%
set conn=server.createobject( "adodb.connection ")
conn.cursorlocation=adUseClient
DSNTemp= "Driver={SYBASE SYSTEM 11};Srvr=myServerName;Uid=myUsername;Pwd=myPassword; "
conn.open DSNtemp
%> 11) Text数据库连接:
<%
set conn=server.createobject( "adodb.connection ")
conn.cursorlocation=adUseClient
DSNTemp= "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=c:\somepath\;Extensions=asc,csv,tab,txt;Persist Security Info=False "
conn.open DSNtemp
'调用 test.csv 的文件
Set rs=server.createobject( "adodb.recordset ")
rs.open "select * from test.csv ",conn,1,3
%>
CHttpConnection
。。多得很,网上代码也是多得很
视图:CHtmlView