>Hi,
>Someone please help me to solve my problem.
>I would like to connect to a MSDE database's table. But when i
>connect using ADOTable.Open, it gives me error - Invalid Variant
>type conversion. the following is my code:-

>  ADOTable1.Connection:=ADOConnection1;
>  ADOConnection1.ConnectionString:='Provider=MSDASQL.1;'+
>                                   'Persist Security info=False;'+
>                                   'User ID='sa';'+
>                                   'User Password='';'+
>                                   'Data Source=ABC;'+
>                                   'Mode=Read;'+
>                                   'Initial Catalog=EsofLAN';
>  ADOConnection1.LoginPrompt:=false;
>  ADOConnection1.open;
>  ADOTable1.TableName:='XYZ';
>  ADOTable1.Open;

>  I know there must be something wrong with my script. Please
>  correct me.

>  Thanks in advance.

>  sam

> Hi,
> I have solve the problem. It is because i didn't put 'dbo.'
> in front of the table name.

> Thanks.

> sam