How To Distribute RDS Client with Visual Basic Setup Wizard

MORE INFORMATION

Step One

1. Start a new Standard EXE project. Form1 is created by default.
2. From the Project menu, select References, and then select Microsoft Remote Data Services Library.
3. Add two CommandButtons to Form1, named Command1, and Command2 by default.
4. Paste the following code into the General Declarations section of Form1:
   
   Note You must change Username=<username> and PWD=<strong password> to the correct values before you run this code. Make sure that Username has the appropriate permissions to perform this operation on the database.

      Private Sub Command1_Click()
      'DataControl
      MousePointer = vbArrowHourglass
      Dim dc As New RDS.DataControl
      dc.Connect = "dsn=pubs;Username=<username>;PWD=<strong password>;"  'dsn should be a system dsn
      dc.SQL = "select * from authors"
      dc.Server = "http://ServerXXXX"
      dc.ExecuteOptions = adcExecAsync
      dc.Refresh
   
      While dc.ReadyState = 2
      DoEvents 'user has control during async query
      Wend
      MousePointer = vbDefault
      MsgBox dc.Recordset.Fields(0).Value
      End Sub
   
      Private Sub Command2_Click()
      'DataSpace, DataFactory
      MousePointer = vbArrowHourglass
      Dim ds As New RDS.DataSpace
      Dim df, rs
      Set df = ds.CreateObject("RDSServer.DataFactory",
      "http://ServerXXXX")
      Set rs = df.Query("dsn=pubs;Username=<username>;PWD=<strong password>;", "select * from authors")
      MsgBox rs.Fields(0).Value
      MousePointer = vbDefault
      End Sub
   					

5. Change the Server, SQL, and Connect strings to match actual servers you will be testing against.
6. Save the project.
7. Run the project and test its functionality against your server to verify that it works. If it does not work at this time, do not continue to Step Two below until you have figured out what is wrong. The RDS documentation, Readme.txt, and other Microsoft Knowledge Base articles will help you debug RDS configuration problems.

Step Two

1. Optionally, include MDAC_TYP.EXE in your Setup program. See the REFERENCES section of this article for more information.
2. Whether you include MDAC_TYP.EXE in your Setup program or not, you do not need to include separate Remote Data components in your Setup program. So, when running the Application Setup Wizard, remove the reference to Microsoft Remote Data Services Library (msadco.dll). This file and all other RDS files are included in MDAC_TYP.EXE.
3. On a computer that has never had any RDS files installed, test the functionality of your example program by running the Setup.exe file that the Application Setup Wizard created. Be sure that DCOM is installed prior to installing MDAC.