|
Developed a simple auto-backup program on my own computer, OS is windowsxp, mail the backup file of sqlserver automatically as an attachment. Everything is alright on my computer, but after I deployed the program on our server, OS is windows server 2003, there is an exception caught, failure sending the mail. I changed the code, I found out that the program is ok on server 2003 for those files which size are smaller than 3MB, more then 3MB, the program will fail to deliver the file.
I have confirmed that there is no problem on the e-mail provider because the program is alright on windowsxp, even the attachment is more then 3MB. I wonder if there are any settings on server 2003 limited the function.
Please help. Many thanks.
|
|
|
|
|
|
I think I find out the solution.
Stop service IIS ADMIN SERVICE.
Then open the file %system%\system32\inetsrv\MetaBase.xml
change the value of ASPMaxRequestEntityAllowed\AspRequestQueueMax\AspBufferingLimit to the size you want(upload\upload\download)
reboot the system and restore iis admin servicem, everything should be ok then.
|
|
|
|
|
A couple of thoughts, I would consider email an unlikely transport method for a backup.
Are you zipping the .bak or using compression on the backup.
I would consider an FTP server a better destination than email. Or even something like Dropbox.
Just some ideas.
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
Thank you for the answer, the problem is server 2003 limited the attachement.
Solution:
Stop service IIS ADMIN SERVICE.
Then open the file %system%\system32\inetsrv\MetaBase.xml
change the value of ASPMaxRequestEntityAllowed\AspRequestQueueMax\AspBufferingLimit to the size you want(upload\upload\download)
reboot the system and restore iis admin servicem, everything should be ok then.
|
|
|
|
|
How does one convert a point (in google spherical mercator) to screen coordinates? Well, 0,0, relative to a tile size cx by cy? I've seen some samples by googling, but none of the formulas seem to work.
|
|
|
|
|
|
Hi, I've made a custom webcontrol that works similar to gridview but with a few extra functionalities. The control works just fine, but my designer is showing 2 issues:
- I can't drag the control from the toolbar to a page, the action isn't allowed for unknown reason.
- I have editable templates. Changing an existing template contents works perfect. However, creating a new template from designer view isn't working(it's not persisting to my pagecode). If I create it manually by typing in the template in code view, there is no issue.
I am overriding following methods of the designer
- GetEditableDesignerRegionContent
- SetEditableDesignerRegionContent
- GetDesignTimeHtml
- GetDesignTimeHtml(DesignerRegionCollection regions)
- GetEmptyDesignTimeHtml
following properties:
- ActionLists
- TemplateGroups
My control inherits from DataBoundControl.
My designer control inherits from DataBoundControlDesigner.
Each template property has following attributes:
[TemplateContainer(typeof(CustomItemsControlItem))]
[TemplateInstance(TemplateInstance.Single)]
[PersistenceMode(PersistenceMode.InnerProperty)]
[DefaultValue(null)]
[Browsable(true)]
[DesignerSerializationVisibility(DesignerSerializationVisibility.Content)]
Am I missing something? If you need code of a specific block, please ask.
|
|
|
|
|
Hi,
My requirement is "By using the web services/WCF of Amazon (and other retailers) I can upload products on Amazon (and other sites) in bulk.".
I done google. read http://docs.developer.amazonservices.com and other articals on different website, but unable to find anything that I can use or understand how to use them.
one more thing for sample application(using Amazon WCF/WS), Is it must to register on Amazon with your "CREDIT CARD DETAILS".
if you know some good articals on it plz provide links.
Thanks in advance.
modified 21-Apr-14 5:24am.
|
|
|
|
|
hi i found http://www.seesharpdot.net/?p=157[^]. it is about How to get album, dvd, and blueray cover art from Amazon. it is not what i am looking for, but helpful in understating "how to start working with Amazon APIs".
|
|
|
|
|
I will have a couple of methods that are called to mark records as deleted:
public DeleteByAddressIdResponse DeleteByAddressId(int Id)
{
Func<ClientAddressEntity, bool> whereClause = ca => ca.AddressId == Id;
return deleteClientAddresses<DeleteByAddressIdResponse >(whereClause);
}
public DeleteByAddressTypeIdResponse DeleteByAddressTypeId(int Id)
{
Func<ClientAddressEntity, bool> whereClause = ca => ca.AddressTypeId == Id;
return deleteClientAddresses<DeleteByAddressTypeIdResponse >(whereClause);
}
public DeleteByClientIdResponse DeleteByClientId(int Id)
{
Func<ClientAddressEntity, bool> whereClause = ca => ca.ClientId == Id;
return deleteClientAddresses<DeleteByClientIdResponse >(whereClause);
}
I'm trying to create a where clause for a Linq To Sql query. I'm not sure how to apply there where clause.
private T deleteClientAddresses<T>(Func<ClientAddressEntity, bool> whereClause) where T : _ResponseBase
{
var response = (T)Activator.CreateInstance(typeof(T));
using (var dc = getDataContext())
{
var entities = (from ca in dc.ClientAddresses select ca);
foreach (var entity in entities)
{
var deleteAddressResponse = DeleteAddress(entity.AddressId);
if (deleteAddressResponse.Result == Result.Success)
{
entity.IsDeleted = true;
try
{
dc.SubmitChanges();
}
catch (Exception e)
{
response.Exception = e;
break;
}
}
else
{
response.Exception = deleteAddressResponse.Exception;
}
}
}
return response;
}
Thanks
If it's not broken, fix it until it is
|
|
|
|
|
You need to call the Where extension method[^] using the method syntax instead of the query syntax.
However, since you're using a Func<T, bool> to filter the records, the filter cannot be translated to a SQL query. As a result, all records will be loaded into memory before being passed to the filter to see if they match. If you change your code to use an Expression<Func<T, bool>>, the filter will be passed to SQL, and only the matching records will be returned.
You can also avoid the Activator.CreateInstance call by adding the new() constraint to your generic type parameter.
private T deleteClientAddresses<T>(Expression<Func<ClientAddressEntity, bool>> whereClause) where T : _ResponseBase, new()
{
var response = new T();
using (var dc = getDataContext())
{
var entities = dc.ClientAddresses.Where(whereClause);
foreach (var entity in entities)
{
...
}
}
return response;
}
public DeleteByAddressIdResponse DeleteByAddressId(int Id)
{
Expression<Func<ClientAddressEntity, bool>> whereClause = ca => ca.AddressId == Id;
return deleteClientAddresses<DeleteByAddressIdResponse>(whereClause);
}
public DeleteByAddressTypeIdResponse DeleteByAddressTypeId(int Id)
{
Expression<Func<ClientAddressEntity, bool>> whereClause = ca => ca.AddressTypeId == Id;
return deleteClientAddresses<DeleteByAddressTypeIdResponse>(whereClause);
}
public DeleteByClientIdResponse DeleteByClientId(int Id)
{
Expression<Func<ClientAddressEntity, bool>> whereClause = ca => ca.ClientId == Id;
return deleteClientAddresses<DeleteByClientIdResponse>(whereClause);
}
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Great suggestions. Thanks.
So now I have another problem. I have:
public DeleteByAddressIdResponse DeleteAllClientAddressesByClientId(int Id)
{
Expression<Func<ClientAddressEntity, bool>> whereClause = ca => ca.AddressId == Id;
var response = deleteClientAddresses<DeleteByAddressIdResponse >(whereClause);
return response;
}
and
private T deleteClientAddresses<T>(Expression<Func<ClientAddressEntity, bool>> whereClause) where T : _ResponseBase, new()
{
var response = new T();
using (var dc = getDataContext())
{
var entities = dc.ClientAddresses.Where(whereClause);
foreach (var entity in entities)
{
}
}
return response;
}
I'm getting
'System.Data.Linq.Table<Falcon.DAL.Data_Context.ClientAddress>' does not contain a definition for 'Where' and the best extension method overload
I installed system.linq.dynamic[^], which I thought would fix it, but no luck.
If it's not broken, fix it until it is
|
|
|
|
|
Make sure you've got a reference to the System.Core assembly, and using System.Linq; at the top of your file.
Also, your types don't match. The error message reports a type of ClientAddress, whereas your predicate is looking at a type called ClientAddressEntity. You'll need to change the filters to be Expression<Func<Falcon.DAL.Data_Context.ClientAddress, bool>>.
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
Same error.
And, even after adding a ref to System.Core, in the DAL code Core' is not found in System namespace.
This is bizarre.
If it's not broken, fix it until it is
|
|
|
|
|
Sorry, I just spotted that your types don't match and updated my answer. Your filters are looking at the ClientAddressEntity type, whereas your table contains ClientAddress objects.
Your filters need to be:
Expression<Func<Falcon.DAL.Data_Context.ClientAddress, bool>>
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
That did it!
Many thanks
If it's not broken, fix it until it is
|
|
|
|
|
i have codin knap sack on c # and exe file
|
|
|
|
|
Leave it round the back. I'll pick it up in the morning.
|
|
|
|
|
Do not repost - it's rude, it wastes time, and it annoys people.
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
|
It's the haiku version! 
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
Do you have a question?
There are only 10 types of people in the world, those who understand binary and those who don't.
|
|
|
|
|
i have coding knap sack in c# and exe file
|
|
|
|
|
But the elephant flies at midnight.
Yuri, is that you? Do you have the microfilm?
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
