🚀 go-pugleaf

Alex Samad wrote:

> I am thinking of learning to use SQL on Linux, either PostGreSQL or MySQL.
> The main thing I want to be able to do is to point MS Access 2000 to it.
> 
> 1) can it be done, with out paying for connectors
yes but i havent got it working yet

> 2) which would be better
who knows for sure

> 3) what is more widely used in the real world
oracle

>
> Thanxs
> Alex

-- 
With careful modifications to the case of the Win 3.1 machine, it can be
hollowed out and turned into a Crab-pot. Once tossed into the nearest river
or estuary, you will be amazed at it's improved performance. Where once it
produced very little of anything, now you'll have mud crabs.

Alex Samad wrote:

> I am thinking of learning to use SQL on Linux, either PostGreSQL or MySQL.
> The main thing I want to be able to do is to point MS Access 2000 to it.
> 
> 1) can it be done, with out paying for connectors
> 2) which would be better
> 3) what is more widely used in the real world
> 
> Thanxs
> Alex

PostgreSQl is better, it is ACID compliant and I used mysql before. Use 
Postgres IMHO.

-- 
Then a man said: Speak to us of Expectations.

He then said: If a man does not see or hear the waters of the Jordan,
then he should not taste the pomegranate or ply his wares in an open
market.

If a man would not labour in the salt and rock quarries then he should
not accept of the Earth that which he refuses to give of himself.

Such a man would expect a pear of a peach tree.
Such a man would expect a stone to lay an egg.
Such a man would expect Sears to assemble a lawnmower.
                -- Kehlog Albran, "The Profit"

Alex Samad wrote:

> I am thinking of learning to use SQL on Linux, either PostGreSQL or MySQL.
> The main thing I want to be able to do is to point MS Access 2000 to it.
> 
> 1) can it be done, with out paying for connectors
> 2) which would be better
> 3) what is more widely used in the real world
> 
> Thanxs
> Alex

Hi, 
I've set up postgres on my machine and connect to it from Access (97) using 
ODBC from windows 98 (running under vmware express on the same machine) .  
The ODBC drivers I found after a search on google - they're not big, but 
work well.  I also grab data from postgres & stick it into Excel using 
Microsoft query - all works well.


At work I use Access & sql server, so its not much different.  You can send 
raw SQL though as pass through queries. For building tables quickly I use 
pgaccess - an access-like program that comes with Suse

As someone who uses SQL quite a bit on a regular basis, postgres strikes me 
as a very good learning tool (and production tool too - i've not used it 
that way - so no comment there :)

If you're interested in DBA type roles, then playing with a system like 
postgres will also given you insights into backup/restores, db management, 
user permissions etc.

(For learning SQL access is good too - using the query builder & seeing how 
queries are created can be instructive (this isn't flame bait - but if 
you're an occasional user or need things very quickly it's a good tool).)

I'm using SuSE 7.2
512 MB mem
Athlon
about 9GB disk, 
VMwate express (bought from Suse too)

-- 
reverse domain for email address