>Hi,
>
>I am using VB6 with ADO on my application. I intend to
>allow flexibilty in my application by using Data link file
>insteads of hardcoding my ADO control.
>
>However, I had problem setting it up. Please advise me
>on which part I had miss out.
>
>On my form, there is a ADO data control with dbgrid control
>
>On my form load method, I had the following code
>
>With ADODC
>
> .ConnnectionString = "File Name=D:\winprog\data\pdetail.udl"
> .CommandType = adCmdTable
> .RecordSource = "pdetail"
>
>End With
>
> Set dbgrid.DataSource = ADODC <------ give error of "data source
>name too long"
>
>
>Please advise me.
Have you REFRESH the ADODC?
Also, use this syntax:
Set dbgrid.DataSource = ADODC.Recordset
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com