📄 5879.html
字号:
<html>
<head>
<title>Re: Connect String incorrect(there is also the same error.</title>
</head>
<body bgcolor="#FFFFFF" vlink="#808080">
<center>
<h1>Re: Connect String incorrect(there is also the same error.</h1>
</center>
<hr size=7 width=75%>
<hr size=7 width=75%><p>
Posted by <a href="mailto:ylj@zhuhaiinfo.net">wen</a> on September 22, 1998 at 08:45:26:<p>
In Reply to: <a href="5876.html">Connect String incorrect</a> posted by 小吴 on September 22, 1998 at 08:23:40:<p>
<br>: 你的 Connect String 格式是错的，你忘了指定数据库位置。<br>: 把 scnct 改为下行再试一次看看。<br>: scnct = "DBQ=c:\winnt\db1.mdb;Driver=C:\WINNT\System32\odbcjt32.dll;DriverID=25;FIL=MS Access;UID=;PWD=;"<br> <br> program as follows:<br> <br>Public en As rdoEnvironment<br>Public cn As rdoConnection<br>Private Sub Form_Load()<br>Dim scnct As String<br>Dim rs As rdoResultset<br>Dim ssql As String<p>Set en = rdoEngine.rdoEnvironments(0)<br>scnct = "dbq=c:\winnt\order.mdb;Driver=C:\WINNT\System32\odbcjt32.dll;" _<br>& "DriverID=25;FIL=MS Access;UID=;PWD=;"<br>Set cn = en.OpenConnection(dsname:="yuan", prompt:=rdDriverNoPrompt, ReadOnly:=False, Connect:=scnct)<br>ssql = "select * from branch"<br>Set rs = cn.OpenResultset(ssql, rdOpenKeyset, rdConcurRowVer)<br>rs.Edit<br>rs![branch_id] = "2"<br>rs.Update<br>While Not cn.EOF<br>rs.MoveNext<br>Wend<br>rs.Close<br>cn.Close<br>End Sub<p> 扂眒忒雄婓NT sever4.0奻腔讽秶醱衔odbc笢扢离剩system dsn:yuan,select database name :c:\winnt\order.mdb<br>but,there is also the same error,why?<br>please Mr Wu help me?<p>
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 5879-->
<!--top: 5912--><li><a href="5912.html">Sorry, this works!</a> <b>小吴</b> <i>08:01:28 9/23/98</i>
(<!--responses: 5912-->1)
<ul><!--insert: 5912-->
<!--top: 5913--><li><a href="5913.html">Re: Sorry, this works!(there is the same error)</a> <b>wen</b> <i>08:39:32 9/23/98</i>
(<!--responses: 5913-->0)
<ul><!--insert: 5913-->
</ul><!--end: 5913-->
</ul><!--end: 5912-->
</ul><!--end: 5879-->
<br><hr size=7 width=75%><p>
</body></html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -