📄 5626.html
字号:
<html>
<head>
<title>how to use RDO access remote access97 database on windows NT server4.0?</title>
</head>
<body bgcolor="#FFFFFF" vlink="#808080">
<center>
<h1>how to use RDO access remote access97 database on windows NT server4.0?</h1>
</center>
<hr size=7 width=75%>
<hr size=7 width=75%><p>
Posted by <a href="mailto:ylj@zhuhaiinfo.net">yuan</a> on September 14, 1998 at 17:06:19:<p>
hi<br> good everybody<br>On NTserver4.0 system:<br>e:\db1.mdb(table:brance,code,address)<br>I have set system dsn:<br>yuan<br>I ask that use RDO how to write program code on local system win95<br>I use vb6.0 enterprise edition <br>I want to add,delete,insert,update,query db1.mdb database <br>my NT server4.0 machine:internaldata<p>program code as follows:<br>Option Explicit<p>Public en As rdoEnvironment<br>Public cn As rdoConnection<p>Private Sub Form_Load()<br>Dim scnct As String<br>dim rs as rdoresultset<br>Set en = rdoEngine.rdoEnvironments(0)<br>scnct = "dsn=yuan;uid=;" & "pwd=;database=db1;"<br>Set cn = en.OpenConnection(dsname:="yuan", _<br>prompt:=rdDriverNoPrompt, ReadOnly:=False, Connect:=scnct)<br>ssql="select * from branch"<br>set rs=cn.openresult(ssql,rdopenkeyset)<br>rs.addnew<p>rs("branch_id")="2"<br>rs("branch_branch_tep")="132421"<br>rs.update<br>While Not cn.EOF<br>rs.MoveNext<br>Wend<br>rs.Close<br>cn.Close<p>End Sub<p><br>i can't connect my server database ,how to do?<p><p>
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 5626-->
<!--top: 5687--><li><a href="5687.html">Connect 参数不对</a> <b>小吴</b> <i>08:03:55 9/16/98</i>
(<!--responses: 5687-->1)
<ul><!--insert: 5687-->
<!--top: 5695--><li><a href="5695.html">there is errors:IM002[microsoft][odbc driver manager] data source name not found and no default driver specified</a> <b>yuan</b> <i>10:00:35 9/16/98</i>
(<!--responses: 5695-->0)
<ul><!--insert: 5695-->
</ul><!--end: 5695-->
</ul><!--end: 5687-->
<!--top: 5630--><li><a href="5630.html">Re: how to use RDO access remote access97 database on windows NT server4.0?</a> <b>LiuXuan</b> <i>19:54:22 9/14/98</i>
(<!--responses: 5630-->1)
<ul><!--insert: 5630-->
<!--top: 5656--><li><a href="5656.html">Sir Who are you? why not to answer for me </a> <b>yuan</b> <i>13:52:30 9/15/98</i>
(<!--responses: 5656-->0)
<ul><!--insert: 5656-->
</ul><!--end: 5656-->
</ul><!--end: 5630-->
</ul><!--end: 5626-->
<br><hr size=7 width=75%><p>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -