Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
I've got a desktop with WinXP and my laptop with dual OS', Red Hat9 and XP. For a university project I've created a Visual Basic application which reads the data from a DB created in Access XP. There is an important lack of teaching in the UK universities regarding to non-microsoft OS enviroments so that's why I want to start showing to my tutors that linux can do much better than windows using it for my practical assignments, and that it is not just an alternative Os. My question is, is there any way to install the database in linux as file server and read the data from the application installed in my desktop(XP)?. I've tried with samba but id doesn't seems to work.
Can anybody give a hand?, I'm a newbie so I know the basic but please I appreciate a nice explanation...cheers!!!
Meistwer
Never sub-estimate the power of stupid people when they get 2gether
Umm, If your suggesting that the fileserver and the VB app would be running on the same machine, the no. Even if you could, there would be no point.
If on the other hand your suggesting keeping the Access db on a *seperate* linux fileserver, then yes you could, but there would still be no point.
What you could try instead, is recreate your database on an opensource db server, like MySQL or PostgreSQL, and connect to it from multiple instances of your VB app through ODBC (incredibly easy in VB if your already ADO for your connection: con.Open "DSN=MyDatabasesDSN" ) The only thing you'd really need to worry about is some of your SQL may need to be changed (probably nothing that major, but IIRC Access uses slightly different operators to the other db's).
This would not really demonstrate linux since these db's will run on windows as well, but it would show that opensource can produce software as good, if not better, than massive corporations.
Yep, the VB app will be in the XP side of the desktop as client, and the DB in the linux side of the laptop acting as file server. The problem is that I have the presentation of this at the end of the week and I dont have to much time to recreate the DB....
Do you any other way?
Meistwer
Never sub-estimate the power of stupid people when they get 2gether
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.