error parsing query in pocket pc using two tables with inner join

Hi All,

I'm implementing merge replication between a SQLCE 2.0 database on a
PocketPC device (PPC) and a SQL 2K database on a desktop (WinXP Pro). I'm a
ble to get synchronize and
run. but i am getting problem when i use two tables using inner join as show
n below


sql = "SELECT menu.menu_image, menu.menu_image" & _
"FROM menu " & _
"INNER JOIN mprg " & _
"ON menu.menu_id = mprg.menu_id "

drOrders = cmdOrders.ExecuteReader()
While drOrders.Read() ..

It is giving this error all the time i solved from microsoft kb for this pro
blem but giving same error.


Error Code: 80040E14
Message : There was an error parsing the query. [Token line number, Token
line offset,,Token in error,,]
Minor Err.: 25501
Source : Microsoft SQL Server 2000 Windows CE Edition
Num. Par. : 1
Num. Par. : 51
Err. Par. : INNER


How can I fix this problem? iam using sqlcesp3 and windows ce 2.0 . I did
merge replication in sql server . i also deleted the data from tables.
i used this option from microsoft : Select the Enforce relationship for rep
lication check box that is located under the Relationships tab of the Table
Design properties page (for each constraint) in the SQL Server Enterprise Ma
nager, and then re-run the Snapshot Agent.
But i am getting same error.
Looking forward for kind reply,
Pramod Renikindi
australia

ctacke/>
Tue Jul 19 06:43:46 CDT 2005

First line is missing a space before the training quote.

-Chris


"Pramod Renikindi" <PramodRenikindi@discussions.microsoft.com> wrote in
message news:E390C319-8485-44F4-8526-887105955535@microsoft.com...
> Hi All,
>
> I'm implementing merge replication between a SQLCE 2.0 database on a
> PocketPC device (PPC) and a SQL 2K database on a desktop (WinXP Pro). I'm
> a
> ble to get synchronize and
> run. but i am getting problem when i use two tables using inner join as
> show
> n below
>
>
> sql = "SELECT menu.menu_image, menu.menu_image" & _
> "FROM menu " & _
> "INNER JOIN mprg " & _
> "ON menu.menu_id = mprg.menu_id "
>
> drOrders = cmdOrders.ExecuteReader()
> While drOrders.Read() ..
>
> It is giving this error all the time i solved from microsoft kb for this
> pro
> blem but giving same error.
>
>
> Error Code: 80040E14
> Message : There was an error parsing the query. [Token line number, Token
> line offset,,Token in error,,]
> Minor Err.: 25501
> Source : Microsoft SQL Server 2000 Windows CE Edition
> Num. Par. : 1
> Num. Par. : 51
> Err. Par. : INNER
>
>
> How can I fix this problem? iam using sqlcesp3 and windows ce 2.0 . I did
> merge replication in sql server . i also deleted the data from tables.
> i used this option from microsoft : Select the Enforce relationship for
> rep
> lication check box that is located under the Relationships tab of the
> Table
> Design properties page (for each constraint) in the SQL Server Enterprise
> Ma
> nager, and then re-run the Snapshot Agent.
> But i am getting same error.
> Looking forward for kind reply,
> Pramod Renikindi
> australia