Solved

Connect to DataBase on Remote WebServer

Posted on 2003-10-30
24
307 Views
Last Modified: 2013-11-13
I have a database called Website.mdb stored on a remote server the only way to connect to is through the .com address or ip address, lets say the server is called http://www.yahoo.com for this example and the database is still called website.mdb and is store at http://www.yahoo.com/cgi/write I need to be able to run query off it as if it were local via the internet I have tried serveral things and come up empty handed each time. I am looking for examples of code as i need to get this solved in a timley manner. As of now there are no user names or passwords assigned but please include the varible with UserName = usertext and Password = passtext

Lets also say the virutal path to the database on the server is = to d:\Ipub\.com\cgi\write\website.mdb

Greg
0
Comment
Question by:gharman
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 10
  • 7
  • 3
  • +2
24 Comments
 
LVL 5

Expert Comment

by:fantasy1001
ID: 9656118
It is not impossible but very difficult. Do you have control of the website. If so, you can use other scripting language for query the database for you. What I mean is your VB program will pass request to the scripting language such as asp, java, then the output returned wil be feed back to your program. I donn't think there is why to do it directly not involving placing external program at the server.

Thanks,
~ fantasy ~
0
 

Author Comment

by:gharman
ID: 9656122
I want to get away from ASP i have complete FTP control over this site. Im not sure i care about the level of diffculuty to do it as long as it works id rather do it right the first time and not mickey mouse it.

Greg
0
 
LVL 5

Expert Comment

by:fantasy1001
ID: 9656179
Since you have ftp,
I think you can try to set the system dsn database path to the ftp path. for example \\write\website.mdb
This method worked for normal lan networking, I am not sure whether ftp also can.

Thanks
~ fantasy ~
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:gharman
ID: 9656195
Doesnt work tried that one. It not a valid file type.

Greg
0
 
LVL 5

Expert Comment

by:fantasy1001
ID: 9656218
It is better you use asp, asp code for querying is similar to vb also.
from your vb, use webcontrol to access the data, everything is easy.

Thanks,
~ fantasy ~
0
 

Author Comment

by:gharman
ID: 9656233
I do not want to use ASP to query the database i want to do it through visual basic which i know is possible thank you for your time but you dont have what I am looking for.

Greg
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 9656803
0
 
LVL 30

Expert Comment

by:nmcdermaid
ID: 9656930
URL querys come standard with SQL 2000 if you are interested in upgrading.
0
 

Author Comment

by:gharman
ID: 9659785
To Emoreau:

I have tried that exact website and get run time error 8447. Internet Server Error. So this will not work.

To nmcdermaid:

I cant upgrade the servers they are not myne to play with like that.


Greg
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 9659908
0
 

Author Comment

by:gharman
ID: 9665225
I have no control over the remote server i just have read and write access to the directory where the database resides.

Greg
0
 

Author Comment

by:gharman
ID: 9665228
Adding to the above comment : I do know that I can access the database via ASP so the server does respond.

Greg
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 9665759
If the server is not configured to let you through, you won't be able to use the database!
0
 

Author Comment

by:gharman
ID: 9684492
How about using an INET control through FTP/HTTP has anyone tried that? The only thing about using this is i dont want to download the database and then re upload it since mutiple users will  be using this application.

Greg
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 9685778
A book from Carl Fanklin (Visual Basic 6.0 Internet Programming - ISBN 0-471-31498-6) can help you. The last chapter is about accessing a database on a server using Winsock if I remember correctly.

But if you are serious about creating a multi-user application having its database shared over the Net, the first thing you need to do is to use SQL Server 2000 as your database engine.
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 10163588
Points to emoreau
0
 

Author Comment

by:gharman
ID: 10168563
This question was never answered and I had to actually create a VPN connection with the local server and the remote server and read the database. The point should be refunded.\

Greg
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 10168641
>>This question was never answered

I think that I gave you some hints on solution but you never postback!
0
 

Author Comment

by:gharman
ID: 10169319
You never hinted anything about a peer to peer VPN connection in any of your comments. You were far more argumentative than helpful.

Greg
0
 
LVL 70

Expert Comment

by:Éric Moreau
ID: 10170483
"A book from Carl Fanklin (Visual Basic 6.0 Internet Programming - ISBN 0-471-31498-6) can help you. The last chapter is about accessing a database on a server using Winsock if I remember correctly."
0
 

Author Comment

by:gharman
ID: 10171952
How does a book reference that I have not bought refer to using a VPN connection.

Greg
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 10457128
PAQed, with points refunded (100)

Computer101
E-E Admin
0

Featured Post

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Script Host (WSH) has been part of Windows since Windows NT4. Windows Script Host provides architecture for building dynamic scripts that consist of a core object model, scripting hosts, and scripting engines. The key components of Window…
Having just graduated from college and entered the workforce, I don’t find myself always using the tools and programs I grew accustomed to over the past four years. However, there is one program I continually find myself reverting back to…R.   So …
Viewers will learn how to properly install Eclipse with the necessary JDK, and will take a look at an introductory Java program. Download Eclipse installation zip file: Extract files from zip file: Download and install JDK 8: Open Eclipse and …
The viewer will learn how to pass data into a function in C++. This is one step further in using functions. Instead of only printing text onto the console, the function will be able to perform calculations with argumentents given by the user.

688 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