Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data Link File Question
Message
 
To
28/07/2001 02:37:46
General information
Forum:
ASP.NET
Category:
ADO.NET
Miscellaneous
Thread ID:
00536806
Message ID:
00536829
Views:
8
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform