File Upload - 404 error

[[email protected]]

Hi Everyone,

I have a problem with File Upload built in function in Alpha . The thing is 2 weeks ago , this function works well but last week its not working anymore.It giving me the 404 error. I refer to this another forum here
https://www.alphasoftware.com/alphaf...t=IMPORT+EXCEL and it said that it occured because of the windows server update. I check it , and yes there is some update to the server . Then I decided to uninstall the update and restart the server.But the problem persist.Can anyone help me with this problem? Is it cannot be solve? I really need the File upload function.

Previously it working like this
previous working.jpeg

Now it become like this
fail 404.jpeg

I`m using this function
FileUpload.PNG

This is my current version
Alpha Anywhere V4.5.0 - Build 4582_4960

Please help regarding this.Thank you in advance.

[[email protected]]

Re: File Upload - 404 error

Hi Everyone,

I have a problem with File Upload built in function in Alpha . The thing is 2 weeks ago , this function works well but last week its not working anymore.It giving me the 404 error. I refer to this another forum here
https://www.alphasoftware.com/alphaf...t=IMPORT+EXCEL and it said that it occured because of the windows server update. I check it , and yes there is some update to the server . Then I decided to uninstall the update and restart the server.But the problem persist.Can anyone help me with this problem? Is it cannot be solve? I really need the File upload function.

Previously it working like this
[ATTACH=CONFIG]44304[/ATTACH]

Now it become like this
[ATTACH=CONFIG]44305[/ATTACH]

I`m using this function
[ATTACH=CONFIG]44306[/ATTACH]

This is my current version
Alpha Anywhere V4.5.0 - Build 4582_4960

Please help me regarding this.Thank you in advance.

I forgot to inform that when I inspect this problem it is said that it cannot found the a5FileUploadMasterPage.a5w which is weird as when I check in my published folder it is there and not missing.

404.PNG

When I test locally it is working.Just happen when its in the IIS Server which is in the condition that I explained before(Might be because of the recent window update that make it suddenly not working).. Can anyone help me with this problem?

[Selwyn Rabins]

Re: File Upload - 404 error

Unfortunately, Microsoft has broken their ODBC driver for Excel. Alpha Anywhere relies on this driver to read Excel files

In the mean time you can try uploading ascii files instead of excel files.

you can verify that the issue is caused by the Microsoft bug by creating an .a5w page that has this code and then running the page

<%a5

dim fn as c 
'you must specify your own Excel file.
'if you are running under IIS make sure that your IIS account has read permission to the folder
fn = "C:\bugs\testexcel.xlsx"   

dim p as p
p = a5_getExcelInfo(fn)

if p.hasError = .t. then 
   ?"Alpha was not able to open the excel file because the Microsoft Excel ODBC driver is broken"
else
    dim cn as sql::Connection
    cn.open(p.connectionString) 'connect to the excel file
    cn.PortableSQLEnabled = .t.
    cn.Execute("select * from [" + p.table + "]")
    dim json as c 
   json = cn.ResultSet.tojson()
    ?"Alpha CAN connect to the Excel file"
   ?"<pre>" + json + "</pre> 
end if 

%>

If you run this page you will know if the problem is related to the Excel ODBC bug (which Alpha has no control over), or some other issue

[[email protected]]

Re: File Upload - 404 error

Unfortunately, Microsoft has broken their ODBC driver for Excel. Alpha Anywhere relies on this driver to read Excel files

In the mean time you can try uploading ascii files instead of excel files.

you can verify that the issue is caused by the Microsoft bug by creating an .a5w page that has this code and then running the page

<%a5

dim fn as c 
'you must specify your own Excel file.
'if you are running under IIS make sure that your IIS account has read permission to the folder
fn = "C:\bugs\testexcel.xlsx"   

dim p as p
p = a5_getExcelInfo(fn)

if p.hasError = .t. then 
   ?"Alpha was not able to open the excel file because the Microsoft Excel ODBC driver is broken"
else
    dim cn as sql::Connection
    cn.open(p.connectionString) 'connect to the excel file
    cn.PortableSQLEnabled = .t.
    cn.Execute("select * from [" + p.table + "]")
    dim json as c 
   json = cn.ResultSet.tojson()
    ?"Alpha CAN connect to the Excel file"
   ?"<pre>" + json + "</pre> 
end if 

%>

If you run this page you will know if the problem is related to the Excel ODBC bug (which Alpha has no control over), or some other issue

As you can see from my previous explanation, the window that needed to browse the file itself cannot be run as it saying its missing the a5FileUploadMasterPage.a5w . My component allowed all kind of document to be uploaded (pdf,txt,doc,png,jpeg etc) . Before this happen , my component works as intended , I can browse my file to get the files to be uploaded but now it just 404 error cannot be found. My live server now having this 404 error ( but it works just fine before the windows update recently) but went I test locally the function works well , I able to browse the file and upload my files.

I hope I do explain more this time. Its not that I`m having a problem with excel document. The problem is , I cannot even get the file as the window that browse the file is not found as it saying its missing the a5FileUploadMasterPage.a5w .