dbGo and Delphi

For years I believed the Professional Edition of Delphi did not provide any database access to SQL Server. I assumed if you wanted db access you would need to import the type library for ADO included in MDAC. But raw COM access to ADO is sometimes a pain (think BSTR and SafeArray). So 15 minutes of googling and reading the BDS help file I discovered a gem called dbGo. From the help file, "The dbGo components provide data access through the ADO framework." Go figure, or should I say "dbGo figure"? [Geek humor, haha]

So my question is what advantage, if any, does the Enterprise and Architect editions of BDS provide for a SQL Server database developer? I'm sure there are some advantages, most likely designed for the corporate developer and or enterprise environment. But for my needs it looks like dbGo and Delphi Professional will work nicely.

I need to verify that I can use dbGo to access SQL Server 2005 but from what I read it looks like dbGo is nothing more than a wrapper to ADO. And ADO can definitely talk to SQL Server.

[Update] I have no problems interacting with SQL Server 2005 using dbGo and the Professional edition of Delphi. This opens up a whole new world for me.

posted by Kirby | 05-May-2006 10:46 AM | comments (2)

I think the one thing I needed "enterprise" edition for was the CLIENT-SIDE datasets (formerly MIDAS). Am I right in thinking that is only in enterprise or higher?

Glad to hear that SQL-Server works with just Pro.

posted by mike | May 11 06:15 AM

I believe you are correct, sir.

posted by Kirby Turner | May 11 08:02 AM

Add Your Comment

Comment: (No HTML)
Name:
E-mail/Web site:	Your e-mail/web site will not be published on this site. It is optional and will only be used by me should I need to contact you directly.
	Remember me? By checking this option, this site will remember your name and e-mail/web site on future visits. Uncheck this option to have the site not remember who you are on future visits.
	Enter the code shown above: