Error -- what could this be?

Topics: Developer Forum
Aug 5, 2013 at 7:56 PM
Server Error in '/cfoxtow_web8V8' Application.

Creating an instance of the COM component with CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} from the IClassFactory failed due to the following error: 80004005.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Creating an instance of the COM component with CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} from the IClassFactory failed due to the following error: 80004005.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[COMException (0x80004005): Creating an instance of the COM component with CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} from the IClassFactory failed due to the following error: 80004005.]
AVFPHandler.ProcessRequest(HttpContext context) +58
AVFPHandler.OnInit(EventArgs e) +20
System.Web.UI.Control.InitRecursive(Control namingContainer) +333
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +378

Version Information: Microsoft .NET Framework Version:2.0.50727.5466; ASP.NET Version:2.0.50727.5456
Coordinator
Aug 5, 2013 at 9:28 PM
Has it been working up until this error or are you just trying this as a new application or on a different server? It sounds like it's not allowed to call a COM server which would point to not having Full Trust implemented.
Aug 6, 2013 at 3:46 AM
I don't know what to do to fix it, been fighting with it all day. Hours and hours. I thought it was my code, but I don't think it is now because
sometimes the same piece of code gives me the errors and sometimes it does not. What do I do?
Aug 6, 2013 at 3:47 AM
How do I reinstall and get the same folders? or what do I delete and redo?
Coordinator
Aug 6, 2013 at 8:11 AM
For uninstalling, the key thing is to delete the virtual directory '/cfoxtow_web8V8'. Then just install again.
Aug 6, 2013 at 9:17 AM
Ugh... bummer... I don't know what to do... I've tried everything and the error wont go away.

ok, well tomorrow I'll try again.
Aug 6, 2013 at 9:44 AM
    lcHTMLout= FILETOSTR(oProp.HtmlPath+lcHTMLfile) ------------------ this is the line 67

Caught .NET exception, source: MAIN.PRG 00006mg9000a err#= 1 line= 67 File does not exist.1 File does not exist. .NULL. .NULL. .NULL. .NULL. .NULL. c:\foxtow_web9\activevfp.dll message: c:\foxtow_web9\activevfp.dll

still trying.

This is a new error.
Aug 6, 2013 at 9:50 AM
Server Error in '/cfoxtow_web9V' Application.

Creating an instance of the COM component with CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} from the IClassFactory failed due to the following error: 80004005.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Creating an instance of the COM component with CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} from the IClassFactory failed due to the following error: 80004005.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[COMException (0x80004005): Creating an instance of the COM component with CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} from the IClassFactory failed due to the following error: 80004005.]
AVFPHandler.ProcessRequest(HttpContext context) +58
AVFPHandler.OnInit(EventArgs e) +20
System.Web.UI.Control.InitRecursive(Control namingContainer) +333
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +378

Version Information: Microsoft .NET Framework Version:2.0.50727.5466; ASP.NET Version:2.0.50727.5456
Aug 6, 2013 at 10:04 AM
Server Error in '/avfp' Application.

Creating an instance of the COM component with CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} from the IClassFactory failed due to the following error: 80004005.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Creating an instance of the COM component with CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} from the IClassFactory failed due to the following error: 80004005.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[COMException (0x80004005): Creating an instance of the COM component with CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} from the IClassFactory failed due to the following error: 80004005.]
AVFPHandler.ProcessRequest(HttpContext context) +58
AVFPHandler.OnInit(EventArgs e) +36
System.Web.UI.Control.InitRecursive(Control namingContainer) +140
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +480

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1008
Aug 6, 2013 at 10:06 AM
Ok, ITS On the new server now -- the community server.

http://54.215.18.104/avfp/master2d/465971

many combinations of files cause the problem
http://54.215.18.104/avfp/master2/465972

inside controllers folder.
Coordinator
Aug 6, 2013 at 2:01 PM
Edited Aug 6, 2013 at 2:07 PM
My guess is the IIS/.NET framework is messed up in some way. So I'm re-installing.

When I first got onto this server I had to do some manual things just to see that ASP.NET was not installed. Then I installed that from the console. So I'm thinking that something got hosed installing this combination of things. Starting from scratch will help I hope.

We pretty much never see this sort of error ever, even at places like GoDaddy.
Aug 6, 2013 at 5:50 PM
maybe you could ad me on skype today Claude and we could try to figure this out.
I re-installed .net on the server, where you had left off...

'foxtowsupport' is my skype name.

Mike
Coordinator
Aug 6, 2013 at 6:00 PM
I actually wanted to install the web server without a previous .NET installation to let IIS install whatever it needed regarding .NET.

But maybe this will work. Next step is to install the Web Server. And then ASP.NET from the Features panel. I can do this.

Regarding Skype and stuff, I don't want to sink too much time into this because I need to earn money to pay bills.

If none of this works, I'm going to install AVFP on my Amazon "Free Tier" Service and see how that goes.
Coordinator
Aug 6, 2013 at 10:55 PM
If you want to do the regular AVFP install now, you can. I re-installed everything with IIS and ASP.NET.

Hopefully it will work. If it doesn't I'll try it on my AWS "free tier" service I recently got.
Aug 6, 2013 at 11:06 PM
sadly I don't think this is the problem because it failed on MY local
machine and on the server. That's two places.

I will try however.


Coordinator
Aug 6, 2013 at 11:47 PM
Well it works fine for everyone else so I'm not sure what the problem is or what your doing.

Let us know if it works or not and give the URL.
Coordinator
Aug 7, 2013 at 2:03 AM
Ok, it's working again with NO ERRORS.

The demo link is: http://54.215.18.104/avfp/default.avfp

and here is the GetEmployees example:

http://54.215.18.104/avfp/customers/getemployees

Also http://54.215.18.104/avfp/customers/info shows where the controller is on disk


If you do something and get that error again, let us know. Right now no errors and everything is running smoothly.
Aug 7, 2013 at 2:54 AM
Error still there.
http://54.215.18.104/avfp/master2d/465973


Server Error in '/avfp' Application.

Creating an instance of the COM component with CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} from the IClassFactory failed due to the following error: 80004005.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Creating an instance of the COM component with CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} from the IClassFactory failed due to the following error: 80004005.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[COMException (0x80004005): Creating an instance of the COM component with CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} from the IClassFactory failed due to the following error: 80004005.]
AVFPHandler.ProcessRequest(HttpContext context) +58
AVFPHandler.OnInit(EventArgs e) +36
System.Web.UI.Control.InitRecursive(Control namingContainer) +140
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +480

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1008
Coordinator
Aug 7, 2013 at 3:03 AM
But error not here:


http://54.215.18.104/avfp/customers/getemployees


It's got to be your app.....
Aug 7, 2013 at 3:10 AM
its just foxpro. I sent you the prg. Everything is also on the server.
Coordinator
Aug 7, 2013 at 3:14 AM
I'm not going to fix your program. You need to track down what's causing the problem, not me...

Do it exactly like the Customer Controller. Or use the Customer Controller.

If you pin down a specific problem other than "it's not working", that would help a great deal.
Aug 7, 2013 at 5:19 AM
I'm trying to debug this, and its really not easy because I'm lacking a lot of knowledge.
oResponse.ContentType = "application/json;charset=utf-8"
oResponse.Write(oJSON.stringify('SearchResults'))

oResponse.Flush
These lines are creating a string, that is sent to the JSON parser and brought into my program.
How do I put this into a memo field?

I can't start the FoxPro debugger and try and figure out where your program is going because I don't have access to that.

I want something like
replace field.memo with oresponse.results -- but don't know the syntax because this is web stuff.
Aug 7, 2013 at 5:27 AM
http://54.215.18.104/avfp/master2d/465973

If you RUN THIS --- over and over -- sometimes it will work. Sometimes it will give an error.

THIS is not the way FoxPro behaves.

--------- Result 1 is
Server Error in '/avfp' Application.

Creating an instance of the COM component with CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} from the IClassFactory failed due to the following error: 80004005.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Runtime.InteropServices.COMException: Creating an instance of the COM component with CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} from the IClassFactory failed due to the following error: 80004005.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:


[COMException (0x80004005): Creating an instance of the COM component with CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} from the IClassFactory failed due to the following error: 80004005.]
AVFPHandler.ProcessRequest(HttpContext context) +58
AVFPHandler.OnInit(EventArgs e) +36
System.Web.UI.Control.InitRecursive(Control namingContainer) +140
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +480

