Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
techie_guy
Starting Member
3 Posts |
 Posted - 2007-10-29 : 11:24:24
|
| Hi,I have recently moved servers from and also upgraded the version of sql server from 7 to 2000. Having configured the new server on of the sites running on the new server hits a Provider error '80020005' Type mismatch error when attempting a cgi script page. This error has only occured following the server move and I'm wondering if it is collate related? The old server had the following collation ...Unicode data sorting ---------------------- Locale ID = 1033 case insensitive, kana type insensitive, width insensitive Sort Order Description ------------------------------------------------------------------------------------------------------------------------------------ Character Set = 1, iso_1 ISO 8859-1 (Latin-1) - Western European 8-bit character set.Sort Order = 52, nocase_iso Case-insensitive dictionary sort order for use with several We stern-European languages including English, French, and German . Uses the ISO 8859-1 character set. And the new server has Latin1_General_CI_AS.Anyone got a suggestion? I should also point out the other pages work fine.Thanks mark |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-29 : 22:54:25
|
| What's collation for the db on new server? You can change collation for the db. |
 |
|
|
techie_guy
Starting Member
3 Posts |
Posted - 2007-10-30 : 12:32:01
|
| New server collation is Latin1_General_CI_AS |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-30 : 23:29:20
|
| Did you check that db's collation? You can change it with 'alter database' statement. |
|
|
|
techie_guy
Starting Member
3 Posts |
Posted - 2007-10-31 : 17:53:33
|
| Hi yes I have tried to change the collation to a number of different ones but I still get the same error message. This worked fine under IIS 5 on a Win 2000 server. I'm now on Win Server 2003 and IIS 6. Could this be causing it? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-31 : 23:34:12
|
| Keep in mind that new collation works only for data entered after chaning collation, doesn't affect existing data. |
|
|
|
|
|
|
Type Mismatch following server upgrade