# Sir Who are you? why not to answer for me

Posted by yuan on September 15, 1998 at 13:52:30:

In Reply to: Re: how to use RDO access remote access97 database on windows NT server4.0? posted by LiuXuan on September 14, 1998 at 19:54:22:

lete,insert,update,query db1.mdb database
: : my NT server4.0 machine:internaldata

: : program code as follows:
: : Option Explicit

: : Public en As rdoEnvironment
: : Public cn As rdoConnection

: : Private Sub Form_Load()
: : Dim scnct As String
: : dim rs as rdoresultset
: : Set en = rdoEngine.rdoEnvironments(0)
: : scnct = "dsn=yuan;uid=;" & "pwd=;database=db1;"
: : Set cn = en.OpenConnection(dsname:="yuan", _
: : prompt:=rdDriverNoPrompt, ReadOnly:=False, Connect:=scnct)
: : ssql="select * from branch"
: : set rs=cn.openresult(ssql,rdopenkeyset)
: : rs.addnew

: : rs("branch_id")="2"
: : rs("branch_branch_tep")="132421"
: : rs.update
: : While Not cn.EOF
: : rs.MoveNext
: : Wend
: : rs.Close
: : cn.Close

: : End Sub

: :
: : i can't connect my server database ,how to do?
: A error in your connect that you must set the
: driver and the server

Follow Ups: