Help! I can't view my tables in ADP

[Graham Payton]

Help!!!


All of a sudden I can't view my tables from within my ADP anymore. They are
there, but when I double click them I get the following error:

"ADO error: Cannot resolve collation conflict for column 2 in SELECT
statement"

I have tried restoring both backups for the ADP and the SQl database, but it
still keeps happening. The database seems to be OK as I can still run
select queries on the tables from within Query Analyser.

Can anyne help me out here please?

Thanks in advance


Graham

 

[Graham Payton]

Just in case anyone else ever gets this problem, I have sorted it out now.

Basically the original PC where SQL was installed had been set up with the
wrong SQL server collation. So when the database was moved to another
server, with a different collation, this error occured.


Graham