open database over the internet

Posted on 2002-05-22
Last Modified: 2012-08-13
i want to know in simple description how to open an access database located in a server using RDS just how to open it

for example
database name :  data.mdb
server :

user name for the server : ashraf
password for the server  : 123456

and the database itself is not protected by password

another thing how i know if the server support RDS or not

Question by:ashraf_t
  • 6
  • 5
  • 2
  • +2

Expert Comment

ID: 7028181
How about this example:
<!-- #include file='' -->
   Dim cn
   Dim rs
   Set cn = Server.CreateObject("ADODB.Connection")
   cn.Open "Provider=SQLOLEDB;Data Source=<name of your SQL
Server;Initial Catalog=pubs;User Id=sa"
   set rs = Server.CreateObject("ADODB.Recordset")
   rs.Open "Select * from Authors",cn
   'Instantiate an ADO Stream object to persist the recordset in
   'XML format.

   Dim objStream
   Set objStream = Server.CreateObject("ADODB.Stream")
   objStream.Mode = 3   ' Read/Write mode

   'Persist the recordset in XML format to the ADO stream object.
   rs.Save objStream, adPersistXML

   'Reposition stream pointer to the beginning of the stream, and
   'return its contents to the client using the Write method
   'of the ASP Response object.

   objStream.Position = 0
   Response.Write objStream.ReadText
   Set rs = Nothing

Author Comment

ID: 7028192
please use the example data and i need it in VB code

Expert Comment

ID: 7028503
if you want to connect to a database in a server you will have to use somthing like ASP or JAVA SERVLETS. you cant use VBScript.
LVL 69

Expert Comment

by:Éric Moreau
ID: 7028538
I have never seen someone being able to connect directly a VB client application to an Access database hosted on a web site.

Using SQL server is pretty easy because there is an engine running on the host.
LVL 69

Expert Comment

by:Éric Moreau
ID: 7028540
If you can think about moving to .Net, you could create a Web Service that returns a dataset to your VB client application.

Expert Comment

ID: 7029048
A solution is not possible with this kind of servers. they are giving you only html browsing permissions on your files. to access server side files you need server side execution permissions or you have to use a server side technologies like asp/php/jsp...servlets/isapi or something like that. So it is better to switch over to these technologies. If you are looking for a free asp hosting service you can try to host asp pages. put your data file there. create an asp file to communicate with your database. and access that asp file from your VB application.
LVL 69

Expert Comment

by:Éric Moreau
ID: 7029317
welcome to EE unni_bcanti.

Take some time reading

After reading this, you will discover that what you posted is nothing more than a comment. The etiquette suggests to always post a comment. The asker has a feature to accept any of the comments as THE answer.

Author Comment

ID: 7029333
first i donot talk about VBscript iam talking about normal VB interprise and if i cannot connect to an access database over the internet using VB so what the need for RDS (Remote Data Service) which shipped with VB
another thing if i want to build SQL server database what application i can use

last thing thanx for unni_bcanti  for the web site he posted but this is not the answered i wait
How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

LVL 69

Expert Comment

by:Éric Moreau
ID: 7029486
>>so what the need for RDS (Remote Data Service) which shipped with VB

To be used with DHTML and IIS applications templates (which are web clients).

>>another thing if i want to build SQL server database what application i can use

You can use Enterprise Manager which is a utility that can be installed from the SQL Server installation package. Note that some providers are not supporting SQL Server databases.

Accepted Solution

raid999 earned 50 total points
ID: 7029520
You can use tech like SOAP or DCOM to do so

Have a look at this

Also have a look at this

Expert Comment

ID: 7029530
to use SQL Server, you have to buy Server space enabled with SQL Server Support. and it is not a single file that you can upload to the webserver. and it is not at all possible with these free servers. and If you can buy server space why dont you go for a server side wrapper component to access database from your client side VB application.

and to use your web server should have support for .net platform. and it is also not available with free servers. note that brinkster is providing this service also as free.

(I'm not from brinkster anyway. I'm strongly supporting them b'cos I didnt see yet any other sites providing these services as free)

Author Comment

ID: 7029604
so any suggest for a web which support sql server ?
LVL 69

Expert Comment

by:Éric Moreau
ID: 7029630
brinkster if you pay.

Author Comment

ID: 7029716
raid999 Thanx a lot , the second link u send is great , u have this question points
LVL 69

Expert Comment

by:Éric Moreau
ID: 7030164
but isn't this link used to connect to SQL Server?

Author Comment

ID: 7030443
it is okay , i will think in SQL server , i treat with this sql database and it is okay , just like access but better

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now