Connect to DataBase on Remote WebServer

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
gharmanAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

fantasy1001Commented:
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
gharmanAuthor Commented:
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
fantasy1001Commented:
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

gharmanAuthor Commented:
Doesnt work tried that one. It not a valid file type.

Greg
0
fantasy1001Commented:
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
gharmanAuthor Commented:
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
Éric MoreauSenior .Net ConsultantCommented:
0
nmcdermaidCommented:
URL querys come standard with SQL 2000 if you are interested in upgrading.
0
gharmanAuthor Commented:
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
Éric MoreauSenior .Net ConsultantCommented:
0
gharmanAuthor Commented:
I have no control over the remote server i just have read and write access to the directory where the database resides.

Greg
0
gharmanAuthor Commented:
Adding to the above comment : I do know that I can access the database via ASP so the server does respond.

Greg
0
Éric MoreauSenior .Net ConsultantCommented:
If the server is not configured to let you through, you won't be able to use the database!
0
gharmanAuthor Commented:
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
Éric MoreauSenior .Net ConsultantCommented:
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
Éric MoreauSenior .Net ConsultantCommented:
Points to emoreau
0
gharmanAuthor Commented:
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
Éric MoreauSenior .Net ConsultantCommented:
>>This question was never answered

I think that I gave you some hints on solution but you never postback!
0
gharmanAuthor Commented:
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
Éric MoreauSenior .Net ConsultantCommented:
"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
gharmanAuthor Commented:
How does a book reference that I have not bought refer to using a VPN connection.

Greg
0
Computer101Commented:
PAQed, with points refunded (100)

Computer101
E-E Admin
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming Languages-Other

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.