 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Edmund
Guest
|
 Posted: Thu Jan 18, 2007 9:08 am Post subject: ADO Property value invalid |
 |
|
Hi,
I have the following ADO set up lines:
dbx.DefaultDatabase := 'tdata2';
dbx.LoginPrompt := false;
dbx.ConnectionString := 'Provider=MSDASQL.1;Persist Security
Info=False;'+
'User ID=CC;Password=23212;Data
Source=tdata2;Extended '+
'Properties="SourceDB='+
'u:\rdata.dbc;SourceType=DBC;'+
'Exclusive=No;BackgroundFetch=Yes;'+
'Collate=Machine;Null=Yes;Deleted=Yes;"';
dbx.Mode := cmRead;
dbx.Provider := 'MSDASQL.1';
dbx.Connected := true;
Once I debug this and upon stepping over that last line,
I get an EOLEException error with the message "Property value
is invalid."
The problems are:
1) I don't see a 'value' poperty in the TADOConnection component.
2) If it was a 'generic' value, it isn't telling me which
value that needed to be set within the TADOConnection component.
I'm guessing it's the ConnectionString. I even tried this
by slapping a ADOConnection component on a form and
setting the connectionstring in design time(via the Build
option). Still, once I change the Connected property to True, it
also throws the same error.
I'm guessing during the ConnectionString Building process, something
must have choked and missed a crucial property value.
Any help appreciated.
Edmund |
|
| Back to top |
|
 |
Edmund
Guest
|
| Posted: Thu Jan 18, 2007 9:11 am Post subject: Re: ADO Property value invalid |
|
|
Didn't you write?:
| Quote: | Hi,
I have the following ADO set up lines:
dbx.DefaultDatabase := 'tdata2';
dbx.LoginPrompt := false;
dbx.ConnectionString := 'Provider=MSDASQL.1;Persist Security
Info=False;'+
'User ID=CC;Password=23212;Data
Source=tdata2;Extended '+
'Properties="SourceDB='+
'u:\rdata.dbc;SourceType=DBC;'+
'Exclusive=No;BackgroundFetch=Yes;'+
'Collate=Machine;Null=Yes;Deleted=Yes;"';
dbx.Mode := cmRead;
dbx.Provider := 'MSDASQL.1';
dbx.Connected := true;
|
Please do beg my pardon. Seems as if I might have
had some sort of brain splat such that I didn't notice
the defaultdatabase property was wrong. Instead of
the database name, I realized that it required the
actual database file. In this case, it was looking for
the FoxPro DBC file. Go figure.
So that's what was making it complain. Though I do WISH
it would've specified which property that Delphi 7 had
a problem with. Since I'm not home(which I have BDS2006
installed), is this "Property value is invalid" error
message also encountered in BDS2006 when entering the
wrong value?
Edmund |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
