🚀 go-pugleaf

1. Try reduce ConnectionString to

Provider=Microsoft.Jet.OLEDB.4.0;Data
Source=C:\WORK\C_Project\BCB5\testADO\Data\cat22.mdb

2. Comment line DM->ADOConnection->Connected = true; - you set already
provider in ConnectionString.

3. Check that your file C:\WORK\C_Project\BCB5\testADO\Data\cat22.mdb
exists.

Regards,
Vassiliev V.V.
http://www.oledbdirect.com


"Slava Sh." <slava@space.com> �������/�������� � �������� ���������:
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
>
>