Version Information: Microsoft .NET Framework Version:4.0.30319; ASP.NET Version:4.0.30319.1


RESULT TWO (30 SECONDS LATER)
{"master":{"rows":[{"aaacallnum":"","aaamemtype":"","amount":"25","area":"","billtoact":"CCMC","billtoaddr1":"ATTEN CLAIMS DEPARTMENT","billtoaddr2":"P.O. BOX 9139","billtocity":"MEDFORD","billtocont":"LINE#5/EXT 2","billtoname":"CROSS COUNTRY MOTOR CLUB","billtophone":"(800)541-2262","billtost":"MA","billtozip":"02155","bodytype":"","callactnum":"CCMC","callactnum2":"CCMC","callname":"CROSS COUNTRY MOTOR CLUB","callphone":"(951)283-6170-","callremark":"01/02/2012 09:11:04 PM - submitted invoice online//as\r01/01/2012 05:49:49 AM - 2-mtv//mls\r01/01/2012 03:21:17 - spoke to sandra @ccmc for goa//mls\r01/01/2012 03:18:56 - philis @ sht advsd they already changed tire themself/ will call for goa//mls\r01/01/2012 02:51:15 - melanie garcia/ cvrd in full/ tirechange/ sunnyhills doing call/ spoke to philis, tracey will be running call///mls\r","callremark1":"","calltype":"","colorcar":"WHT","condition":"","cross_street":"","curbalance1":"","curtotal1":"","custnum":"CCMC","datein":"/ /","dateout":"/ /","datepaid":"01/04/12","days":"0","description1":"","description2":"","description3":"","description4":"","dispnum":"465973","driver":"RUSTY 02","equipment":"","foxtow_id":"","ftiresize":"","holdnote":"","invdate":"01/01/12","invoicenum":"578735","itemgroup":"I","keysinfo":"","kitnum":"","licensenum":"","licensest":"","liendin":"/ /","liendout":"/ /","lienfee":"0","lientype":"","lientypems":"","lotsection":"","makecar":"VOLVO","mapcord":"","membernum":"","miles":"0","milesto":"0","modelcar":"S60","odometer":"","oldinvnum":"","paytype":"CHG","paytype2":"ATM","perday":"0","perdaytotal":"","ponumber":"458073405","price1":"","price2":"","price3":"","price4":"","priority":"1","quantity1":"","quantity2":"","quantity3":"","quantity4":"","reason":"","referencenum":"ACH ITEM","refnumber":"458073405","regaddr1":"","regaddr2":"","regaddr3":"","regcity":"","regname":"","regnametow":"","regstate":"","regzip":"","releasedate":"/ /","releaselic":"","releasetype":"","release_bywho":"","release_time":"","release_time2":"","retowto":"","rtiresize":"","storagetype":"3","tagmonthyear":"","timeardst":":","timearrive":"03:12","timecall":":","timeclear":"03:21","timeinrt":"02:51","timeintow":":","timerec":"02:51","towdate":"01/01/12","towedfrom":"~GOA///31376 VIA EDWARDO, OSD","towedto":"~TIRE CHANGE","towtagnum":"","trucknum":"13","type":"C","vin":"","whocalled":"","wpositi
Aug 7, 2013 at 5:28 AM
If it was IN MY CODE -- then why would the same exact code work 30 seconds apart ... just based on
the mood the computer is in.

Something is not right.
Aug 7, 2013 at 5:44 AM
____[10:40:23 PM] Adrian Patrascu: sure is not VFP, it is IIS ( .NET interop class ) that loads AVFP

This is not my opinion, its somebody elses.

Coordinator
Aug 7, 2013 at 11:18 AM
This is still working, no intermittent errors:


http://54.215.18.104/avfp/customers/getemployees


It's got to be your app.....
Coordinator
Aug 7, 2013 at 5:08 PM
Edited Aug 7, 2013 at 5:09 PM
Your app is doing something that is corrupting the whole web environment on that server. Kindly use COMRETURNERROR and/or track down the bug you are introducing. You'll probably need to recycle the app pool or do an iisreset to get it back to normal.

We never see this error in production environments so it is most definitely something you're doing.

I'm going to put AVFP up on my Free Tier AWS this weekend and I'm pretty sure I won't be seeing any of these errors. I will also attempt to connect an appery.io app to it as well.
Coordinator
Aug 7, 2013 at 5:34 PM
The next thing I'll try on your server is put the AVFP demo app in a separate App Pool from yours to separate it from whatever it is you're doing that corrupts the system.

You need to isolate exactly what is causing the problem. You'll help everyone by doing this. You can do an IISRESET from the command line (as Administrator) to reset it back to normal or Recycle the App Pool from the IIS Manager. Start by doing a simple JSON return from a query like the GetEmployees example method. Just do that over and over to see if you get the message. You probably won't. Now try some of the other code in your app. Somewhere in there you are doing something to cause this, I'm pretty sure.

I just don't have the time to debug your application for you. You need to help all of us by figuring it out and doing your part. After that, if it's feasible, I can put something in there to prevent this sort of problem from happening automatically. An Error method in your Controller class might help with the COMRETURNERROR command.
Coordinator
Aug 7, 2013 at 5:55 PM
Edited Aug 7, 2013 at 7:04 PM
Ok, at least this discussion is possibly leading to improvements.

We need to get our REST implementation to the point where a programmer can put almost anything in there and it won't affect other stuff like what your code is doing. AVFP scripts are like that now.

So I took a look at our REST implementation:
https://activevfp.codeplex.com/SourceControl/latest#avfp6.03_source/prg/resthelper.prg

It's not using the SESSION class and there is no default ERROR handler (with COMRETURNERROR). These should be implemented in the next release.
Sep 28, 2013 at 9:04 PM
Hello, Claude!

My name is Albert. I am from Russia. So sorry for my English.

I could not install the whole week. Was the same mistake as his companion. At one point it occurred to me to register a library. Home run!

Comment on this situation please. Thank you.
Coordinator
Sep 29, 2013 at 6:18 AM
Hi Albert,

Just need to ask a few of questions...

a) Are you trying to install ActiveVFP on your local pc, a server or with a host provider like GoDaddy?
and do you know;
  • IIS version?
  • ASP version?
  • O/S version?
b) Which version of AVP are you installing - 6.03 or 5.53?

c) Are you talking about the following type of error;
#_Creating an instance of the COM component with CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} from the IClassFactory failed due to the following error: 80004005.
or something else? A copy of the exact error will help.

d) Have you installed AVFP with the Installer or the zip file?

