ADO 6

[dbahooker]

I know what Jet is.. do you even know what it stands for?

ROFL

it stands for

J = CRAPPY
E = OBSOLETE
T = DATABASE_WITHOUT_AN_ENGINE

 

[aaron.kempf]

seriously

can you kids even tell me what it stands for?
any Non-MVPs can tell me without looking it up?

-Aaron

 

[aaron.kempf]

SQL SERVER-- YOU FUCKING IDIOTS-- DOESNT NEED COMPACTING BECAUSE
AUTOSHRINK IS TURNED ON BY DEFAULT

 

[aaron.kempf]

MDB _CANT_ BE USED AS A DATASTORE FOR AN ACCESS PROJECT

OPEN THE BOOK; KNOW THE TECH BEFORE YOU TALK SHIT


ADO IS COMING BACK AND DAO IS _STILL_ TOO BUGGY FOR REAL WORLD USE

 

[Henning]

You earlier said you have programmed for many many years. From the languge
you use, I doubt that.

 

[aaron.kempf]

if you're not pissed off then you're not paying attention

just because I use 4 letter words-- when Microsoft has a MAJOR
MARKETING FAILURE ON THEIR HANDS-- Does that make me a bad programmer?

Henning are you telling me that MDB _CAN_ be used as a 'backend for an
Access Project'

ROFL

read the book before you start talking; dipshit

ADO is making a comeback and you DAO pansies should **** yourselves

 

[Robert Morley]

I don't think SQL Server and MDB are mutually exclusive, as your

fire/oven analogy suggests, because both can be used for the data store
in an Access project (which is the OP's point, I think).

Good point, my fire/oven analogy kinda breaks down there...I don't think
they're mutually exclusive, either.



Rob

 

[aaron.kempf]

SQL Server ISNT MORE DIFFICULT to deploy than MDB
ADO isn't MORE DIFFICULT TO USE THAN DAO

I'm just stoked that there is an ADO revival; thank god
I would rather clean toilets than use DAO

-Aaron

 

[Henning]

Me pissed off?? Nono just amused.

Just for the record, I use MySQL so I don't have to load that DotNet
Framework 2.x overload just to install an SQL-server.
MySQL installs in 10 minutes, not two hours.

/Henning

 

[aaron.kempf]

does mySql have sprocs these days? rofl

how about Analysis Services, a decent IDE; or an ETL tool?

ROFL

Me pissed off?? Nono just amused.

Just for the record, I use MySQL so I don't have to load that DotNet
Framework 2.x overload just to install an SQL-server.
MySQL installs in 10 minutes, not two hours.

/Henning

 

[Henning]

From ver. 5.0, yes and there is a tool to convert M$ SQL-Server to MySQL. It
is working better than I was expecting. Even not to complicated SP's. The
syntax is not too different, but some fieldtypes ofcause are.

I guess you will be better off if you download it and explore it yourself.
It's free to download, and for an IDE download MySQL Manager Lite also free.
The printing is unavailable in the Lite version though

/Henning

 

[aaron.kempf]

yeah I've done some mySql / php dev.. ecommerce-- in the past

I love the mySql environment.. especially phpMyAdmin.. I just haven't
had a chance to look at 5.0 / sprocs yet.. and these days-- a database
without 'Analysis Services' isnt' relevent to me anymore

-Aaron

From ver. 5.0, yes and there is a tool to convert M$ SQL-Server to MySQL. It
is working better than I was expecting. Even not to complicated SP's. The
syntax is not too different, but some fieldtypes ofcause are.

I guess you will be better off if you download it and explore it yourself.
It's free to download, and for an IDE download MySQL Manager Lite also free.
The printing is unavailable in the Lite version though

/Henning

 

[aaron.kempf]

and plus the big three vendors all have freeware editions now so I just
prefer sticking with those.

SQL 2005 express ROCKS and it works great for relatively complex
databases

From ver. 5.0, yes and there is a tool to convert M$ SQL-Server to MySQL. It
is working better than I was expecting. Even not to complicated SP's. The
syntax is not too different, but some fieldtypes ofcause are.

I guess you will be better off if you download it and explore it yourself.
It's free to download, and for an IDE download MySQL Manager Lite also free.
The printing is unavailable in the Lite version though

/Henning

 

[Henning]

Just the 'little' issue on DotNet Framework istall

 

[dbahooker]

just the 'little' issue of incompatability and licensing restrictions..
and needing to purchase a support agreement.. and needing to post the
source code from your apps according to the GPL

I never had a problem installing the .NET framework

Just the 'little' issue on DotNet Framework istall

 

[Henning]

Me neither, one time was one too many It took me one hour+ for nothing.

/Henning

 

[dbahooker]

you running it on a 486?

under Wine?

ROFL

I've honestly never had a problem installing it.. maybe the problem is
with your crappy linux firewall lol

-Aaron

 

[aaron.kempf]

what else you got on the server?

do you run antispyware / av?

I've installed SQL 2005 at least 20 times in the past year; and I've
never had anything (since the release) take an hour

how much Ram you got?
I just can't believe that there are still mySql people out there..
yeah; it was a great product-- but once the 'Big 3' responded by making
a freeware version; mySql just seems kinda passe now

-Aaron

Just the 'little' issue on DotNet Framework istall

 

[Henning]

No / Yes

SQL2005 was ok, but the DotNet Framework was killing me. As I remember
together it was som 150+ megs to dl. MySQL 5 is 35 megs, with all needed
tools about 50 megs.

Athlon 2800+
1G RAM
WD 200G HD * 3
XP Pro

Well, MySQL suites my needs, so I'll stay with it. At work we have just
migrated from M$ SQL to MySQL. It works as well, and at least just as fast
and safe. All db's are migrated and works flawlessly. But thats my opinion.

/Henning

 

[aaron.kempf]

works as fast as analysis services?

drag and drop instead of writing sql statements? web based
pivotTables?

sub second summary against a billion rows?
automated indexing?

I just haven't been using dialup for almost a decade anymore; out here
on this side of the pond we have this thing called 'Broadband'

and you see.. I just prefer having my shit in one place; instead of
needing to install drivers on any app that touches it

I'm glad that you've told me your good experience with mySql.. most of
the linux dorks over here are trying to get me to use postgres; i just
dont see a place for 9 different open source database systems.. if you
know what i mean.

I definitely respect mySql-- more than anything-- I mean-- the security
in that product is great.. SQL Server can't restrict a particular logon
to a specific IP address-- so I definitely APPRECIATE mysql..

but I mean.. SSIS, SSAS, SSRS? does mySql have any of those?
I just dont like piecemeal systems; it's 10 times as much work for
developers

-Aaron