🚀 go-pugleaf

Hi Sandor
I think you are correct about the connection string but I cannot get it to work.
The Microsoft site is good if you are useing Visual C++ but I cannot get the examples to translate to a Borland compiler.

Also it does not help that I am fairly inexperienced at programing. I think I am going to have to give up on this

Thanks ever so much for all your help
Mike
 
"Sandor Bognar" <bognars@mail.uti.hu> wrote:
>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
>
>
>
>
>
>
>
>
>