UniDAC MS Acces connection

[Tango]

Can I make relative path specified? If I make absolute path specified and later the database where otherwise move I get error message

Here a Screenshot



Thanks

[AlexP]

hello,

MS Access ODBC driver doesn't support relative paths, therefore you should generate a full path. For example, if the DB file is located in a ..\data\ folder relatively to your application, you can use the following code to generate the path:

UniConnection1.Database := ExtractFilePath(Application.ExeName) + 'data\MyDb.mdb';

[Tango]

Thanks,

I've tried it. When I enter it in the source code I get
UniConection1 conected to false or UniQuery1 active to false

I give this one also in the source text, I get errors

UniConnection1.Database: = ExtractFilePath (Application.ExeName) + 'Abrechnung.accdb';
UniConnection1.Connected: = 'true'
UniQuery1.Active: = 'true'

I get error

[AlexP]

Please provide the text or a screenshot of the error message occurring on connection.

[Tango]

here screenshot

[AlexP]

You are trying to assign a string value to a Boolean property. More details about this error are available in the documentation

[Tango]

how should it be the right?
If I example source would have at least as could have been combined with relative path, I could learn a lot

[bork]

Code:

Code: Select all

UniConnection1.Connected := 'true';

it is the same as:

Code: Select all

var
  b: boolean;
begin
  b := 'true';
end;

This code can't be compiled, because a string constant can't be assigned to a boolean variable or property.

To get more information about data types compatibility and errors, please read the documentation.

[Tango]

I do not understand
have b defined as boolean
and UniConnection1.Connected: = b written does not work
ye have no Example where the database connection works with source code?

Code: Select all

procedure TForm1.FormCreate(Sender: TObject);
var
b: boolean;
begin
b:='true';
UniConnection1.Database:= ExtractFilePath (Application.ExeName) + 'Abrechnung.accdb';
UniConnection1.Connected:= b
UniQuery1.Active:= b
end;

[bork]

The code:

Code: Select all

b := 'true';

can't be compiled, because b has the boolean data type, and the 'true' constant has the string data type. The string data type can't be assigned to a boolean variable or property.

You can assign only boolean constant to boolean variable or property :

Code: Select all

b := true;

or you should convert the string constant to boolean:

Code: Select all

b := StrToBool('true');

Please read the documentation for Delphi data types compatibility again: here