e) Have you modified any code or anything else since the installation?

There are possibly more questions for me to ask but maybe these will do for now.

Regards,
Simon
Sep 30, 2013 at 8:50 PM
Wow, so many interesting questions! Sorry for the short and obscure previous message... There are a few answers.

a)
  • I have installed ActiveVFP on my local PC.
  • IIS version is 7.5.
  • Asp version 2.0.50727.
  • O/S version is Win 7 Ultimate x64.
b) I am installing 6.03 version of AVFP.

c) this is the error. Thanks to her, I found your forum. A copy of that error will be in the next message.

d) i have installed AVFP with installer.

e)I just have registered activevfp.dll library typing a command regsvr32 activevfp.dll at the command promt.

Can I ask you has dll library activevfp.dll com-objects? Thank you.
Sep 30, 2013 at 8:54 PM
Ошибка сервера в приложении '/webapp'.

Сбой при получении производства объектов класса COM для компонента с CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} в результате следующей ошибки: 80040154.

Описание: Необработанное исключение при выполнении текущего веб-запроса. Изучите трассировку стека для получения дополнительных сведений о данной ошибке и о вызвавшем ее фрагменте кода.

Сведения об исключении: System.Runtime.InteropServices.COMException: Сбой при получении производства объектов класса COM для компонента с CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} в результате следующей ошибки: 80040154.

Ошибка источника:

Необработанное исключение при выполнении текущего веб-запроса. Информацию о происхождении и месте возникновения исключения можно получить, используя следующую трассировку стека исключений.

Трассировка стека:


[COMException (0x80040154): Сбой при получении производства объектов класса COM для компонента с CLSID {BEF60CED-FB7C-4835-A927-4EC90F5162CB} в результате следующей ошибки: 80040154.]
AVFPHandler.ProcessRequest(HttpContext context) +58
AVFPHandler.OnInit(EventArgs e) +20
System.Web.UI.Control.InitRecursive(Control namingContainer) +333
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +378

Информация о версии: Платформа Microsoft .NET Framework, версия:2.0.50727.4927; ASP.NET, версия:2.0.50727.4927
Coordinator
Sep 30, 2013 at 11:57 PM
Hi Albert,

Thanks for the answers.

The reason for me asking is because when I 1st started to have a look at ActiveVFP, I tested installations of v:6.03 on a number of machines and with the following results;

a) Windows 8 64-bit: zip file install
- Error at first because I made the mistake of setting up a "virtual" and not an "application" directory but this was quickly fixed.

b) Server 2008 32-bit: zip file install
- Initially got a problem with the REST API link/demo. Sorry but I can't remember the full details of the error and unfortunately this was resolved by a colleague whilst I was on holiday and he didn't fully document how he fixed it either. I do know that he installed AVFP again via the installer instead of the zip file which I prefer to do. I'll try to dig out the details of the error a little later on.

c) Server 2012 64-bit: zip file install
- Completed successfully without any problems - maybe I was a bit more practiced by this time.

As you see, I have had a couple of issues but they were fixed quite quickly. Unfortunately I have never got the same error as yourself.

Whilst I have not got a copy of Windows 7 64-bit, I do have a copy of Windows 7 32-bit so I'll try to set this up on a VM and see if I can create the same problem as you are getting. I'll let you know how I get on as quickly as I can.

In the meantime, can I suggest you try the following;

a) Install AVFP again in another folder but this time via the zip file. Please remember that you can have AVFP installed many times on the same machine (in different folders) at the same time.

b) Check again that you followed the instructions for a 64bit installation
i.e.
5.) If you're running a 64-bit version of Windows you must enable 32 bit apps via IIS Manager (Application Pools/DefaultAppPool/Advanced Settings/Set Enable 32-bit applications to True) or issue the following command from Run or the CMD line(you must Run as Administrator):

%systemroot%\system32\inetsrv\APPCMD set apppool /apppool.name: "DefaultAppPool" /enable32bitapponwin64:true

OR

cscript %SYSTEMDRIVE%\inetpub\adminscripts\adsutil.vbs SET W3SVC/AppPools/Enable32bitAppOnWin64 1
NB: There is no need to register the ActiveVFP.dll.

I'm sorry that I haven't come up with fix yet, but as I said, I haven't had this specific problem myself.

BTW, you haven't actually said when you get this specific error. Is it straight away when you launch the demo in your browser? i.e. http://localhost/ActiveVFP603/default.avfp

If not, when do you exactly get this error?

Best regards,
Simon
Oct 1, 2013 at 8:03 PM
Hello again Claude!

Thanks for the detailed description of the installation of the program on different systems.

First, i had installed AVFP into path by default id est into C:\ActiveVFP603. A Virtual Directory was webapp. Error was occured when i launched any node of TEXT adrress including TEXT adrress.

Then i had installed AVFP into defined path by myself. I got the same ploblem.

Regards, Albert.
Coordinator
Oct 1, 2013 at 10:58 PM
Hi Albert,

Sorry to here that you are still not having any success.

When I asked about your O/S, ASP.net, Windows & IIS versions, I was hoping that I had already tested AVFP on the same configuration.

So following links don't work;
http://localhost/webapp/ & http://localhost/webapp/default.avfp - this last one should have.

I am assuming that http://localhost does work and that it presents you with the default IIS page?

I can only suggest that I try to set up an install on a copy of Win 7 32-bit that I have to see if I can simulate your same problem. Will try to do this tomorrow night.
re: A Virtual Directory was webapp
Please confirm that you have set it is as an "Application" directory?

I will let you know how I get on as soon as I have completed my installation on my Win 7 system.

All the best,
Simon
Coordinator
Oct 2, 2013 at 11:26 AM
Hi,

You've been getting help from Simon, not me. So please thank him instead.

My only advice is to start with a new machine or try a web host like GoDaddy. It just shouldn't be as hard as it appears it is for you (not to blame you, though). Normally AVFP installs and works in about 2 minutes.

Always use the Installer instead of the zip file unless you have a good reason for using the zip like no CMD line capability or using IIS Express instead of regular IIS. The Installer takes care of most things assuming you have installed IIS and enabled ASP/ASP.NET.

Good luck!
Developer
Oct 2, 2013 at 3:33 PM
Edited Oct 2, 2013 at 4:17 PM
Hi ABigDreamer,

Regarding
'.........These lines are creating a string, that is sent to the JSON parser and brought into my program.
How do I put this into a memo field? ... '

In my experience with VFP memo fields in IIS has not been good. If you are opening your table in 'shared' mode, then extracting data from memo field is astonishingly slow. However, I work in C/S systems only so not an authority on multiuser F/S system..

Regardless, I would think you can load the return value of oJSON.stringify('SearchResults')) into any memo field. If your string is more than 16 MB, I would suggest you create a file on the disk using strtofile() and then into the memo field using fileTostr(). This is mandatory if you plan on modifying the string in any way.

oResponse.ContentType is the attribute set in response obj and you would need to set it directly, whenever you consume the json. It can be hardcoded unless you generate different mime type or localization. If so, store it separately in another field of your table.

I've also had past experience with random AVFP crash. It was due to timeout due long time waiting to extract/load data of memo fields. Could you have the same problem?
Oct 2, 2013 at 7:53 PM
Ok I understood, Claude.

Simon, there is the same problem of installing with zip-file.

Yes it is. My TEXT works. It presents the default iishome page.

By the way when I registering activefvp.dll libraryrary i get a folowing message:

Successful execution of DllRegisterServer into C:\Windows\syswow64\activevfp.dll.

May be this information will help.

Regards, Albert.
Oct 2, 2013 at 8:03 PM
Please confirm that you have set it is as an "Application" directory? 
Sorry! Exactly, an aplication directory, not virtual.
Coordinator
Oct 3, 2013 at 1:36 AM
Edited Oct 3, 2013 at 1:40 AM
Hi,

First, the good news;
I've just completed an installation of AVFP 6.03 on Win 7 32-bit (hosted on a VM)

