This topic is locked

Access Database Error

1/23/2007 12:18:01 PM
ASPRunnerPro General questions
B
bsiinc author

I have created an Access database to store pictures that I want to allow users to upload to my web page. When I try this on your demo server it works fine when I try to upload and save a file. When I try to upload pictures to this database to my web page at on a remote Windows web server, I get this error when when I click "save":

<<< Record was NOT updated >>>
[Microsoft][ODBC Microsoft Access Driver] Cannot update. Database or object is read-only.
Also I have not been able to figure out how to fill in the fields correctly in the User Login settings screen to allow users to register on line. When I try to register online on my web page or on the demo server, I get this error:

HTTP 500 - Internal server error
I would appreciate any guidance on how to correct my problems.
Thanks,

Debby

Sergey Kornilov admin 1/23/2007

Debby,
most web hosting companies have a designed folder where you need to place database file (data or database or db).

You need to find what is this folder (ask your hosting company or read their docs).
After that check the following article that explains how to setup this in ASPRunnerPro:

http://xlinesoft.com/asprunner/docs/troubl...ery__errors.htm

B
bsiinc author 1/25/2007

Thanks so much for the help Sergey,
I still seem to be doing something wrong. I changed the line to strConnection = "DBQ=F:\home\mywebid\mysite.com\databases\testphoto.mdb";Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"
Which represents the exact location of the database on my website in the database folder that the ISP has set up, but now I get this error when trying to open the site on the web:
Microsoft VBScript compilation error '800a0401'
Expected end of statement
/PhotoAlbum/output/include/dbconnection.asp, line 2
and the strConnection shown above is listed next.
I am not very familiar with working with online databases so I am wondering what I missed.
Thanks!

Alexey admin 1/26/2007

Debby,
here is your line of code corrected:

strConnection = "DBQ=F:\home\mywebid\mysite.com\databases\testphoto.mdb;Driver={Microsoft Access Driver (*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"
B
bsiinc author 1/30/2007

I see now where I left the extra quote marks in and I have corrected. Now my web login page comes up, but when a user logs in I get the HTTP 500 - Internal Server error. I did check with my hosting admin and I have set the permissions on the database file per their instructions. I have searched the forum to see if I can find a similar problem, but haven't seen anything that I think would help. Do you have any other suggestions on how I can get this web page to appear?
Thanks,

Debby

Sergey Kornilov admin 1/30/2007

Debby,
post your files to Demo Account (last tab in ASPRunnerPro) and send me a URL where I can see this problem.

Alternatively you can zip and send all files from the output folder.

B
bsiinc author 1/30/2007

Sergey,
I have uploaded my files to the demo account. The URL is www.dawsongang.com. The Db connection string that I am using per the instructions from my web host and the help that I have gotten from this forum is:

strConnection = "DBQ=D:\home\shw3_120\databases\testphoto.mdb;Driver={Microsoft Access Driver(*.mdb)};DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;UID=admin;"
I agree with the other comments that I have seen on this forum - your support of this product is outstanding. Thanks for helping me with this.
Debby

Sergey Kornilov admin 1/30/2007

Debby,
Demo Account button is located on the last tab in ASPRunnerPro and uploads your application to our demo server (not to yours).

B
bsiinc author 1/31/2007

Debby,

Demo Account button is located on the last tab in ASPRunnerPro and uploads your application to our demo server (not to yours).


Sergey,
I did upload to the Demo Account last night using the button on the last tab. I use the demo account to test on your server often and I was able to see my site there with no problem last night. Do you not see it there now?
Debby

Sergey Kornilov admin 1/31/2007

Debby,
how do I know which Demo Account is yours?

B
bsiinc author 1/31/2007

Debby,

how do I know which Demo Account is yours?


Sergey,
I misunderstood what you were asking me for. Is this the URL that you need?
http://demo.asprunner.net/dwest%5Fbatchelo...Photo/login.asp
Also as I said, this works fine on the Demo server. I am just not sure what else that I need to check on my web host server to make this work.
Thanks,

Debby

Sergey Kornilov admin 1/31/2007

Debby,
I can see it working.
This might be some problem with connection string though it looks good.

There can be also some problem with Web server configuration.
If you like me to troubleshoot this directly on your Web server contact me directly at support@xlinesoft.com.