VB6 IIS-Configuration for RoundTrip-Debugging of http-RPCs

[PhuongNam]

In the next Demo we will "get serious" (based on these Rs-based Transports) - and address a serverside DB...

Olaf

this topic is great ... this post too can you please continue ???
Writing a Demo DB for the server ???

[Schmidt]

this topic is great ... this post too can you please continue ???
Writing a Demo DB for the server ???

Yeah, sorry... the "RPC-mechanism" as introduced here, was later continued in several (quite long and detailed) other threads -
in the normal VB-Forum (where ADO-based DB-access - and the transfer of selected Rs was explained):
https://www.vbforums.com/showthread....nection-string
(from posting #23 onwards, post#58 containing code for a modADODB.bas, which can be added into the ServerLib-Dll project)

Some additional stuff was coming up later in this thread:
https://www.vbforums.com/showthread....rver-side-code

Before diving into these threads though, one would be well-advised, to make the code in this thread work first, fully understanding what it does -
(including setting your own break-points in the serverside Dll-Class-Code of the ProjectGroup which was used here).

HTH

Olaf

[PhuongNam]

Yeah, sorry... the "RPC-mechanism" as introduced here, was later continued in several (quite long and detailed) other threads -
in the normal VB-Forum (where ADO-based DB-access - and the transfer of selected Rs was explained):
https://www.vbforums.com/showthread....nection-string
(from posting #23 onwards, post#52 containing code for a modADODB.bas, which can be added into the ServerLib-Dll project)

Some additional stuff was coming up later in this thread:
https://www.vbforums.com/showthread....rver-side-code

Before diving into these threads though, one would be well-advised, to make the code in this thread work first, fully understanding what it does -
(including setting your own break-points in the serverside Dll-Class-Code of the ProjectGroup which was used here).

HTH

Olaf

Thank you for agreeing with your suggestion
1 / I have configured iis.msc as instructed in lesson 1, finished

2 / modADODB.bas is in song # 58, not song # 52


3 / I read and re-read the 2 links you gave, basically ADOBD reads and writes data to the DB, then I'm fine ... and "serialization" (to and from ByteArrays) as you described, I I have never used it before ... if you instruct me, I will learn quickly because basically ADOBD I use ok

4/2 Link you only see many times if there is 1 Demo, I will understand that this road does not have a Demo, but only 2 people exchange with each other so I am a bit difficult to figure out how.

We hope you guide me to approach like this topic

[Schmidt]

I will understand that this road does not have a Demo, but only 2 people exchange with each other so I am a bit difficult to figure out how.

I think, the amount of Demos (even in this very CodeBank-thread here) should be enough,
to figure things out on your own.

For example, I've posted an RPC_TestWithParams.zip in post #7 in this thread here.

Please make this work for you fully first:
- by starting the Project-Group
- and then by setting a breakpoint in cHandler.cls ... GetServerTime()-method (of the ServerLib-Project which is part of the VB6-Group)

If you have managed that, you are already set-up for "everything else" (including "talking to real, serverside DBs via ADO).
Just tell me, that you indeed end up in a breakpoint in that project -
and let's take "things from there".

I'm hesitant to write "special DB-Demos" for this approach, because it is already generic enough
(using ADO-Rs as transport-vehicles for any kind of Incoming and Outgoing Parameters already).

You have to fully understand, how to work with RsIn and RsOut:
- using them for "normal Parameter-transport" ...

From there, it is not that large a step, to write your own Sub-Routines in cHandler.cls,
which for example could look as simple like (after hanging the modADOD-module into the ServerLib-Project):

Public Sub GetServerRs()
  If Cnn Is Nothing Then Set Cnn = modADODB.OpenCnn(...) 'set a class-private Cnn-Variable, if necessary
  
  Dim SQL As String: SQL = RsIn(1).Value
  Set RsOut = modADODB.GetRs(Cnn, SQL)
End Sub

... to retrieve an ADO-Rs from a priorily opened Cnn

Olaf

[PhuongNam]

I think, the amount of Demos (even in this very CodeBank-thread here) should be enough,
to figure things out on your own.

For example, I've posted an RPC_TestWithParams.zip in post #7 in this thread here.

Please make this work for you fully first:
- by starting the Project-Group
- and then by setting a breakpoint in cHandler.cls ... GetServerTime()-method (of the ServerLib-Project which is part of the VB6-Group)

If you have managed that, you are already set-up for "everything else" (including "talking to real, serverside DBs via ADO).
Just tell me, that you indeed end up in a breakpoint in that project -
and let's take "things from there".

I'm hesitant to write "special DB-Demos" for this approach, because it is already generic enough
(using ADO-Rs as transport-vehicles for any kind of Incoming and Outgoing Parameters already).

You have to fully understand, how to work with RsIn and RsOut:
- using them for "normal Parameter-transport" ...

From there, it is not that large a step, to write your own Sub-Routines in cHandler.cls,
which for example could look as simple like (after hanging the modADOD-module into the ServerLib-Project):

Public Sub GetServerRs()
  If Cnn Is Nothing Then Set Cnn = modADODB.OpenCnn(...) 'set a class-private Cnn-Variable, if necessary
  
  Dim SQL As String: SQL = RsIn(1).Value
  Set RsOut = modADODB.GetRs(Cnn, SQL)
End Sub

... to retrieve an ADO-Rs from a priorily opened Cnn

Olaf

Thank you very much ... I still have not figured out how to use the code in the Demos that you put up here ... if I keep asking stupid questions over and over, it just makes you angry. only ... so for the past few days I still reread your article and think

You can show me only 2 most specific examples that I can imagine and use

For example: C: \ Data \ Database.mdb in File has the table named: Persons

1 / So how can I use ADODB to get the data with the table named: Persons?!

2 / How did I get the data of another Data.mdb and save it to C: \ Data \ Database.mdb?!

I hope you show me two detailed sections that are how to get data and save data to Database.mdb, so I can visualize and apply the code to share it right away