Re: SQL server and MS Access, dbGo or dbExpress, Delphi Proffessional or Enterprise ?

From: Roy R. Markussen (roy_at_ihatejunkmail.miclis.no)
Date: 02/19/05 

Date: Sat, 19 Feb 2005 11:36:43 +0100

Lars,

You can use Enterprise, and buy the dbExpress ODBC-driver from CoreLabs.
This will allow you to connect to both SQL and Access.

Roy

"Lars-Erik Østerud" <.@.> skrev i melding
news:1108641350.521476@makrell.interpost.no...
> We have an application i Delphi 3 that uses the BDE together with the
> DATABASE and TTable componentes to access an MS Access database today
> (not using SQL, using TTable.First, Next, Add, Delete etc functions).
> Database is connect throught the BDE and an ODBC database source.
>
> Problem with this is that it does NOT work with SQL server databases,
> and we need to upgrade to Delphi 8 or 2005 to get the SQL server...
>
> But do we need Proffessional or Enterprise?
>
> Enterprise contains dbExpress for SQL Server, but no metioning of MS
> Access anywhere, and it seems like the code needs huge changes :-(
>
> Professional does not contain dbExpress support for SQL server, but it
> contains dbGo support for Microsoft ADO (MDAC 2.8). Can this be used
> BOTH to access an SQL server database AND an MS Access database, (no
> need to buy Enterprise), and how much rewriting must be done (will we
> be able to do the ".first, .next, .add, .delete" stuff from here, or
> something similar without having to write the whole application over)
>
> The price difference from Professional to Enterprise is HUGE, and we
> need a way to write the DB stuff to work BOTH with SQL server and MS
> Access (both databases will be used). Is then dbGo and ADO the best
> way, will that work with both SQL server and Access in Proffesional?
>
> Or do we need dBExpress and Enterprise edition, and do we than also
> need seperate code for SQL server (dBExpress) and Access (dbGo)?
>
> (I can't find anything about MS Access, it IS still supported, or?)
>
> --
> Lars-Erik - http://home.chello.no/~larse/ - ICQ 7297605
> WinXP, Asus P4PE, 2.53 GHz, Asus V8420 (Ti4200), SB-Live!

Relevant Pages