| Author |
 Topic  |
|
|
timcorey
Starting Member
USA
14 Posts |
 Posted - 26 August 2010 : 11:19:33
|
It has been a long time since i used a localhost. i think it is running. i open setup.asp and i get:
The database could not be opened !!
Check your config.asp file and set the
strConnString so it points to the database.
Also check if strDBType is set to the right databasetype.
Code : 80040E73
Error Description :
Format of the initialization string does not conform to the OLE DB specification.
I am using: strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source==C:\Inetpub\wwwroot\Gators\fpdb\4Txi7k9Yxvkt.mdb"
I tried DSN and got a blank screen
here is my string: strConnString = "GatorDSN"
I started my personal web server (using inetmgr link). I am a novice at this. sorry if it is an easy question.
regards,
tim |
Edited by - timcorey on 26 August 2010 11:22:53 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 26 August 2010 : 16:31:45
|
quote:
Provider=Microsoft.Jet.OLEDB.4.0;Data Source==C:\Inetpub\wwwroot\Gators\fpdb\4Txi7k9Yxvkt.mdb
you have two equals signs in that string (marked in red) there should only be one. |
MVC .net dev/test site | MVC .net running on Raspberry Pi |
 |
|
|
timcorey
Starting Member
USA
14 Posts |
Posted - 26 August 2010 : 16:45:11
|
OK, i fixed that and got slightly further. it asked me to confirm my password, which i did. then i get the following: (there were 21 critical errors, only showing first one here - i am executing setup.asp page)
Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_CATEGORY(CAT_STATUS, CAT_NAME) VALUES(1, 'Snitz Forums 2000')
Error: -2147467259 Operation must use an updateable query.
strSql: INSERT INTO FORUM_MEMBERS (M_STATUS, M_NAME, M_USERNAME, M_PASSWORD, M_EMAIL, M_COUNTRY, M_HOMEPAGE, M_LINK1, M_LINK2, M_PHOTO_URL, M_SIG, M_VIEW_SIG, M_SIG_DEFAULT, M_DEFAULT_VIEW, M_LEVEL, M_AIM, M_ICQ, M_MSN, M_YAHOO, M_POSTS, M_DATE, M_LASTHEREDATE, M_LASTPOSTDATE, M_TITLE, M_SUBSCRIPTION, M_HIDE_EMAIL, M_RECEIVE_EMAIL, M_LAST_IP, M_IP, M_ALLOWEMAIL) VALUES(1, 'timcorey', 'timcorey', '1a499b3303e4817e8979230728485f432c279fca8f7cf12f4d3e74466bc66796', 'yourmail@server.com', ' ', ' ', ' ', ' ', ' ', ' ', 1, 1, 1, 3, ' ', ' ', ' ', ' ', 1, '20100826134336', '20100826133836', '20100826134336', 'Forum Admin', 0, 0, 1, '000.000.000.000', '000.000.000.000',1)
Error: -2147467259 Operation must use an updateable query. |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
|
|
timcorey
Starting Member
USA
14 Posts |
Posted - 26 August 2010 : 19:28:36
|
Thank you. I should know this. It has been a long time. The DB is on my PC. I am not sure how to set permissions. I previously used win 98se with personal web server, and i did not have to set DB permissions. Can you please give me a starting point for learning how to do this?
thanks! |
|
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 27 August 2010 : 03:19:00
|
from the readme
Q: Why do I get an "Operation must use an updateable query" error when trying to use my forum?
A: This is a common HTTP 500 error encountered when setting up an Access Database. It means that the folder in which you have placed the database does not have proper permissions granted to the server to modify the files. Make sure that if your host provided a location specifically for databases, that you have put the database there. For more information and other possible resolution strategies, you can refer to this article: http://support.microsoft.com/default.aspx?scid=kb;EN-US;q175168
|
MVC .net dev/test site | MVC .net running on Raspberry Pi |
|
|
|
timcorey
Starting Member
USA
14 Posts |
Posted - 30 August 2010 : 18:44:03
|
Please forgive my lack of knowledge in this area. The database and forum, for now, reside on my PC (under the localhost). In the past, when I had Win 98SE, I did not have to apply any permissions to the folder. I was using Personal Web Server (PWS).
But now, I guess I am using IIS on my PC as the server, so there must be some way to set the permissions on the folder that contains the DB. I am just not sure how to do it. (I understand that it can easily be done on the web server folder under IIS - but how do you do it on a PC (using localhost and iis -- instead of the PWS)?
thanks again. |
|
|
|
timcorey
Starting Member
USA
14 Posts |
Posted - 30 August 2010 : 18:48:09
|
I just figured it out. I had to click on Tools-> Server -> Permissions and give read and author permissions to the folder. is that right?
thanks. |
|
|
|
ruirib
Snitz Forums Admin
Portugal
26364 Posts |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 31 August 2010 : 03:14:15
|
taken from the microsoft link I posted previously
The most common reason is that the Internet Guest account (IUSR_MACHINE), which is by default part of the "Everyone" group, does not have Write permissions on the database file (.mdb). To fix this problem, use the Security tab in Explorer to adjust the properties for this file so that the Internet Guest account has the correct permissions.
NOTE: When using Microsoft Access databases with ADO, it is also necessary to give the Internet Guest account Write permissions on the directory containing the .mdb file. This is because Jet creates an .ldb file to handle database locking. You may also need to give read/write permission on the "Temp" folder because Jet may create temporary files in this directory.
|
MVC .net dev/test site | MVC .net running on Raspberry Pi |
|
|
| |
Topic |
|
|
|
Topic Locked
