how to connect

[akhileshbc]

Friends,
I am having a database for my website. That is, it displays the marksheet of the students in the webpage. I want to update the database using my software created in VB. I mean, my computer will be connected to the internet and I want to make changes to the database(which is residing in the webserver) using my software. How can I connect to the database(I am using Access database) in the webserver. Is there any way.????

My purpose is, to update the students marksheet in database(situated in the webserver) rather than uploading the full database file itself.

I don't want to download the whole database file from the website and then make changes and then upload it. I hate it... because if the database is a little bit large, then the uploading process will take a lot of time. So, making direct changes to the database in the server, will save a lot of time....

Help me....please...

[RhinoBull]

Your thread rather belongs in DB Forum instead...

Anyway, answer depends on type of database you have on your webserver. So, what is it?

[akhileshbc]

Its Access 2003 database and I am using ASP (vbscript) for my webpages. I am using ADO connection in the webpage for showing the marksheet....

[si_the_geek]

Thread moved to Database Development forum (the "VB6" forum is meant for questions which don't fit in more specific forums)

There is a method, but it is unreliable and requires you to have certain permissions on the server. You can find a link in the "Access" section of our Database Development FAQs/Tutorials (at the top of this forum)

If you have the option, it would be better to get rid of Access and use a server-based database system instead (such as MySQL/Oracle/SQL Server/...).

[RhinoBull]

[I]... use a server-based database system instead (such as MySQL/Oracle/SQL Server/...).

I agree - if money is an object then you can at least get free editon of Oracle 10g Express or MS Sql 2005 Express and MySql is free since it's an open source.

[akhileshbc]

Do you hav some code to connect. I had seen si's code for connecting remoteserver. In that code, how can I find the i.P address of my website.

[akhileshbc]

Rhino, which of the above mentioned databases, is easy to create. Because I didn't have any prior knowledge of using any of the above.

[si_the_geek]

You can only use software (including database systems) that your web hosting company allows you to - they should have information on their web site about which database systems are supported.

Note that support for a particular kind of database does not necessarily mean that you will be able to connect remotely - it just means that code in your website (eg: ASP pages) can connect. You might need to contact the hosting company to get them to allow remote connections.

Do you hav some code to connect. I had seen si's code for connecting remoteserver. In that code, how can I find the i.P address of my website.

I don't think it was my code.

Anyhoo... I haven't tried it, but you can probably use the web address (eg: vbforums.com) instead of the IP address.

If that doesn't work, you wouldn't use code to find the IP address, that is something that you should know already (or can find easily by doing a Ping on the address).

[RhinoBull]

Rhino, which of the above mentioned databases, is easy to create. Because I didn't have any prior knowledge of using any of the above.

Let's just say that they are all equally different from MS Access. Each db engine has lots of features that make them all unique however they all share plenty of similarities either.
At some point you have to start learnig, right? So why not now?
Get a copy of each and try doing something very simple just to get an idea and then continue with the product that suits you best.