Storing a database on networked drive

Digital Society

Hi

I need a solution to this situation.

Im building a database driven Java program for a company. The database needs to be stored on the internal networked drive. They have an Access database setup already but i need to use MYSQL if possible.


Any suggestions?

Thanks

Skrynesaver

Digital Society wrote: »

Hi

I need a solution to this situation.

Im building a database driven Java program for a company. The database needs to be stored on the internal networked drive. They have an Access database setup already but i need to use MYSQL if possible.


Any suggestions?

Thanks

Either install MySQL on a network attached host and use that or export the Access instance as an ODBC data source and use that. (Hint: don't use Access, it's poo)

Digital Society

How do i install MYSQL on a network attached host? Will it install as a service somehow?

Skrynesaver

Digital Society wrote: »

How do i install MYSQL on a network attached host? Will it install as a service somehow?

yes

L.Jenkins

Can I ask, why does it need to be stored on a network drive and use Access as a DB of all things? The mind is boggled by that alone. Why not have them download and install Microsoft SQL Management Server Express and run in it on an available machine that could store the data on the Internal Networked Drive.

The SQL Server, does allow for JDBC and ODBC connections as far as I can remember, so you could develop a Java Application that would use the DB.

Aswerty

Itzy wrote: »

Can I ask, why does it need to be stored on a network drive and use Access as a DB of all things? The mind is boggled by that alone. Why not have them download and install Microsoft SQL Management Server Express and run in it on an available machine that could store the data on the Internal Networked Drive.

The SQL Server, does allow for JDBC and ODBC connections as far as I can remember, so you could develop a Java Application that would use the DB.

He said he wants to use MYSQL. Pay attention! :pac:

I'm a little confused as to the OP though. Is the Access DB stored on the file system of a networked machine or is it on a networked storage device? And are you trying to run MYSQL as a service on a networked machine but the actual database is then stored on the networked storage device?

Digital Society

Bit of a long story to why it needs to be done this way and bear in mind that if i had full control i would do as Itzy says.

I have been put in a situation where this company has been storing their production statistics in an Access database and excel files since 2001 apparently. 2 x 12 hour shifts where 6 different managers will log the days production and notes at the end of each shift. They will literally open up the same file, write to it and save it.

They do not want the info stored externally. They have really strict controls on their machines and connecting to outside sites is very difficult so my first idea to just use externally hosted MYSQL database isnt suitable.

Theres a whole lot of other reasons but ill be here all day mentioning them.

I have more experience with MYSQL and Java than anything else so i really want to use them.

So.....

In the end i think SQLite suits the project perfectly as it stores as a flat file in the same location as the other files. Multiple people will not be querying the database at the same time so locking shouldnt be a problem. Literally hours between shifts so thats not a problem.

Java App that connects to an SQLite database stored on the network drive seems the way to go.

gctest50

http://www.filemaker.com/ie is close enough to what you are describing

Digital Society

gctest50 wrote: »

http://www.filemaker.com/ie is close enough to what you are describing

How? Doesnt seem suitable at all from a quick look.