Showing posts with label iis. Show all posts
Showing posts with label iis. Show all posts

Tuesday, March 20, 2012

change date format from MMDDYYYY to DDMMYYY ?

Hi,
My report dates are coming out in the following format MM/DD/YYYY. How can I
change this to DD/MM/YYYY.
i.e is this to do with IIS, reporting services or the report itself ?
(machine is DD/MM/YYY)
Thanks
Scottscott wrote:
> Hi,
> My report dates are coming out in the following format MM/DD/YYYY.
How can I
> change this to DD/MM/YYYY.
> i.e is this to do with IIS, reporting services or the report itself ?
> (machine is DD/MM/YYY)
> Thanks
> Scott
In tools/options set International Settings to be same as Microsoft
Office.
Find Report object on the Properties window dropdown and set the
Language property to English (UK)
This should now allow you to set the format of the textbox to
dd/mm/yyyy or similar. (Go to property pages for some default options -
right click text box and go to properties.)|||thanks
scott

Friday, February 24, 2012

CE10 - internal error - secLdap plugin

Hello

After installing the CE10 SDK on our IIS Server my program generates a CR report but only about 50% of the time - the error I get (which occurs when the program attampts to logon to the CE10 server) is :-

"An internal error has occurred in the secLdap plugin."

Our templates reside on a CE10 server. Another server contains our SDK and the code that calls the API. Has anyone received this before or does anyone have any ideas ?

My code to logon is as follows :-

SessionMgr ceSessionmgr = null;
EnterpriseSession ceSession;
Response.Expires = 0;
ceSessionmgr = new SessionMgr();
//Get username
user = Request.ServerVariables.Get("HTTP_PROXY_REMOTE_USER");
//Get password/token
password = Request.ServerVariables.Get("HTTP_LDAPTOKEN");
apsName = "NYITDCED001";
string apsAuthType = "secLDAP";
ceSession = ceSessionmgr.Logon(user, password, apsName, apsAuthType);

ceSessionmgr.Dispose();
ceSessionmgr = null;
ceSession.Logoff();
ceSession.Dispose();
ceSession = null;
...
...
...I have not received a reply to this so I am posting in "Business Objects:Crystal Enterprise"|||I have not received a reply to this so I am posting in "Business Objects:Crystal Enterprise"
Good. Hope you find the solution :)

Sunday, February 19, 2012

cdonts send mail T-SQL - IIS SMTP setup

hello,

I would like to send mail from sql server using CDONTS.

I have the sql code for this and it works for internal addresses.

I get an error/warning saying that it cannot relay for external addresses when I try an outside domain.

Is there settings in IIS for the SMTP service that I can change to allow it to relay to the external domains?

I have everything running on the SQL Server, and I do not have access to the exchange server.

ThanksCDONTS sends email to the Local SMTP server. You can specify a "smart host" that the local server can forward any email it can't deliver.

Search the help for the IIS SMTP Virtual Server. It's likely the network blocks any unapproved system from using the smtp port, and it's also likely the approved ones will need to allow your system to relay through them.

Jay Grubb
Technical Consultant
OpenLink Software
Web: http://www.openlinksw.com:
Product Weblogs:
Virtuoso: http://www.openlinksw.com/weblogs/virtuoso
UDA: http://www.openlinksw.com/weblogs/uda
Universal Data Access & Virtual Database Technology Providers