Board index » delphi » Access 2000 & Sql Server 7.0

Access 2000 & Sql Server 7.0

I'm just starting development on converting my Delphi apps to using the new
Access 2000 database (.ADP) which I want to run under MS Sql Server 7.0 as a
direct connection (without ODBC, etc.) Neither Delphi nor Microsoft postings
and web searches have turned up much. (There are some support articles in
Access/VB Office Advisor magizine but nothing on Delphi) My questions are:
- Is there some sample code/guidelines to do this?
- Are there any test data of performance of Access 2000 vs. a SQL Server
native database?
- Does Delphi 4.0 support the ADO?
- Is a local engine required to make the connection? i.e. the BDE, etc.
Any suggestions are appreciated and will be forward to the newsgroup.
Thanks.
 

Re:Access 2000 & Sql Server 7.0


Quote
On Mon, 21 Jun 1999 12:07:51 -0400, "Tom Carney" <a...@cafm.com> wrote:
>- Does Delphi 4.0 support the ADO?

Yes.  And there are free components on the Delphi Super Page as of the
15th that will let you do it.

Quote
>- Is a local engine required to make the connection? i.e. the BDE, etc.
>Any suggestions are appreciated and will be forward to the newsgroup.
>Thanks.

No BDE with the ADO components mentioned above.

You might also want to take a look at the new MSDE thingie from
Microsoft.  A free, redistributable, cut-down version of MS SQL 7

Daniel J. Wojcik
****************
http://www.genjerdan.com

Re:Access 2000 & Sql Server 7.0


Just import the ado type library into your project, no other components needed
then.....
Quote
Tom Carney wrote:
> I'm just starting development on converting my Delphi apps to using the new
> Access 2000 database (.ADP) which I want to run under MS Sql Server 7.0 as a
> direct connection (without ODBC, etc.) Neither Delphi nor Microsoft postings
> and web searches have turned up much. (There are some support articles in
> Access/VB Office Advisor magizine but nothing on Delphi) My questions are:
> - Is there some sample code/guidelines to do this?
> - Are there any test data of performance of Access 2000 vs. a SQL Server
> native database?
> - Does Delphi 4.0 support the ADO?
> - Is a local engine required to make the connection? i.e. the BDE, etc.
> Any suggestions are appreciated and will be forward to the newsgroup.
> Thanks.

Other Threads