Connectionstring error with MS Access DB

From: Bob Dalton (bob.dalton_at_removeme_digitallogistics.com)
Date: 07/13/04 

Date: Tue, 13 Jul 2004 15:21:14 -0500

Based on answers from another post in this forum I was able to export a MS
SQL 2000 database to a MS Access DB file (ie; mdb).

I use the following connection string in the TADOConnection component:

CONNECTSTRING=Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Delphi
Projects\VisKCS_MSA\Data\viskcs.mdb;Mode=ReadWrite;Persist Security
Info=False

When I build the connection string using the connection string editor use of
the "test connection" button returns a success result. When I set the
"Connected" property to true in the TADOConnection component I get the
following error:

"Error: Read-only value not set"

This is happening in Delphi 7.0 Pro. I am not getting this with a
connection string for MS SQL 2000 but just MS Access. Any ideas on what is
causing this and how to resolve it?

I am using this in a client to connect via ADO to the mdb dataabse and I
have Micrososft Access 2002 on my system and MDAC 2.8.

Regards;

Bob Dalton

Quantcast