Re: Suggestoins for Local DB to use with Shareware
- From: "I.P. Nichols" <nospam@xxxxxxxxxx>
- Date: Sun, 30 Apr 2006 13:42:48 -0400
"G. Bradley MacDonald" wrote:
Pardon me for jumping in but as an enthusiastic user of Access's mdb
database files, I'm very interested in learning what issues you have
experienced and would greatly appreciate if you could elaborate as what
happen, were you using Delphi's ADO support and what vintage Access.
Not a problem. Exactly what I was using was a while ago - so I am not
positive. It was with D3 - I was using the BDE at the time. The access
was slow (probably because of the BDE layer) and it didn't seem to
handle the large number of inserts without issues (I honestly can't
remember exactly what they were now - but I would get messages from
access about problem with the inserts after about 300,000).
My issue then as it is now - is that I want to support both the local
and the Relational DB with the same code - so I end up using a layer of
abstraction (whether it be BDE or something like dbEXpress).
Does that help?
Yes and thanks. As for my own experience I begin to evalute ADO with Access
MDB files in D4 just before D5 appeared with built in ADO support what has
performed flawlessly for me. I quite using BDE when D5 with ADO came on the
scene and I have no experience with dbExpress. I can say that ADO is tried
and proven and at this point is static in it's development. In my experience
ADO + MDB has been both very stable and quite fast when compaired to other
local database engines and I will continue to use it in the future.
In my opinion MDB with ADO acts like a Relational DB. I can say the with the
current Microsoft OLEDB Provider and Jet-4, I have been able to demonstrate
that by simply changing the connection string I can switch between MS SQL
and Access MDB databases in the same application with ADO and OLEDB handling
any data type translations. FYI I'll attach the two connection strings
below. Since I don't use Oracle I have no first hand knowledge.
I wish you well in your quest for a database engine that will meet your
requirements.
Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
Info=False;Initial Catalog=Northwind;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;Workstation ID=LUKE;Use Encryption for
Data=False;Tag with column collation when possible=False
Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data
Source=F:\AccessFiles\NorthWind.mdb;Mode=Share Deny None;Extended
Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet
OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database
Locking Mode=1;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk
Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System
Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale
on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet
OLEDB:SFP=False
.
- Follow-Ups:
- Re: Suggestoins for Local DB to use with Shareware
- From: Wayne Niddery [TeamB]
- Re: Suggestoins for Local DB to use with Shareware
- References:
- Suggestoins for Local DB to use with Shareware
- From: G . Bradley MacDonald
- Re: Suggestoins for Local DB to use with Shareware
- From: Arthur Hoornweg
- Re: Suggestoins for Local DB to use with Shareware
- From: G . Bradley MacDonald
- Re: Suggestoins for Local DB to use with Shareware
- From: I.P. Nichols
- Re: Suggestoins for Local DB to use with Shareware
- From: G . Bradley MacDonald
- Suggestoins for Local DB to use with Shareware
- Prev by Date: Re: Suggestoins for Local DB to use with Shareware
- Next by Date: Re: Suggestoins for Local DB to use with Shareware
- Previous by thread: Re: Suggestoins for Local DB to use with Shareware
- Next by thread: Re: Suggestoins for Local DB to use with Shareware
- Index(es):
Relevant Pages
|
