Error Type:

Microsoft OLE DB Provider for SQL Server (0x80004005)

Warning: sort order 52 in database differs from server sort order of 82.

/database/connect.asp, line 18



Can error 80004005 have something to do with permission settings?



I am logged in as an admin   



Thanks for any help



Oskar

No, this isn't a security thing, it's the way your SQL Server was 

installed.  When you install SQL Server, you choose the sort order.  The 

default is Dictionary Sort order, case insensitive.  Sort order basically 

determines how data is sorted when you use GROUP BY, ORDER BY and DISTINCT 

clauses.  The sort order on the server is very important, you won't be able 

to use any data from a server with any other sort order.  The only way to 

change this is to totally reinstall SQL.  I'm guessing you got this 

database from a different server?



Shawn





On 05/04/00, "Oskar Kaszubski" wrote:

> Error Type:

Microsoft OLE DB Provider for SQL Server (0x80004005)

Warning: sort order 52 in database differs from server sort order of 82.

/database/connect.asp, line 18



Can error 80004005 have something to do with permission settings?



I am logged in as an admin   



Thanks for any help



Oskar