| 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
20611 Posts |
|
|
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
20611 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
20611 Posts |
|
|
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
20611 Posts |
|
| |
Topic |
|
|
|
Topic Locked