Next, the bad news;
I've ended up with an installation error that I haven't managed to fix yet - (hopefully I'll be able to show a screen snap-shot below)
"http://www.imageshack.eu/pLy.png"

Some more good news;
I've simulated the same error reported by Albert so it gives me a better chance to find the fix for it. I'll continue to investigate and will find the solution!

Sorry Albert for not finding the fix yet!
I've noted some of the comments/advice above from previous posts and will be focusing on ASP.NET & IIS setup/config.
I'll get back to you as soon as possible with an update.

Best regards,
Simon
Coordinator
Oct 3, 2013 at 1:47 AM
BTW, I did use the installer and not the zip file for the installation.
Oct 3, 2013 at 4:39 PM
Hi, Simon!

It is good that you were able to reproduce the my problem.

Good luck with problem solution.
Coordinator
Oct 3, 2013 at 7:07 PM
Edited Oct 3, 2013 at 7:10 PM
Simon,

When installation from the installer/zip won't work at first, below is my workflow to resolve it:
  • Run start/stop of IIS server ( I have a batch file created for this, running as administrator)
    net stop w3svc
    net start w3svc
  • Register activevfp.dll
You can have the 2 items in one batch file with the content below ( again must be running as administrator)
net stop w3svc
cd C:\inetpub\wwwroot\activevfp603
regsvr32 /u activevfp.dll
regsvr32 activevfp.dll
net start w3svc

Since I have website running on old version of activevfp (553), I also have another batch file that similarly does this with the exception of the source DLL.
cd C:\inetpub\wwwroot\activevfp553
net stop w3svc
regsvr32 /u activevfp.dll
regsvr32 activevfp.dll
net start w3svc


This usually gives me the quick fix for some installation woes.
Coordinator
Oct 3, 2013 at 8:44 PM
Edited Oct 5, 2013 at 8:17 PM
Thanks but the problem with this advice is that they will neglect to install IIS or ASP/ASP.NET and then think they have to start Registering stuff when it doesn't work at first. You should never have to restart the server either.

A problem with manual Register is that it's system wide, meaning the activevfp.dll in the directory you register it in will possibly the one you're running when you have another AVFP directory someplace. Then you may get error messages about not finding files etc.

The reg-free way AVFP normally works allows each folder to have it's own copy of activevfp.dll withour affecting anything else. This is another reason it works great on shared web host sites.

My guess is that a small minority are having problems with Installation. Ordinarily the Installer will install everything in about 2 minutes without ANY special tweaking at all assuming it's IIS7 or above with ASP/ASP.NET enabled. Normally (98% of the time?) there should be no need to Register anything, mess with enabling 32 bit (done automatically by the installer) or mess around memory pools, etc. Take a look at the BAT(cmd) file that does the installation. it takes care of everything.

Now if some don't want to do that or are having problems with the Installer, let Arvixe install ActiveVFP for you for FREE on their Web hosting service at this link:

http://www.arvixe.com/5013-415-3-342.html
Coordinator
Oct 3, 2013 at 11:00 PM
Hi,

Thanks for your suggestions & comments guys - all are greatly appreciated!

apaustria:
I will try your suggestions in this case because I think that it's important to know how to overcome this specific issue. For starters, Albert has this problem now. Secondly, I think it's important for us to know how to resolve issues like this as, when and if any other members end up experiencing similar/same types of problem.

I do however acknowledge Claude's point though. Up to now, I have not had any (real) problems with installing AVFP - even when done without the installer - and, apart from an issue on Windows Server 2008, I have not had to tweak anything at all. As I mentioned earlier, the only problem that I had was with Server 2008 and this was something to do with the REST demo only - everything else worked just fine. Because I was just about to go on holiday, somebody else sorted this out for me which, as far as I know, was simply done by installing AVFP again with the installer.

Claude:
All your points are noted and even though I have, up to now, installed AVFP from the zip file, I will from now on do it with the installer.

The service offered by Arvixe sounds fantastic and I'm most probably going to sign up for a year if not just to test it out.

Having said that, I still think that members will want to be able to install AVFP on their local machines even if they eventually want it hosted. Call me a traditionalist, but I still do all of my development on my local machine before publishing it to the server. Also, I'm guessing that most people will first test AVFP out on their local pc's.

And finally;
I don't know about you, but in situations like this, I always look for common denominator.
Could it be Windows 7 and it's compatible versions of IIS and ASP.Net in this case?

A question to all I suppose, has any body else experienced this specific issue and if so, with what versions of Windows, IIS & ASP.Net?

All the best,
Simon
Coordinator
Oct 3, 2013 at 11:56 PM
Edited Oct 3, 2013 at 11:58 PM
apaustria;

THANKS! Iv'e got AVFP fully working and hope that this works for Albert too!

I used the cmd line commands as you suggested, although slightly modified as per below;
net stop w3svc
cd C:\avfp603_demo1
regsvr32 /u activevfp.dll
regsvr32 activevfp.dll
net start w3svc
Please note directory location changed as per my own installation.

Albert;

Would you like to try this yourself and let us know how you get on?


Thanks again apaustria!
Coordinator
Oct 4, 2013 at 12:54 AM
Edited Oct 4, 2013 at 1:03 AM
And finally;
I don't know about you, but in situations like this, I always look for common denominator.
Could it be Windows 7 and it's compatible versions of IIS and ASP.Net in this case?
The AVFP Installer works great with IIS on Vista, Windows 7, Windows 8 and probably whatever comes after that.

I would advise to always use the Installer on IIS 7 or above (Vista, Windows 7, Windows 8 or above) for local installations. A lot of headaches will be saved.
Coordinator
Oct 4, 2013 at 1:56 AM
Edited Oct 4, 2013 at 2:07 AM
Hi Claude,

Thanks, and I'll definitely take your advice - I will always use the installer from now on.

I've successfully installed AVFP on Vista, Windows 8, Windows Server 2008 & 2012 and even GoDaddy (back in the past) without problems.
For some reason, it didn't totally work for Albert & myself recently on Win 7.

Whilst this issue may only happen now and again (i.e. the 2% of occasions you mentioned), hopefully these posts will help others sort it out quickly if they come across it.

Hopefully Albert will confirm soon that the above suggested process has resolved his problem too.

Thanks again apaustria for your help.
Oct 5, 2013 at 7:20 PM
Thank for all. The problem is gone. A have added the folowing code into installing cmd-file:
net stop w3svc
cd C:\avfp6.03Demo
regsvr32 /s /u activevfp.dll
regsvr32 /s  activevfp.dll
net start w3svc
where i used register "s" to not get information messages from OS.