Unicode data in a Unicode-only collation...

[CRoberts]

I have installed Actual ODBC connectors and setup a System DSN to a MS SQL 2000 server.

It works because I can see the schema as shown in SQL Manager on the server itself. I have managed to retrieve a limited amount data from some tables but these do not hold the information I want.

When I browse the tables of interest only one record is displayed and all the fields contain a message:

"ODBC Error: [Actual][sql SErver] Unicode data in a Unicode-only collation or ntext data cannot be sent to clients using DB-library (such as ISQL) or ODBC version 3.7 or ealier."

Anyone come across this before or got a suggestion for might be the problem?

Using Actual ODBC 2.8 with FM Pro 9.0.2 under 10.5.1.

Cheers