LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This 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


Reply
  Search this Thread
Old 11-24-2003, 06:23 AM   #1
meistwer
LQ Newbie
 
Registered: Nov 2003
Location: London-UK
Distribution: Red Hat 9
Posts: 4

Rep: Reputation: 0
Access Database on Linux RH9


Hi there,


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
 
Old 11-24-2003, 08:27 AM   #2
reiss
Member
 
Registered: Nov 2003
Location: Sydney
Distribution: Debian
Posts: 30

Rep: Reputation: 15
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.

Last edited by reiss; 11-24-2003 at 08:34 AM.
 
Old 11-24-2003, 09:07 AM   #3
meistwer
LQ Newbie
 
Registered: Nov 2003
Location: London-UK
Distribution: Red Hat 9
Posts: 4

Original Poster
Rep: Reputation: 0
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
 
Old 11-25-2003, 06:40 AM   #4
reiss
Member
 
Registered: Nov 2003
Location: Sydney
Distribution: Debian
Posts: 30

Rep: Reputation: 15
Hmm, found this forum, seems you can pretty much export you access database straight into a blank mysql database through ODBC

http://forums.macrumors.com/archive/topic/22069-1.html

(near the bottom, by zoetropeuk)

Actually this should work, pretty much from any db, to any db.

This is page from the mysql chapter with advise on using the OBDC connection from various programs including access and ADO

http://www.mysql.com/documentation/m...ents.html#ODBC

Last edited by reiss; 11-25-2003 at 07:19 AM.
 
Old 11-28-2003, 09:15 PM   #5
myunicom
LQ Newbie
 
Registered: Sep 2003
Posts: 14

Rep: Reputation: 0
thanks for your providing links.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Is there a database manager for linux that is compatable with M$ Access and SQL? enigma Z Linux - Software 2 08-27-2004 09:50 PM
how to open Access database ? meshmesh Linux - Software 1 01-27-2004 07:50 AM
Access Database on Linux RH9 meistwer General 2 11-24-2003 04:18 PM
Alternative to MS Access Database. glenn69 Linux - Software 2 08-26-2003 11:59 PM
Running an M$ Access database from Linux DarkSTech Linux - Networking 3 03-17-2003 12:05 PM


All times are GMT -5. The time now is 03:29 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration