Select query fails on WinNT, runs OK on Win2k

[ctudose]

I have a simple select query(Q1) that uses 2 linked tables T1 and T2(from SQL Server 2000):

SELECT T1.* , T2.Field1,T2.Field2 FROM T1 LEFT JOIN T2 ON T1.Field1 = T2.Field1

I use then Q1 and T2 to create another query(Q2)- Q2 calls Q1)

SELECT Q1.Field1 FROM Q1 INNER JOIN T2 ON Q1.Field1=T2.Filed1

On Win2k Q1 & Q2 runs witout problems
On WinNT Q1 runs OK, but Q2 generates
ODBC call failed(#107)-The column prefix 'MS1' does not match with a table name or alias name used in the query

Can anybody explain why is this behavior on WinNT and how can I avoid such error

Thanks,
Cris

 

[fluteplr]

When you say you are using 2 different operating systems, is this on the server or the client?

If on the client are you running the same version of the MDAC on both clients? If not try updating the WinNT box to the latest version of the MDAC. Some of the earlier versions had odd bugs.

If on the server(s) are you absolutely sure the table structures are IDENTICAL on both servers?

 

[ctudose]

The problem it's on client side
I have the latest MDAC on both machine.

Thanks,
Cris