putting the database online

[iamresearcher]

Hi, I have a question guys.

Suppose I have this access database and I want the database to be online but so that my stand alone executable program can connect to it.

Questions are:

1. How do I put up the server in that manner for that purpose.
2. What is the connection string to connect the program to the online database

I dont want to use browser as gui for my program. So I settle to an executable program.

Kindly give me some inputs. thanks.

[si_the_geek]

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


Don't use Access in that manner, it is not designed for anything even vaguely as complex as this - it is meant for a single user on the same computer as the database is stored.

This question has come up many times before, and I have never seen anyone get it to work. There might be a few people in the world who have achieved it, but it would take far more effort than using a proper database system instead.

If you use a proper database system (such as MySQL or SQL Server, depending on what your server supports) then connecting to it remotely will be the same as connecting to a local version - assuming of course that the server allows remote database connections (and many hosting sites don't).

Alternatively, create a web service (a "program" on the web site) that does the actual database work, and connect to it from your program.

[baadil]

As far as I am aware of, there is no concept of online/offline for Microsoft Access. It is a file based database system. Unlike SQL Server, which has services etc to make it online/offline Access files are just there. You can open and close connections to it.

Here are some connection strings.

http://www.connectionstrings.com/access

[iamresearcher]

it is just an example but my actual database would be mysql. I am stating how can it be achieved? I have seen connections string.

I was thinking if something like this is possible

syntax:
Server=myServerAddress;Database=myDataBase;Uid=myUsername;Pwd=myPassword;

actual:
server=181.10.115.10;database=mydatabase:uid=uname;pwd=upwd

the server 181.10.115.10 is specified aside from localhost

[si_the_geek]

That will work, assuming of course that the connection string is the same as you would use for a local database with just the server part changed, and that the server allows remote database connections.

[iamresearcher]

thanks! now can you kindly direct me how to setup that remote server? maybe some kind of reading. I have been googling but I guess its not that successful.

[si_the_geek]

If it is your server:

You set up the web server in the normal way and install MySQL on it, and information on those parts should be easy to find.

Enabling remote database connections is likely to be a bit more awkward, as you not only need to alter settings in MySQL, but also in the servers firewall etc. You are likely to find the info you need in MySQL based material.

If it is a hosted site, contact the hosting company - they need to do it.