•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the ASP section within the Web Development category of DaniWeb, a massive community of 427,215 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,127 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our ASP advertiser: Lunarpages ASP Web Hosting
Views: 1957 | Replies: 28
 |
•
•
Join Date: Aug 2007
Posts: 98
Reputation: 
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
•
•
•
•
Originally Posted by TobbeK 
Alright
It can be a permission problem.
Right click at the wwwroot and check if your account have the proper security permissions for it. If you don't have the IIS_IUSRS(yourhost\IUSRS) accont present then may have to add that one. and give it permission to read, write and so on..
I dont know! I didnt have any permissions but the IT guy changed my permissions now I can write/ read etc to wwwroot, I have put my dreamweaver and database files in here. I dont know what IIS_IUSERS(yourhost\IUSERS) is... i clicked on properties and security, I cant even see this option. If this is needed, what do I ask the IT guy for??
Sorry if these questions are a bit silly and simple!
GLT
•
•
Join Date: Aug 2007
Posts: 98
Reputation:
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
•
•
•
•
Originally Posted by SheSaidImaPregy
When replacing a word, you have to replace all occurances:
Put your username and password in. Also, "conn" is the active connection, so you need to replace MM_dbtest_STRING with conn.conn.Open = "Provider=Microsoft.Jet.OLEDB.4.0 Data Source=[dbtest.mdb.dsn] User ID=[username] Password=[password]" Set search = Server.CreateObject("ADODB.Recordset") search.ActiveConnection = MM_dbtest_STRING
I tried that:-
Dim search
Dim search_numRows
Dim SM
Dim conn
Set conn = Server.CreateObject ("ADODB.Connection")
conn.Open = "Provider=Microsoft.Jet.OLEDB.4.0 Data Source=[dbtest.mdb.dsn] User ID=[gthompson] Password=[Password4]"
Set search = Server.CreateObject("ADODB.Recordset")
search.ActiveConnection = conn
SM = Replace(search_MMColParam,"'","''")
search.Source = "SELECT * FROM product WHERE ProductID "&_
"WHERE ProductID= '"&SM&"'"&_
"ORDER BY ProductID ASC"
search.CursorType = 0
search.CursorLocation = 2
search.LockType = 1
search.Open()
Still wont work!
This is the error message I got:-
Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/testlogin/search.asp, line 17
GLT
•
•
Join Date: Sep 2007
Posts: 1,057
Reputation:
Rep Power: 4
Solved Threads: 61
lose the brackets, they were there to tell you that you put your password and username. Lose all [] from the string.
•
•
Join Date: Aug 2007
Posts: 98
Reputation:
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
I tired:-
conn.Open = "Provider=Microsoft.Jet.OLEDB.4.0 Data Source=dbtest.mdb.dsn User ID=gthompson Password=Password4"
and:-
conn.Open = "Provider=Microsoft.Jet.OLEDB.4.0 Data Source=dbtest.mdb.dsn, User ID=gthompson, Password=Password4"
both came up with same error message:-
Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/testlogin/search.asp, line 17
conn.Open = "Provider=Microsoft.Jet.OLEDB.4.0 Data Source=dbtest.mdb.dsn User ID=gthompson Password=Password4"
and:-
conn.Open = "Provider=Microsoft.Jet.OLEDB.4.0 Data Source=dbtest.mdb.dsn, User ID=gthompson, Password=Password4"
both came up with same error message:-
Error Type:
ADODB.Connection (0x800A0E7A)
Provider cannot be found. It may not be properly installed.
/testlogin/search.asp, line 17
•
•
Join Date: Sep 2007
Posts: 1,057
Reputation:
Rep Power: 4
Solved Threads: 61
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=dbtest.mdb.dsn; User ID=gthompson; Password=Password4"
must have the semi-colons.
must have the semi-colons.
•
•
Join Date: Aug 2007
Posts: 98
Reputation:
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
•
•
•
•
Originally Posted by SheSaidImaPregy
"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=dbtest.mdb.dsn; User ID=gthompson; Password=Password4"
must have the semi-colons.
this time I got this error message:-
Error Type:
Microsoft JET Database Engine (0x80040E4D)
Cannot start your application. The workgroup information file is missing or opened exclusively by another user.
/testlogin/search.asp, line 17
I dont understand the file is not missing or open.
•
•
Join Date: Feb 2008
Posts: 135
Reputation:
Rep Power: 1
Solved Threads: 3
Junior Poster
Create a new testdb as this
Save that in a new folder named "newtestdb" (without password) under wwwroot:
1. testdb1.mdb
Create just one table and name it:
2. testtable
Create just one field and name it
3. testdata
Fill some posts in tablefield "testdata" with something like:
blla bla bla
blabla bla
bla blanaa
Open notepad and copy the code below into that and save it as "test.asp" IN THE SAME FOLDER AS the testdb1.mdb.
(I don't use dreamviewer so I don't know if it's planting any additional code by it's own)
You CANNOT just click on that asp file to make it run, you must do that from the webbrowser by:
http://127.0.0.1/newtestdb/test.asp
Or
http://localhost/newtestdb/test.asp
If you cannot access this database then you may have a chat with your system admin to loose up your permissions or maybe reconfigure the IIS.
Save that in a new folder named "newtestdb" (without password) under wwwroot:
1. testdb1.mdb
Create just one table and name it:
2. testtable
Create just one field and name it
3. testdata
Fill some posts in tablefield "testdata" with something like:
blla bla bla
blabla bla
bla blanaa
Open notepad and copy the code below into that and save it as "test.asp" IN THE SAME FOLDER AS the testdb1.mdb.
(I don't use dreamviewer so I don't know if it's planting any additional code by it's own)
<%
Set Conn = Server.CreateObject("ADODB.Connection")
Conn.Open "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & Server.MapPath("testdb1.mdb")
SQL = "SELECT * FROM testtable"
Set RS = Server.CreateObject("ADODB.recordset")
RS.Open SQL,Conn
Do While Not RS.EOF
Response.Write(RS("testdata") & "<br>"
RS.MoveNext
Loop
%>You CANNOT just click on that asp file to make it run, you must do that from the webbrowser by:
http://127.0.0.1/newtestdb/test.asp
Or
http://localhost/newtestdb/test.asp
If you cannot access this database then you may have a chat with your system admin to loose up your permissions or maybe reconfigure the IIS.
Last edited by TobbeK : Mar 7th, 2008 at 8:05 am.
•
•
Join Date: Aug 2007
Posts: 98
Reputation:
Rep Power: 2
Solved Threads: 0
Junior Poster in Training
yeah i think it must be my permissions! my supervisor tried something on his computer and then on my computer and it wouldnt work on mine! this is so frustrating, I have asked so many times for my permissions to be fixed!!!!
Thanks so much you guys for all your help!
I might be back with more questions if I still cant get it to work after my permissions are fixed.
GLT
Thanks so much you guys for all your help!
I might be back with more questions if I still cant get it to work after my permissions are fixed.
GLT
|
•
•
•
•
•
•
•
•
DaniWeb ASP Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Linear Mode
- Previous Thread: ASP File Upload - best solution ?
- Next Thread: Post Back Function
