Conecting to a database in delphi 2009 pro???

[Transmitter319]

Hi there,

After sitting for many hours trying to connect to an sql database even thou the components are on the tabs I found I was unable to connect to the database owing to delphi 2009 pro not having some dll's which are included in the enterprise version etc...
Can someone tell me if there are a good cost efective set of componets etc like sdac and unidac.
Ive had a look at both of the above but what always supprises me is when I read the forums with I found this bug and that bug etc...
Ive also always wonder what advantage sdac has over unidac.. I know unidac can connect to more database providers.
As you guessed cost is a problem on this one. Enterprise a big leep in cost andsdac and unidac not exactly cheep..
Any ideas on this?

Thanks Brothers

 

[whosrdaddy]

Hi,

in pro you normally have the dbGo components (TADOConnection, TADOQuery, TADOTable, ...) these components will satisfy all your SQL needs, free of charge and I use these for 15 years now without any problem....

Cheers,
Daddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!

 

[majlumbo]

Depending on which sql database you're trying to connect to, these set of components may allow you to do so, and it's free.

http://zeos.firmos.at/portal.php

One warning, installation can be a bit cumbersome...

 

[smays]

dbGo components work fine. I find the interface cumbersome compared to BDE-like interfaces (simply a personal choice). One thing to keep in mind regarding dbGo: you need to have ODBC drivers available. You did not happen to mention to what flavor of database you are trying to connect. MySQL makes drivers freely available for download. ODBC drivers for Microsoft SQLServer seem to always be available. That said, I cannot find ODBC drivers for Oracle no matter what I do.

I use dbGo to extract data from Excel spreadsheets, but for anything else I use purchased drivers, which make my life much simpler. For MySQL I use drivers from

http://www.microolap.com.

To connect to Oracle I use drivers from

http://www.devart.com.

Quick question, are you attempting to use dbExpress?

Steve.

 

[Transmitter319]

Hi there,
Thanks for the replys.

whosyouredady... Ill go back and have a try with them

majlumbo...... Ill have a look thanks.

smays.... MSSQL and yes Ithink I was trying to use dbexpress.... I also apart from trying to conect to MSSQL might try to connect to a Paradox database...

Thanks all for your input...and does anyone have any info on a good tut for this type of thing databases and connecting etc...

Thanks

Transmitter319

 

[smays]

MSSQL? I would go with whosrdaddy's suggestion. Chances are the ODBC drivers are waiting for you.

As far as Paradox, BDE might be worth considering. However, there is a chance you already have Microsoft ODBC drivers for Paradox installed. If that is the case, you can learn to use the same interface for both Paradox and MSSQL.

THIS IS JUST MY OPINION AND EXPERIENCE: dbExpress can work just fine IFF the appropriate DLL is installed/included AND IFF you learn to work with TClientDataSet.

Steve.

 

[Transmitter319]

Thanks Steve,

I did have it it a play last night and got it conected find with dbgo and the ODBC drivers etc... So thats a nice cost saving for me.
I just need to do some basic add a record accross a couple of tables etc and some basic searching so im hoping it should be fine for that!
dbexpress doesnt on the pro version seem to install the dll's.
Ill also have a look at the paradox in ODBC as well...

Thanks for your help on this

Glen

 

[whosrdaddy]

The ADO components will work across most databases, as long as they provide ODBC drivers.

I work with SQL, MySQL, Oracle and PostGreSql without any problem.
One piece of advice, learn how to write SQL and use the TADOQuery component, it will save you a lot of trouble in the long run.

Good luck & cheers,
Daddy

-----------------------------------------------------
What You See Is What You Get
Never underestimate tha powah of tha google!