Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 6 Visual Basic 6 > VB Components
|
VB Components Issues specific to components in VB.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the VB Components section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old November 4th, 2004, 06:27 AM
Sri Sri is offline
Registered User
 
Join Date: Nov 2004
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Facing problems using RDS in VB - Urgent

Hi All,

  I am using Remote data Service (RDS) for connecting my MSAccess database which in web.When ever i try do connect my database its show
"Internet Server Error" - why is it so?

Another thing , is MICROSOFT still supports RDS since its outdated one?

Please help me..its urgent


my code goes this way..

Set rdc = New RDS.DataControl
rdc.Server = "http://myserver/"
rdc.SQL = "select * from Author"
rdc.ExecuteOptions = adcExecAsync

rdc.Connect = "Provider=sqloledb;" & _
                     "Data Source=http://myserver/db/Nwind.mdb;" & _
                     "User Id=username;" & _
                     "Password=password"


rdc.Refresh

While rdc.ReadyState = adcReadyStateLoaded
  DoEvents
Wend
'MsgBox rdc.Recordset
'Do Until rdc.Recordset.EOF
  With rdc.Recordset
      List1.AddItem .Fields("Author")
     .MoveNext
  End With


God’s ways are more than man’s arithmetic - The Mahatma





Similar Threads
Thread Thread Starter Forum Replies Last Post
facing problems C#.net remoting,please help me gourab C# 2005 0 June 30th, 2007 02:05 AM
Urgent!! need help...Logout problems riki_gill ASP.NET 1.x and 2.0 Application Design 0 October 20th, 2006 09:21 AM
URGENT Problems in Access 2000 lizhaskin VB Databases Basics 1 February 10th, 2006 08:52 AM
Urgent rec navigation problems shelbygt22 Access VBA 1 March 18th, 2005 12:59 PM
Facing Problems with text in a Where Clause mhosneddine Access 2 October 26th, 2003 04:10 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.