🚀 go-pugleaf

First of all I'd like to note that I'm not an ADO expert. I was interested
in how to distibute an ADO application, and forget it...

> Thanks for the help Sandor
> The program will compile but throws an error after it has compiled. Does
the code below look correct or have I gone wrong somewhere.

Could you be more specific describing the error message and the
circumstances?


> void __fastcall TForm1::FormCreate(TObject *Sender)
> {
> _RecordsetPtr pRecSet;
> wchar_t *ConnStr=L"D:\Inetpub\wwwroot\BMD\bmdtest.mdb";
> pRecSet = CreateComObject(CLSID_Recordset);
> pRecSet->Open(L"SELECT * FROM EssxBmd", ConnStr, adOpenStatic,
adLockReadOnly, adCmdText);
> pRecSet->MoveFirst();
>
> TVariant vVAlue = pRecSet->Fields->get_Item(2)->get_Value();
> Memo1 -> Lines -> Add (vVAlue);
>
> pRecSet->Close();
> pRecSet->Release();
> }

But before you send the error message :
I believe the ConnStr is wrong. One way to open the table is, if you pass
one of the already specified DSN names in the ODBC manager. The other way is
a "DSN-less" connection, which looks similar to your example, but you have
to specify the driver, user, password etc. also. I strongly recommend to
look the details and the overviews in the MSDN library...

HTH
Sandor