West Wind Message Board Messages

Re: Sending email from WebConnection

Russell Campbell — Fri, 9 May 2008 16:10:02 GMT

Re: Sending email from WebConnection

Web Connection

Re: Sending email from WebConnection

From:	Russell Campbell
To:	Marty Cantwell
Attachments:	None

05/09/2008
09:10:02 AM
2D60JNCVF

Yeah, spammers cause lots of direct and indirect problems, for sure. This web hosting provider is doing the POP-before-sending thing. But the client has had a bunch of problems with delayed email. Also, they set up an email account for this task and I sent three emails to it yesterday and never got anything. I did finally get a bounce-back today. I had the correct email address and the account seems to work - I can log in and see it - but nothing is getting to it. Overall, I think their hosting provider is doing a pretty poor job, so for the moment I am still using my provider.

I guess I can do the POP-before-sending with some command or tool, though I've never done that before. It would slow down the overall process and I might want to move it to an asynch process. And I'd need to do it every time, I guess, because their "window" is 30 minutes. Rather than trying to keep track of when the last time I jumped through that hoop was, it'd probably be easier and more reliable to do it each time before sending email.

Thanks for your reply

Due to the explosion of SPAM offenders today, most mail server admins have been forced to take drastic measures to protect their mail servers and users from this onslaught of abuse. That is probably why there are issues showing up when using a client's email server in your apps.

That makes using a local SMTP server seem pretty much the way to go. However, there are a few issues you'll run into with that too! Many mail admins have configured their mail servers to now reject mail if there is no reverse DNS entries for an SMTP server attempting to connect to it. That one thing will usually sink you right off the bat, especially if you are behind a firewall not using NAT (and/or have an ISP who does not configure their DNS properly --- a surprising number of them!).

Another thing that will get you here is if you're SMTP server connects to the target SMTP server and tries to send a message with a FROM: header that has a different domain name than the domain of your SMTP server. Most servers these days are configured to abort the connection to your server. In some cases, they may tarpit your IP address or Domain Name for a period, not allowing any more connections at all while you are tarpitted.

IMHO you are much better off utilizing the customer's SMPT server and using a FROM: email address which is valid on their domain. As you pointed out, any address could be placed into the REPLY TO: header without problems. You do have other issues to worry about such as providing AUTH credentials if needed, or perhaps needing to POP-before-Sending messages (a popular security measure which prevents unauthorized relaying of messages).

Hope this information helps,

Marty

Russell Campbell

Re: Sending email from WebConnection

Marty Cantwell — Fri, 9 May 2008 15:47:20 GMT

Re: Sending email from WebConnection

Web Connection

Re: Sending email from WebConnection

From:	Marty Cantwell
To:	Russell Campbell
Attachments:	None

05/09/2008
08:47:20 AM
2D60IU5LI

Hey Russell,

I tend to use my email server at my web host for sending email from web apps. It's been no problem. However, when using a client's email server, it's been more of a problem. They have some restrictions. So I'm wondering if it's really just better to send via the built-in SMTP server. I suppose it doesn't matter where it gets sent from. The reply address will be such that any replies will go back to the appropriate recipient and not back to the SMTP server that I sent from. I guess I just had a mindset that was "send and receive from the same server" . . . but it probably doesn't matter. I also was wanting to shut down that built-in SMTP server to - hopefully - reduce attack vectors. But that may not be a big issue, either (assuming all security updates are applied, open relaying is prevented, etc.). So what's the more common way? Use the built-in SMTP server or an external one. What are the pros and cons to each approach?

Hope this information helps,

Marty

Russell Campbell

Custom Softworks

wwSOAP - Am I even using it correctly?

Jay Johengen — Fri, 9 May 2008 15:44:02 GMT

wwSOAP - Am I even using it correctly?

FoxPro Programming

wwSOAP - Am I even using it correctly?

From:	Jay Johengen
To:	All
Attachments:	None

05/09/2008
08:44:02 AM
2D60IPX6J

I am getting an error in the following code that lvResult is .F. and the cErrorMsg is "Non xml result returned." Does this imply that I'm at least getting into the method on the server? The TextRequestMessage is an ANSI formatted eligibility message. I did not include it here as it is fairly long.

lcURL = "https://teligibility.transactions.mckhboc.com:5002/Realtime/services/realtime?submitRealtimeRequest"
oSOAP = CREATEOBJECT("wwSOAP")
oSOAP.AddParameter(TextRequestMessage)
lvResult = oSOAP.CallMethod("submitRealtimeRequest",lcURL)
IF oSOAP.lError
MessageBox(oSOAP.cErrorMsg)
RETURN
ENDIF

Sending email from WebConnection

Russell Campbell — Fri, 9 May 2008 14:40:42 GMT

Sending email from WebConnection

Web Connection

Sending email from WebConnection

From:	Russell Campbell
To:	All
Attachments:	None

05/09/2008
07:40:42 AM
2D60GGHC4

Russell Campbell

Data entry via text messages

Russell Campbell — Fri, 9 May 2008 13:44:44 GMT

Data entry via text messages

Web Connection

Data entry via text messages

From:	Russell Campbell
To:	All
Attachments:	None

05/09/2008
06:44:44 AM
2D60EGHXF

Anybody done data entry via text messages? I have a situation where workers need to indicate if they are available that day. It occurred to me that if they could text a code to a specific number, then code 12341 could indicate they were available and 12342 could indicate they were unavailable (or something simple like that - nnnn is the "person code" and the trailing 1 is available, 2 being unavailable). Then I could text them back with a confirmation. I'll bet it can be done and has been done. Anybody here done something like that?

Russell Campbell

Re: CPU constant at 50%

Rogier Knipscheer — Fri, 9 May 2008 08:53:32 GMT

Re: CPU constant at 50%

West Wind Web Store

Re: CPU constant at 50%

From:	Rogier Knipscheer
To:	Richard Norris
Attachments:	None

05/09/2008
01:53:32 AM
2D60420W5

Hi Richard,

i'm using windows server 2003 and foxpro 9 sp1, no extra code in the server polling operation. It is a 32bit machine and i have no Anti-Virus software running.

Rogier

Hi Rogier

I gather with your dual core 50% is actually equivilent to 100% usage on a single CPU. Are you running any extra code in the server polling operation? What version of VFP are you using and what version of the OS? Are you running on a 32bit or 64bit machine? What Anti-Virus you using? Some more details may help here.

I've got no solid suggestions at the moment unfortunately. Based on the answers to above and what you've done already I suggest you look for any VFP runtime issues with CPU and OS versions, make sure your Anti-Virus isn't intefering and make sure that (if your running on a 64bit CPU) that there is no issue with VFP under WOW64.

Switching to COM is a good idea for performance and should be used for a production server anyway. The file mode was really only designed for debug purposes but we are all guilty of this sin (even Rick knows it <g>). There is no gaureentee switching to COM at this stage will resolve this problem. Switching to COM may make it difficult to identfy too. I'm not saying don't try it but it may be a work up to no resolution, someone may say different. I always like to know what an issue is but despite this I do agree that this has to be left at some point if it takes too long to identify.

Regards

Richard

Hi all,

i've seen in the previous threads that i'm not the first with this problem, but i haven't found a solution in the answers. Here's my problem:
while surfing over my website, from time to time a click on a hyperlink does not react. When i check WWC i see the respons within a tenth of a sec, but in the iis log it doesn't show. I contacted my hardware supplier and he thinks the problem is caused by my cpu wich is constant over 50%.

When i start up wwc, it goes immediate to 50 without any transactions.

I tried all the things i found on this forum, cleared the temp files, reindexed tables, packed them, restarted iis, rebooted the server. When i run the wws on my own laptop, with all open processes, cpu does not exceed 4%. I even tried to install it on another server. Same thing, not over 4%.

The liveserver i have is new with a dual core processor and 1gig mem.

I'm thinking of switching to COM, but could this make any difference if this problem is unknown?

Rogier

Re: CPU constant at 50%

