LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices


Reply
  Search this Thread
Old 02-24-2004, 12:36 AM   #1
BrianK
Senior Member
 
Registered: Mar 2002
Location: Los Angeles, CA
Distribution: Debian, Ubuntu
Posts: 1,334

Rep: Reputation: 51
SQL question - are all database programs the same?


I need to peel some data out of a large database. That database happens to be some strange Microsoft GUI-driven database that does not have a normal interface (I can't connect to the database without using the GUI). The guy that controls this thing says that I can install some sort of SQL interface on the computer that holds the data & have access to it just as I would expect. Does this make any sense to anyone? I'm not super familiar with databases - especially those that aren't MySQL.

Does this mean I can install mysql on the computer, then somehow point it to the MS data? Wouldn't the MS database have some sort of proprietary format, or are all SQL's the same in the way they hold data?

My goal is to make automated, daily reports from the machine (that lives at someone else's facility) and post them on the web (from a Windows box - ::sigh:: ) so that I can see them without going to each facility that has one of these computers. Does this sound feasible? Anyone familiar with an MS database that sounds like what I described (so I can read up on it)?

Thanks.
 
Old 02-24-2004, 06:56 AM   #2
Ljohan
LQ Newbie
 
Registered: Apr 2002
Location: Holland
Distribution: SuSe 8.0
Posts: 11

Rep: Reputation: 0
Re: SQL question - are all database programs the same?

What do you like to do with the data? store this in a local database or just get some data out of it and use it in a program?

If that is the case you need all you need is a SQL driver like odbc jdbc and from your code you make your program connect with the driver to the database and get the data.

So what do you like to do with it and in wich language are you coding?

Regards,
suntac.
 
Old 02-24-2004, 01:54 PM   #3
BrianK
Senior Member
 
Registered: Mar 2002
Location: Los Angeles, CA
Distribution: Debian, Ubuntu
Posts: 1,334

Original Poster
Rep: Reputation: 51
Re: Re: SQL question - are all database programs the same?

Thanks for the reply.
Quote:
What do you like to do with the data? store this in a local database or just get some data out of it and use it in a program?
Just get some data and use it in a program. No need to edit anything - just making reports
Quote:
If that is the case you need all you need is a SQL driver like odbc jdbc and from your code you make your program connect with the driver to the database and get the data.
This is correct. Should the driver exist on the system already, or is this something I will need to get?
Quote:

So what do you like to do with it and in wich language are you coding?
That is probably a rhetorical question, but... the language doesn't matter - something that's simple to get working on a Windows machine. php? perl? c++? I image I'll use one of the frist two so that I don't have to mess with MS Visual C++. It's pretty simple to get Active Perl running on a Windows Machine, maybe I'll just go that route unless someone has a good reason to use something else.

Any good sources of information on this topic that you could refer me to?

Last edited by BrianK; 02-24-2004 at 01:55 PM.
 
  


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
TOMCAT connect to MS SQL database shane200_ SUSE / openSUSE 1 06-01-2005 01:41 PM
TOMCAT and MS SQL database shane200_ Programming 0 05-31-2005 10:52 AM
database needed not sql herc222 Linux - Software 3 03-08-2004 07:34 AM
problem in sql database administration lomaree Linux - Software 5 06-11-2003 09:58 AM
SQL Database Administration GabeF Linux - Software 2 11-17-2002 07:28 PM

LinuxQuestions.org > Forums > Non-*NIX Forums > Programming

All times are GMT -5. The time now is 10:48 AM.

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
Open Source Consulting | Domain Registration