Collation Conflict Error

<i><b>Originally posted by : Danny Sinang (danny@uplink.com.ph)</b></i><br />Hello,<br /><br />I was trying to connect my ASP.NET app to a SQL Server 2000 machine when I encountered an ADO.NET error saying "Cannot resolve collation conflict on column 2 of SELECT statement."<br /><br />Any ideas why this happened and how to solve it ?<br /><br />Here are the steps I took that led to the error :<br /> <br />1. In Visual Studio.NET, I created a new Web Forms project<br /><br />2. In Solutions Explorer, I double-clicked on WebApplication1.aspx<br /><br />3. From Server Explorer, I dragged the Student table from the remote SQL Server 2000 database . By doing so, a SQLConnection and SQLDataAdapter object would be automatically created. <br /><br />4. While VS.NET was generating the SQL Statements for the SQLDataAdapter, it showed me the ADO.NET Collaction Conflict error messages for the INSERT, UPDATE and DELETE sql statements.<br /> <br />I tried dragging from my local SQL Server 7 databases and I didn't encounter any of the errors mentioned. <br /><br />Hope somebody can help me.<br /><br />The database's collation is set to SQL_Latin1. I can't see the collations for the tempdb and master databases since I don't have sa privilege on the machine.<br /><br />- Danny<br />