Rogier Knipscheer — Fri, 9 May 2008 08:45:36 GMT

Re: CPU constant at 50%

West Wind Web Store

Re: CPU constant at 50%

From:	Rogier Knipscheer
To:	Rogier Knipscheer
Attachments:	None

05/09/2008
01:45:36 AM
2D603RTBI

In addition to my previous message....

I also got the OLE ERROR MONIKER COULD NOT OPEN.... message when i was creating the project. So i had to do it manually. I am very sure IIS is running (i have a live website) and that i have administrator rights.
When i try setting up dcom using the wizzard and i click the add button i also get this message. When i start the debugger i'm in the configureserver procedure in the createdcomgridcursor, the only code i see is 'source is not found'...

Hi all,

When i start up wwc, it goes immediate to 50 without any transactions.

The liveserver i have is new with a dual core processor and 1gig mem.

I'm thinking of switching to COM, but could this make any difference if this problem is unknown?

Rogier

Re: CPU constant at 50%

Richard Norris — Fri, 9 May 2008 08:38:42 GMT

Re: CPU constant at 50%

West Wind Web Store

Re: CPU constant at 50%

From:	Richard Norris
To:	Rogier Knipscheer
Attachments:	None

05/09/2008
01:38:42 AM
2D603IXNO

Hi Rogier

Regards

Richard

Hi all,

When i start up wwc, it goes immediate to 50 without any transactions.

The liveserver i have is new with a dual core processor and 1gig mem.

I'm thinking of switching to COM, but could this make any difference if this problem is unknown?

Rogier

CPU constant at 50%

Rogier Knipscheer — Fri, 9 May 2008 08:08:10 GMT

CPU constant at 50%

West Wind Web Store

CPU constant at 50%

From:	Rogier Knipscheer
To:	All
Attachments:	None

05/09/2008
01:08:10 AM
2D602FOLH

Hi all,

i've seen in the previous threads that i'm not the first with this problem, but i haven't found a solution in the answers. Here's my problem:
while surfing over my website, from time to time a click on a hyperlink does not react. When i check WWC i see the respons within a tenth of a sec, but in the iis log it doesn't show. I contacted my hardware supplier and he thinks the problem is caused by my cpu wich is constant over 50%.

When i start up wwc, it goes immediate to 50 without any transactions.

The liveserver i have is new with a dual core processor and 1gig mem.

I'm thinking of switching to COM, but could this make any difference if this problem is unknown?

Rogier

How to kill your app

Stein Goering — Fri, 9 May 2008 06:54:10 GMT

How to kill your app

Web Connection

How to kill your app

From:	Stein Goering
To:	All
Attachments:	None

05/08/2008
11:54:10 PM
2D51F7Q5R

It appears you can hang any standard WC app by calling routerequest.xxx where xxx is your script map extension. Since routerequest is a process class method, it tries to route to itself, triggering a recursive loop until it hits the nesting limits.

The fix is to edit the base class method in wwprocess.prg and add it to the list of disallowed methods

*** Add any 'invalid' method calls here
CASE "," + lcScriptName + "," $ ",process,init,destroy,routerequest,"

Rick, can you make this change to the production code?

--stein

Pass a PDF from VFP COM to a .Net Web Service

Jon Goad — Thu, 8 May 2008 21:27:13 GMT

Pass a PDF from VFP COM to a .Net Web Service

Web Development with Visual FoxPro

Pass a PDF from VFP COM to a .Net Web Service

From:	Jon Goad
To:	All
Attachments:	None

05/08/2008
02:27:13 PM
2D50UZ8GB

Hello,

I have a VFP web service, and to get away from the SOAP Toolkit (as Rick recommended in his excellent article, "Calling and Hosting FoxPro Web Services through .Net"), I am in the process of writing a .Net web service that will simply act as a pass-through to my VFP COM object.

