connecting database?

dapaine
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

Shurik12
10-23-2004, 04:21 AM
You are not mentioning the database you're using...anyway pick out the appropriate connection string from here:
http://www.able-consulting.com./ADO_Conn.htm

dapaine
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;" & _
"Pwd=myPassword"

MKoslof
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.

http://www.able-consulting.com./MDAC/ADO/Connection/OLEDB_Providers.htm#OLEDBProviderForMicrosoftJet

dapaine
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.

MKoslof
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:

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q253580

dapaine
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

MKoslof
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:

http://www.xtremevbtalk.com/showthread.php?t=66994

That's three links, let us know if you have any specific questions after reviewing everything :). Good luck.

dapaine
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.

MKoslof
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:

http://www.able-consulting.com/MDAC/ADO/Connection/ODBC_DSNLess.htm#ODBCDriverForAccess

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum