10-22-2004, 07:51 PM
right now I have a program written and connected to my database. What I want to do is connect my program to my database that is saved on my internet site. I think this is possible but have no clue how to do it. If anyone could help me it would be great! I think its just simple code or even using the ODBC Administrator? Can someone please guide me in the right direction? Atleast let me know if it is possible? thanks
10-23-2004, 04:21 AM
You are not mentioning the database you're using...anyway pick out the appropriate connection string from here:
10-23-2004, 08:01 AM
I am using an access database.
I went to that site and found some info, I dont know that much about this stuff but I think this is what I want to use. Here is the code i found. Would this work?
oConn.Open "Provider=MS Remote;" & _
"Remote Server=http://myServerName;" & _
"Remote Provider=MSDASQL;" & _
"DSN=AdvWorks;" & _
"Uid=myUsername;" & _
10-23-2004, 08:52 AM
OK, I assume you are attempting to open this mdb file over the web? Is that the case, if not, you don't want to use this method and you should be implementing the Microsoft Jet 4.0 Provider. Look at the connection strings within that link for Microsoft Access or Jet exclusively, that's what you want.
10-23-2004, 09:22 AM
yea, I have a program interface, and a website "www.dapaine.com". what I want to do is when i press the command button to enter the information into the database, i want the info to update to the database that is stored on my site. It is an access database.
10-23-2004, 09:54 AM
Are we talking about a remote database on an IIS server? If so, I highly suggest using a different Database engine such as SQL Server or MySQL. Here is an article on the topic and some ways you can get around some of the restrictions:
10-23-2004, 11:23 AM
no, i dont know much about this, i just want to store my database on the web and have my vb program be able to update the database? can this be done? I was just gonna upload the database to www.dapaine.com/database/dp.mdb
10-23-2004, 01:42 PM
A basic ADO tutorial regarding connecting to your database and making runtime modifications, this also touches on some web based components:
That's three links, let us know if you have any specific questions after reviewing everything :). Good luck.
10-23-2004, 02:55 PM
this was just a question, and I dont think its possible. I am pretty good with connecting a database that is stored on my computer, but all I want to know is if it possible to connect to a database that is on the web. I am probally not explaining myself correctly. If it cant be done that it fine, I probally wouldnt use it very often but it would be cool. I have read over the links and nothing really goes into connecting to a access database that is stored on a website. Thanks so far for all the help.
10-23-2004, 07:18 PM
No, it IS possible..I am trying to give you resources that you can use to access the database. You will need to use ASP, SOAP or some web service based application, and you can reference it via the IP address. Again, you are much better off using a more robust database engine for this such as SQL Server or MySQL.
Scroll down to the bottom of this page, which has various connection strings and configuration for Access..this tells you how to connect to your db via a remote connection and IP: