🚀 go-pugleaf

When you use the \ character in a string you have to use it twice to get a \
character :
Source=C:\\WORK\\C_Project\\BCB5\\testADO\\Data\\cat22.mdb

HTH
Ciao
    Formentz

"Slava Sh." <slava@space.com> ha scritto nel messaggio
news:3c96d743_1@dnews...
> Hello
>
> I generate connection string & test it in design-time. All test OK.
> Then I copy that string to ConnectionString from Clipboard:
>
> .... TForm::BtnClick(...)
>      try
>      {
>
>
> // DM - DataModule
>
>         DM->ADOConnection->Close();
>         DM->ADOConnection->ConnectionTimeout = 15;
>         DM->ADOConnection->LoginPrompt = false;
> //
>   WideString ConnectionString =
>       "Provider=Microsoft.Jet.OLEDB.4.0;User ID=Admin;Data
> Source=C:\WORK\C_Project\BCB5\testADO\Data\cat22.mdb;Mode=Share Deny
> None;Extended Properties="";Persist Security Info=False;Jet OLEDB:System
> database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet
> OLEDB:Engine Type=4;Jet OLEDB:Database Locking Mode=0;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"; //
> //
>         DM->ADOConnection->ConnectionString = ConnectionString;
> //
>         DM->ADOConnection->Mode = cmShareDenyNone;
>         DM->ADOConnection->Provider = "Microsoft.Jet.OLEDB.4.0";
> //
>         DM->ADOConnection->Connected = true;
>     }
>      catch(EOleException &E)
>      {
>       Application->MessageBox(
>       "Error connect MDB !",
>       "Error",
>       MB_OK + MB_ICONSTOP + MB_SYSTEMMODAL);
>      }
>
> When I launch Application & click Btn - I see 'NOT A VALID FILENAME' !!!
> What`s wrong in this code???
>
> Thanks
> SLAVA