Active x 2.7

Business Central/NAV Developers Forum
1

HI, Does someone know the syntax to test the connection to a remote database before an import batch with Microsoft active x object library 2.7 in Attain? I don’t want my batch to stop if one remote database can not be reached? I use the following code to connect CREATE(DatabaseConnection); DatabaseConnection.ConnectionString:='Provider=Microsoft.Jet.OLEDB.4.0; Data Source=\Xlocation\database.MDB;… [:)]

2

Maybe this will help you: ConnectString: Text[100] Connect: ‘Microsoft ActiveX Data Objects 2.5 Library’.Connection ConnectString := ‘Data Source=\Xlocation\database.MDB’; IF NOT CREATE(Connect[1], TRUE) THEN ERROR(‘Connect %1 not created!’,1); Connect[1].Open(ConnectString);

3

Thanks, I will try that [8)]