| Author |
 Topic  |
|
Benny Lee
Starting Member
20 Posts |
 Posted - 14 July 2001 : 22:00:18
|
I just use everything as it is downloaded except I use the Access 2000 mdb file from ID. I know nothing about asp so I don't have the knowledge to change anything.
I have changed the string as you suggested
strConnString = "Provider=Microsoft.Jet.OLEDB.4.0;User Id=Admin;Database Password="""";Data Source=w:\inetpub\wwwroot\cyborgstudio\database\cyborg_forum.mdb" '## MS Access 2000
I have also add the password to log in my directory in the string. The result is the same, the same message
|
 |
|
|
Id
Junior Member
USA
129 Posts |
Posted - 15 July 2001 : 01:37:04
|
not sure how a password would've been added to the file, i didn't do any modifications do it safe converting it to access 2000, that's an odd one, does your ISP by chance have the authentication on your database directory set up as basic authentication or windows authentication? It should be set up with no authentication whatsoever
Edited by - Id on 15 July 2001 01:39:21 |
|
|
|
Id
Junior Member
USA
129 Posts |
Posted - 15 July 2001 : 01:38:55
|
ok, i'm getting a different error, than an invalid user name and password when i go to your forum
here's what i'm getting
Microsoft JET Database Engine error '80004005'
Could not find installable ISAM.
/forum/inc_top.asp, line 42
Now if i'm remembering my errors correctly, it's looking like your connection strings is set up incorrectly (someone correct me if i'm wrong here)
I'm really curious here, i just had a thought, there are some FTP servers (G6 FTP is one of them) where you can set up links and alter the directory layout of your FTP site, and in doing so directory locations can show up in wierd locations
Try setting up your strConnectionString as w:\inetpub\wwwroot\cyborgstudio\www\database\cyborg_forum.mdb as the Data Source and see what that does for you
Edited by - Id on 15 July 2001 01:44:00 |
|
|
|
Benny Lee
Starting Member
20 Posts |
Posted - 15 July 2001 : 11:56:40
|
I have try it but experienced the same error, same message, I don't understand why the message show on my browser is different from yours.
Although I still can not get it to work, but I am really apprediated so many people trying to help others.
If you still have other ways for me to try please post and I will ask my ISP about the question you have bring up about the server but I thing I won't have the answer until Monday
Thank you
|
|
|
|
Id
Junior Member
USA
129 Posts |
Posted - 16 July 2001 : 00:03:59
|
another thing you could try doing is see if your ISP can set up a DSN connection for you, then you just create a new strConnString i.e.
strConnString = "DSName"
then you don't have to worry about the exact connection, that bit about the password still miffs me, only thing i can figure is my system somehow did set up a password on the database and because it's my system that's accessing it, it's supplying the needed password, but I find that rather unlikely, windows security typically doesn't access things that way, especially when it's on a different domain.
If someone else here is running access2000 on their home system, could they download the database from my ftp server ftp.gamers-hub.com and try opening it and see if it asks for a password? That way we're sure it's nothing on the database end.
|
|
|
|
Davio
Development Team Member
Jamaica
12217 Posts |
Posted - 16 July 2001 : 00:10:52
|
I think the password error was there before he used the database you sent him Id.
This user is also having a similar error:
link.asp?TOPIC_ID=12993
- David
Edited by - Davio on 16 July 2001 00:15:58 |
|
|
|
Doug G
Support Moderator
USA
6493 Posts |
Posted - 16 July 2001 : 12:40:03
|
Id, I just downloaded the DB from your ftp site and it opened without asking a password. I guess there is something else in the original posters configuration generating the error about authentication failed. I don't know what it may be, though.
======
Doug G
====== |
|
|
|
Id
Junior Member
USA
129 Posts |
Posted - 16 July 2001 : 14:41:26
|
I'm trying to figure out, or well remember how windows authentication works on IIS, if i remember right, IUSR_computername only gets anyonymous access to the directory the virtual host is pointing to. In this instance w:\inetpub\wwwroot\cyborgstudio\www\.
Now what i'm thinking that means, is that windows secury won't allow it access to anything below that directory. So if his database is in a directory below www (i.e. 'w:\inetpub\wwwroot\cyborgstudio\database') I don't think IIS Security will allow access because it's not on the website, it's within the windows directory structure.
What may need be done is the database directory needs moved to the www directory so that IUSR can get access to it. Now i may be completely wrong, I'd have to check on my win2k server to check authentication schemes and the like. But it could be something that simple if the database directory is set up with anonymous access still and it's below the www directory.
Anyway, my two cents, if i'm wrong about this security set up, some one please correct me
|
|
|
|
sump
New Member
USA
78 Posts |
Posted - 16 July 2001 : 15:35:02
|
if you have the win2k server, you need to run the permmision wizard and server extentions.
the db needs to be in a folder that has write permissions to be updated i beleive.
like fpdb
sump
|
|
|
|
Benny Lee
Starting Member
20 Posts |
Posted - 17 July 2001 : 00:13:11
|
I havn't got the answer from my ISP yet, I still trying hard to get it to work but no luck.
In my database folder there is another database which was set to use RmiJdbc driver, will this be the problem?
I put a request to my ISP to ask him to create a cgi-bin in my directory and I will try to upload the database file to the cgi-bin instead of the database folder, do you think it will work?
|
|
|
|
Id
Junior Member
USA
129 Posts |
Posted - 17 July 2001 : 13:39:58
|
the other database in there shouldn't be conflicting. As far as a cgi-bin directory, as long as it has read and write permissions the database should work fine there. It doesn't really matter where the database is, just so long as the folder it's in has read/write permissions.
|
|
|
|
kremmen
Starting Member
9 Posts |
Posted - 18 July 2001 : 05:14:41
|
[quote]
Go here http://forum.snitz.com/archive/default.asp?catid=11&cattitle=Forum+Setup+Tools and download the "Where Am I?" tool. Extract the script to where your database is and browse to it using your browser. It will tell you the direct location to your database you will use that path in the following connection string:
I thought that you would want to physically keep your Database outwith the directories accessable by the browser.
Have I erred?
kremmen
|
|
|
|
Topic |
|
Topic Locked
