Oh, I saw SQL Server in your original post so I thought that was what you were
using.
Check your permissions on the IUSR account for your web application directory.
This can be the problem, as this user might not have the correct permissions to
update or insert records in your database.
Open Windows Explorer and find your Access DB. Next, right click with your
mouse on this folder and choose properties. Choose the tab 'Security'.
Now we will add this Internet Guest Account, so click the button Add and look
for a user called IUSR_MACHINENAME where MACHINENAME is the name of your
server/computer.
Once you added this new user, give it full permission. Last check, the option
'Allow inheritable permissions from parent to propagate to this object' must be
activated.
So, press Apply or OK and try again.
Mark
kuku b <[EMAIL PROTECTED]> wrote:
i am using access
Mark E <[EMAIL PROTECTED]> wrote:Are you using SQL Server or Access? I see a
reference to each and want to be sure.
Mark
kuku b <[EMAIL PROTECTED]> wrote:
well it stilll didn't work.now its giving an error as
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no default
driver specified.
I have made a table inventory which is inside inventory db,
& i have stored it in same file as my asp page.
Mark E <[EMAIL PROTECTED]> wrote:
This should work for sql server:
Set conn = Server.CreateObject("ADODB.Connection")
aConnectionString="DRIVER={SQLServer};" & _
"SERVER=localhost;UID=sa;" & _
"PWD=;DATABASE=inventory"
conn.open aConnectionString
Mark
kuku b <[EMAIL PROTECTED]> wrote:
I tried to do that but it didn't work
so the next thing itried was
strConn = "DBQ=My Documents\inventory\inventory.mdb"
conn.open "DRIVER={Microsoft Access Driver (*.mdb)}; " & strConn
but this too is giving an error as
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] '(unknown)' is not a valid path. Make
sure that the path name is spelled correctly and that you are connected to the
server on which the file resides.
i think i am giving the right path.
well i don't know whats the problem.
Mark E <[EMAIL PROTECTED]> wrote:
I think this line:
conn.open
Should be like this:
conn.open aConnectionString
You are not specifying a connection string while trying to open your
connection. That's what the error means.
Mark
kb1711 <[EMAIL PROTECTED]> wrote:
hi i am getting this error when i am trying to connect my asp page
with the db which has 2 tables.
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Driver Manager] Data source name not found and no
default driver specified
my code
<%@ Language=VBscript %>
<% option explicit %>
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta http-equiv="Content-Type" content="text/html; charset=windows-
1252">
<title>All the values with an asterisk</title>
<meta name="Microsoft Theme" content="compass 1011">
</head>
<body>
<%
dim serialnumber
dim modelnumber
dim description
dim errorMsg
dim i
dim conn
dim SQL
dim R
dim RecsAffected
dim aConnectionString
dim adModeReadWrite
dim adUseClient
if Request.ServerVariables("REQUEST_METHOD")="POST" THEN
serialnumber = Request.Form("serialnumber")
modelnumber = Request.Form("modelnumber")
description = Request.Form("description")
serialnumber = trim(serialnumber)
modelnumber = trim(modelnumber)
description = trim(description)
if len(serialnumber)=0 then
errorMsg = "You must enter the serial number"
else
for i=1 to len(serialnumber)
if instr(1,"abcdefghijklmnopqrstuvwxyz-*" ,mid
(serialnumber,i,1),vbTextcompare)=0 then
errorMsg="serial number is not valid"
exit for
end if
next
end if
if len(errorMsg)=0 then
if len(modelnumber)=0 then
errorMsg = "You must enter the model number"
else
for i=1 to len(modelnumber)
if instr(1,"abcdefghijklmnopqrstuvwxyz-*'", mid
(modelnumber,i,1),vbTextcompare)=0 then
errorMsg="model number is not valid"
exit for
end if
next
end if
end if
if len(errorMsg)=0 then
Response.Write "Serial Number=" & serialnumber
Response.Write "Model Number=" & modelnumber
Response.Write "Description=" & description
end if
if len(errorMsg)= 0 then
aConnectionString= "Provider=SQLOLEDB;Data"
& "Source=(local);Database=ClassRecords;"
& UID=sa;PWD=;"
set conn=Server.CreateObject("ADODB.Connection")
conn.Mode=adModeReadWrite
conn.ConnectionString=adUseClient
conn.open
conn.BeginTrans
SQL="INSERT INTO inventory (serialnumber,modelnumber,description)
values("& serialnumber & ", " & modelnumber & ", '" & description
& "')"
conn.Execute SQL
if conn.Error.Count = 0 Then
conn.CommitTran
Else
conn.RollbackTrans
end if
conn.close
set conn=Nothing
end if
end if
%>
<p><i>All the fields with asterisk(<font color="#FF0000">*</font>)
sign are
<font color="#FF0000">mandatory</font></i></p>
<p></p>
<form name= "frmuserInfo" action= "inventory.asp" method= "post">
<%if len(errorMsg)>0 then
Response.Write "<p><font color = red> "& errorMsg & "</font></p>"
end if
%>
<table border="0" cellpadding="0" cellspacing="0" width="40%">
<tr>
<td width="30%"><b>Serial number</b></td>
<td colspan="2"><b><input type="text" name="Serialnumber" value="<%
=serialnumber %>"></b></td>
</tr>
<tr>
<td ><b>Model number</b></td>
<td colspan="2"><b><input type="text" name="modelnumber" value="<%
=modelnumber %>"></b></td>
</tr>
<tr>
<td><b>Description</b></td>
<td colspan="2">
<select >
<option selected value="none">none</option>
<option value="keyboard">Keyboard</option>
<option value="scanner">scanner</option>
<option value="fingerprintreader">finger print reader</option>
</select><p>
</tr>
<tr>
<td align=center> </td>
<td align=center width=110><input name="Submit" type=submit
value="Submit"></td>
<td align=center width=100><input name="Reset" type=reset
value="Reset"></td>
</tr>
</table>
</form>
</body>
</html>
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
Get unlimited calls to
U.S./Canada
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Check out the new Yahoo! Front Page. www.yahoo.com
[Non-text portions of this message have been removed]
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Check out the new Yahoo! Front Page. www.yahoo.com
[Non-text portions of this message have been removed]
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
---------------------------------
Do you Yahoo!?
Check out the new Yahoo! Front Page. www.yahoo.com
[Non-text portions of this message have been removed]
Yahoo! Groups SponsorADVERTISEMENT
---------------------------------
Yahoo! Groups Links
To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar.
Now with Pop-Up Blocker. Get it for free!
http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/saFolB/TM
--------------------------------------------------------------------~->
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/AspClassicAnyQuestionIsOk/
<*> To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/
