Home > Archive > Delphi > February 2005 > SQL server and MS Access, dbGo or dbExpress, Delphi Proffessional or Enterprise ?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL server and MS Access, dbGo or dbExpress, Delphi Proffessional or Enterprise ?
|
|
| Lars-Erik Østerud 2005-02-17, 9:03 am |
| 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!
| |
| Roy R. Markussen 2005-02-19, 8:56 am |
| 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!
|
|
|
|
|