This error indicated that the strings in the join operation are from fields created in different collation. In general, it's better to recreate the fields with the same collation definition, but if you're just too lazy, and want to get things done, just cast to problematic field (in this example it's to 'SQL_Latin1_General_CP1_CI_AS'):
SELECT *
FROM A, B
WHERE A.F1 = B.F1 COLLATE SQL_Latin1_General_CP1_CI_AS
Sunday, July 19, 2009
Monday, July 13, 2009
WordPress & GoDaddy Windows shared hosting
Wordpress works just fine in GoDaddy shared Windows hosting (IIS7), however when trying to install a plugin I get:
Downloading install package from http://downloads.wordpress.org/plugin/XXXXXX.zip.
Warning: touch() [function.touch]: Unable to create file D:\Hosting\XXXXX\html\XXXXXX.com\blog/wp-content/XXXXXX.zip because Permission denied in D:\Hosting\2804923\html\spassets.com\blog\wp-admin\includes\file.php on line 175
Download failed. Could not create Temporary file
Solution: since no solution can be found on the web, I used the good old method - manual install:
* Download the package from wordpress
* Uncompress and upload to /wp-content/plugins (I just copied from another wordpress I have).
And it works!
Downloading install package from http://downloads.wordpress.org/plugin/XXXXXX.zip.
Warning: touch() [function.touch]: Unable to create file D:\Hosting\XXXXX\html\XXXXXX.com\blog/wp-content/XXXXXX.zip because Permission denied in D:\Hosting\2804923\html\spassets.com\blog\wp-admin\includes\file.php on line 175
Download failed. Could not create Temporary file
Solution: since no solution can be found on the web, I used the good old method - manual install:
* Download the package from wordpress
* Uncompress and upload to /wp-content/plugins (I just copied from another wordpress I have).
And it works!
Sunday, July 12, 2009
Web.config & GoDaddy.com
I wrote a small ASP.NET application, which needed to read the web.config file. To open the Web.config file I used 'OpenWebConfiguration':
WebConfigurationManager.OpenWebConfiguration(...)
Since GoDaddy uses medium trust, I kept on getting:
'The application attempted to perform an operation not allowed by the security policy'
And in the detailed:
'System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
The resolution - use ConfigurationManager.ConnectionStrings instead.
WebConfigurationManager.OpenWebConfiguration(...)
Since GoDaddy uses medium trust, I kept on getting:
'The application attempted to perform an operation not allowed by the security policy'
And in the detailed:
'System.Security.SecurityException: Request for the permission of type 'System.Security.Permissions.FileIOPermission, mscorlib, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' failed.
The resolution - use ConfigurationManager.ConnectionStrings instead.
Subscribe to:
Posts (Atom)