One of the methods of my COM object creates a PDF with XFRX, uses FileToStr() to convert the PDF to a string, and then uses CreateBinary to return the PDF through the web service (from another of Rick's articles about PDF Reports on the web). In order to return the binary string through my VFP web service, I had to manually hack the WSDL file created by the VFP web services publisher to specify the return type as base64binary, since that type is not inherently supported.

In the past, I've used an ASP page to access this web service method and used Response.BinaryWrite() to display the PDF in a web browser. My question is this: How do I return the Binary String from my VFP COM object to the .Net web service, and then return that to the calling client? I think I need to specify the return type of my .Net web method as a byte array (byte[]), but I cannot specify the return type of my VFP COM method as the same (since that type is not supported in VFP), which causes a compile error in .Net (Cannot implicitly convert type 'string' to 'byte[]'). If I try specifying the type as 'string' in both my VFP COM object and in my .Net WebMethod, that gives an error in the browser (System.InvalidOperationException: There was an error generating the XML document. ---> System...).

Any help would be greatly appreciated.

Thanks,

Jon

Visual Studio 2008 Integration failed

Frank Ruecker — Thu, 8 May 2008 19:11:57 GMT

Visual Studio 2008 Integration failed

HTML Help Builder

Visual Studio 2008 Integration failed

From:	Frank Ruecker
To:	All
Attachments:	None

05/08/2008
12:11:57 PM
2D50Q5ASN

I have enabled the HTML Help Builder Add-In for Visual Studio 2008. But during the next startup of Visual Studio 2008 I receive an error message that the Add-In could not be loaded. Error Message is Invalid Argument, Error Code 80070057. What went wrong?

Re: Wizard Error

RostyVygovsky — Thu, 8 May 2008 18:06:15 GMT

Re: Wizard Error

West Wind Web Store

Re: Wizard Error

From:	RostyVygovsky
To:	Rick Strahl
Attachments:	None

05/08/2008
11:06:15 AM
2D50NSSX7

Hi Rick!

I installed WC version 5 (which we purchased a while ago, but decided at that point to say with version 4.68) and now install went through without any problems (I downloaded the latest 5.35 version of WWC). What I am seeng now, though, is when I try to run the Web Store - everything works fine, but if I go to "All Products" - page 3 and click on "Web Connection T-Shirt" item it displays < %= InsertSubItemList() % > markup under "Select a color and size: ", although further down I see two drop down controls "Please select a size:" and "Please select a color: ". What might be causing the < %= InsertSubItemList() % > to show up there?

Please advise.

Thanks

The store is designed for Web Connection 5.0 - I don't believe it will work for 4.x as there are some dependencies on Version 5.x... earlier version 3.x work with 4.x...

+++ Rick ---

Hi Rick!

We purchased a Web Store version 3.50 a few days ago and I am trying to use it with WWC 4.68. I am getting errors "File not found" and "Varialbe LCTEMPLATE not found" when running the setup wizard. I made sure that the default directory in VFP settings points to Web Connection root folder and then double-checked the SET ("PATH") settings - it points to the Web Connection subfolders. Could it be that modifying setup for latest version of WWC you had something broken when instal is done on WWC 4.68?

Please advise.

Thanks.

Hi Christian,

Ok, so I checked this out and I found the issue.

Recent versions of Web Connection have moved around some of the template files a bit and so one of the templates is not being found. Specifically the Default.Htm template is gone missing in the templates directory.

I've updated the setup program and also fixed a couple of other related issues (template rendering defaults have changed).

Just re-download the full package and re-copy the files from the zip file...

Let me know how it goes, but looks like it goes through now smoothly...

+++ Rick ---

Webconnection 5.331 & Webstore for Webconnection 350

Setting up new web connection projects works fine, but the web store does not. I get the errors stated in the initial messages.

Also, after trying to resolve, the web store does not put the DLL's in the bin directory (i.e. "C:\Inetpub\wwwroot\wwstore\bin"), and even though I use "WS_" for the "c:\temp\wc" directory, the web store still outputs the "WC_" extension, which is why the demo server picks up the files and tries to process. It seems because the DLL's are not in the wwstore root directory, it is hitting the C:\Inetpub\wwwroot\wconnect\bin DLL, which has the "WC_" extensions. I guess I could change the Main, web connect file to read WS_ extensions or change web store to output WC_.

I verified that the web store .ini files all have "ws_". The webs tore remains idol and never reads anything. I had this problem in the past, but never really used the web store with the higher versions of web connection.

I have uninstalled and reinstalled Web connection and web store multiple times and get the same result.

Web Store also doesn’t appear to have the hooks into .net. Is there a way to register the DLL's in the bin directory so I can use the dot .net framework... Guess I am getting ahead of myself.:)

Thanks in advance for the help.

What version of Web Connection are you running? And can you verify that you are indeed starting out of the Web Connection install directory? (check by typing CD) and that the stock Web Connection directories (Templates/Scripts) exist below this install path...

The Web Store depends on these install files.

+++ Rick ---

Did everything the help file indicated to set up the web store

Start the Web Store setup program start VFP in your Web Connection directory (using the standard Web Connection shortcut). Then type the following into the command window:
CLEAR ALL
CLOSE ALL
DO WWSTORE_SETUP

I just clicked all the defaults provide by the web store wizard. When I clicked “finished”, the error(s) below come up. The other errors in the initial email also occurred.

File dose not exisit....(1)

After I rebuild the application and run, the http://localhost/webstore just hangs and never serves the page, nor does the app find the page to process. If i run the demo server, it finds the ws_ files in the temp folder and processes but can't find the programs to dispaly because it is the wrong webconnection server.

Christian,

You need to run the installation out of the Web Connection install program. The store needs to be installed in the Web Connection root folder...

+++ Rick ---

Keep getting the following errors when I try to install the Webstor for Webconnection

Wizard Error: Variable 'lcptemplate' is not found....(12)

File c:\wconnect\templates\admin.asp does not exist

File c:\wconnect\templates\westwind.css does not exist

It appears the newest version of web connection has a differnt directory struture... we should I make the change for webstore to find the files?

Re: Access to Registry Denied Building EXE Under V

Richard Norris — Thu, 8 May 2008 13:26:02 GMT

Re: Access to Registry Denied Building EXE Under V

FoxPro Programming

Re: Access to Registry Denied Building EXE Under V

From:	Richard Norris
To:	Randy Pearson
Attachments:	None

05/08/2008
06:26:02 AM
2D50DSFQ2

Randy,

FYI, here is a list of a set of five part blog entries from the SPS weblog. This information is invaluable on this topic:

PE Files, UAC, Reg-Free COM and Other Crazy Stuff - Part 1

PE Files, UAC, Reg-Free COM and Other Crazy Stuff - Part 2

PE Files, UAC, Reg-Free COM and Other Crazy Stuff - Part 3

PE Files, UAC, Reg-Free COM and Other Crazy Stuff - Part 4

PE Files, UAC, Reg-Free COM and Other Crazy Stuff - Part 5

HTH

Richard

Hi Richard,

That's all very interesting. Thanks for posting. I assume the Reg Free COM aspect only applies to Vista and newer OS--IOW, it would not help avoid regserver on Win 2003 Server?

-- Randy

Anyhow, you can hack your exe to add/update this manifest. Two example advantages of doing this are as follows:

1) Reg Free COM - This is a feature where you can store COM object registation details directly into the manifest and not in the Windows Registry. This means you can ditribute COM components with your application without ever needing to register them explicitly with Windows. I've tried this and it works wonderfully.

2) Request Administrative Privileges - Vista now forces applications to request Admin priviledges to perform some sensitive system tasks. This is the annoying (but neccessary) dialog that pop's up everytime you do something that needs Admin rights (i.e change system time). There are ways to manually fire this up but for an application to force this request it needs the request it via it's exe manifest. Adding this to your VFP application exe will cause this dialog to appear when your app is run. (Not best practice but good for utility apps)

Calvin Hsia has blogged about this and posted some sample VFP code to modify your VFP compiled executables to add this manifest.

http://blogs.msdn.com/calvin_hsia/archive/2007/04/13/add-a-manifest-to-control-your-application-vista-uac-behavior.aspx