If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Error trying to connect to Access Database
Hi Dee
Douglas has given you a few ideas - have you tried them. Also look at the site and see if any of the items refer to your DB. http://www.webwizguide.com/asp/faq/a...tabase_faq.asp why would it make a difference if I was running this in front page, this is how I am designing the web site. If you are designing a DB to use in a frontpage web you should seign the DB "then" include it into the web. You may find it difficult to get into the DB from Frontpage as you need to be running access to get into an Access DB with the corect permissions. -- Wayne Manchester, England. Enjoy whatever it is you do "Dee" wrote: Yes, I am the administrator. I am building a web site on my local machine. I have access and sql logging in with the windows administrator. why would it make a difference if I was running this in front page, this is how I am designing the web site. Thank you Dee "Dee" wrote: This is what is in the calendar_script.asp string with line 35 objConn.Execute(strSQL) Set objRS = Nothing objConn.Close Set objConn = Nothing I do not know how to check IUSR_machinename. The directory, folders, etc., I took the read only off. How do you set that for RWXD. I know how to do this lin Unix and Linux, but not in windows. Thanks Dee "Douglas J. Steele" wrote: Without knowing what line 35 in updateCalendar_script.asp is, it's pretty hard to suggest anything. Does the application work otherwise? Are you able to apply any updates to the database? If not, does the security context running the ASP page (usually IUSR_machinename) have the necessary permissions (RWXD) on the folder where the MDB file is located? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message ... I am getting the following error when trying to connect to my access database: Technical Information (for support personnel) Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /saveyonce/calendar/updateCalendar_script.asp, line 35 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) Page: POST 62 bytes to /saveyonce/calendar/updateCalendar_script.asp POST Data: calendarText=Darlene+-+color+10%3A00¤tDate=10%2F7%2F2006 Time: Saturday, October 07, 2006, 1:14:27 PM More information: Microsoft Support I am running windows xp sp2, Office 2003. I have down loaded all updates for windows and office, made sure the folders are not read only. made sure the database is 2002-2003, went to %systemroot%:\Program Files\Common Files\System\Ole db and typed regsvr32 sqloledb.dll. I do not know what else to do, and I am trying to get a web site done. Also I am using frontpage 2003, why is it my .asp files do not run in any other browser. When creating a web site I test the most important browsers. In this case it wants to open or save the file. Thank you Dee |
#12
|
|||
|
|||
Error trying to connect to Access Database
I have done what Douglas has stated, but I do not have a security tab when I
click on the properties tab. I am also reading from the link you sent me. How do I get this to run outside of front page, it needs to be in the inetpub directory. when I try to run this in netscape it want to open the .asp file or save it. Thanks Dee "Wayne-I-M" wrote: Hi Dee Douglas has given you a few ideas - have you tried them. Also look at the site and see if any of the items refer to your DB. http://www.webwizguide.com/asp/faq/a...tabase_faq.asp why would it make a difference if I was running this in front page, this is how I am designing the web site. If you are designing a DB to use in a frontpage web you should seign the DB "then" include it into the web. You may find it difficult to get into the DB from Frontpage as you need to be running access to get into an Access DB with the corect permissions. -- Wayne Manchester, England. Enjoy whatever it is you do "Dee" wrote: Yes, I am the administrator. I am building a web site on my local machine. I have access and sql logging in with the windows administrator. why would it make a difference if I was running this in front page, this is how I am designing the web site. Thank you Dee "Dee" wrote: This is what is in the calendar_script.asp string with line 35 objConn.Execute(strSQL) Set objRS = Nothing objConn.Close Set objConn = Nothing I do not know how to check IUSR_machinename. The directory, folders, etc., I took the read only off. How do you set that for RWXD. I know how to do this lin Unix and Linux, but not in windows. Thanks Dee "Douglas J. Steele" wrote: Without knowing what line 35 in updateCalendar_script.asp is, it's pretty hard to suggest anything. Does the application work otherwise? Are you able to apply any updates to the database? If not, does the security context running the ASP page (usually IUSR_machinename) have the necessary permissions (RWXD) on the folder where the MDB file is located? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message ... I am getting the following error when trying to connect to my access database: Technical Information (for support personnel) Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /saveyonce/calendar/updateCalendar_script.asp, line 35 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) Page: POST 62 bytes to /saveyonce/calendar/updateCalendar_script.asp POST Data: calendarText=Darlene+-+color+10%3A00¤tDate=10%2F7%2F2006 Time: Saturday, October 07, 2006, 1:14:27 PM More information: Microsoft Support I am running windows xp sp2, Office 2003. I have down loaded all updates for windows and office, made sure the folders are not read only. made sure the database is 2002-2003, went to %systemroot%:\Program Files\Common Files\System\Ole db and typed regsvr32 sqloledb.dll. I do not know what else to do, and I am trying to get a web site done. Also I am using frontpage 2003, why is it my .asp files do not run in any other browser. When creating a web site I test the most important browsers. In this case it wants to open or save the file. Thank you Dee |
#13
|
|||
|
|||
Error trying to connect to Access Database
Thats not the way access db's work in frontpage.
Create your db Create your web Create a subweb Load the FP server extentions Import the access db into the web Create the page that will access the db in frontpage Select the imported db as the source. You will not be able to get into the db from frontpage. You need to run Access to open the DB. Oh. There is a great deal of info regarding this subject on the knowldge base in the MS website. I have only created 2 websites that use access (I use them to store the usernames and passwords) but I am not really that good with frontpage so I did what most people do and that is to simply follow the MS site knowdgebase articales word for word. Good luck with your project. Hope this helps - saturday night - off out - taxi is booked for 5 mins. -- Wayne Manchester, England. Enjoy whatever it is you do "Dee" wrote: I have done what Douglas has stated, but I do not have a security tab when I click on the properties tab. I am also reading from the link you sent me. How do I get this to run outside of front page, it needs to be in the inetpub directory. when I try to run this in netscape it want to open the .asp file or save it. Thanks Dee "Wayne-I-M" wrote: Hi Dee Douglas has given you a few ideas - have you tried them. Also look at the site and see if any of the items refer to your DB. http://www.webwizguide.com/asp/faq/a...tabase_faq.asp why would it make a difference if I was running this in front page, this is how I am designing the web site. If you are designing a DB to use in a frontpage web you should seign the DB "then" include it into the web. You may find it difficult to get into the DB from Frontpage as you need to be running access to get into an Access DB with the corect permissions. -- Wayne Manchester, England. Enjoy whatever it is you do "Dee" wrote: Yes, I am the administrator. I am building a web site on my local machine. I have access and sql logging in with the windows administrator. why would it make a difference if I was running this in front page, this is how I am designing the web site. Thank you Dee "Dee" wrote: This is what is in the calendar_script.asp string with line 35 objConn.Execute(strSQL) Set objRS = Nothing objConn.Close Set objConn = Nothing I do not know how to check IUSR_machinename. The directory, folders, etc., I took the read only off. How do you set that for RWXD. I know how to do this lin Unix and Linux, but not in windows. Thanks Dee "Douglas J. Steele" wrote: Without knowing what line 35 in updateCalendar_script.asp is, it's pretty hard to suggest anything. Does the application work otherwise? Are you able to apply any updates to the database? If not, does the security context running the ASP page (usually IUSR_machinename) have the necessary permissions (RWXD) on the folder where the MDB file is located? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message ... I am getting the following error when trying to connect to my access database: Technical Information (for support personnel) Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /saveyonce/calendar/updateCalendar_script.asp, line 35 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) Page: POST 62 bytes to /saveyonce/calendar/updateCalendar_script.asp POST Data: calendarText=Darlene+-+color+10%3A00¤tDate=10%2F7%2F2006 Time: Saturday, October 07, 2006, 1:14:27 PM More information: Microsoft Support I am running windows xp sp2, Office 2003. I have down loaded all updates for windows and office, made sure the folders are not read only. made sure the database is 2002-2003, went to %systemroot%:\Program Files\Common Files\System\Ole db and typed regsvr32 sqloledb.dll. I do not know what else to do, and I am trying to get a web site done. Also I am using frontpage 2003, why is it my .asp files do not run in any other browser. When creating a web site I test the most important browsers. In this case it wants to open or save the file. Thank you Dee |
#14
|
|||
|
|||
Error trying to connect to Access Database
Oh just re-read your post - if you don't have the security tab as Douglas
suggested - you don't have the frontpage sever extentions or your ISP is running a linux system. In this case you have a BIG problem. Sorry. Linux systems will not support access db security tabs and they dont has the correct extentions. Contact your ISP for more info. |
#15
|
|||
|
|||
Error trying to connect to Access Database
Just read your note. I am running IIS on Windows XP SP2. FrontPage 2003 and
Access 2003. When I installed IIS, I asked for the front page extensions. I am fairly new to access. If you could please point me to the web site that tell you how to set up front page extentions and also the one that tells you how to create the database. I am not trying to get into the database from front page, the scripts are in front page and the database created in access. The need to update the database which I am doing from IE. Thanks Dee "Wayne-I-M" wrote: Thats not the way access db's work in frontpage. Create your db Create your web Create a subweb Load the FP server extentions Import the access db into the web Create the page that will access the db in frontpage Select the imported db as the source. You will not be able to get into the db from frontpage. You need to run Access to open the DB. Oh. There is a great deal of info regarding this subject on the knowldge base in the MS website. I have only created 2 websites that use access (I use them to store the usernames and passwords) but I am not really that good with frontpage so I did what most people do and that is to simply follow the MS site knowdgebase articales word for word. Good luck with your project. Hope this helps - saturday night - off out - taxi is booked for 5 mins. -- Wayne Manchester, England. Enjoy whatever it is you do "Dee" wrote: I have done what Douglas has stated, but I do not have a security tab when I click on the properties tab. I am also reading from the link you sent me. How do I get this to run outside of front page, it needs to be in the inetpub directory. when I try to run this in netscape it want to open the .asp file or save it. Thanks Dee "Wayne-I-M" wrote: Hi Dee Douglas has given you a few ideas - have you tried them. Also look at the site and see if any of the items refer to your DB. http://www.webwizguide.com/asp/faq/a...tabase_faq.asp why would it make a difference if I was running this in front page, this is how I am designing the web site. If you are designing a DB to use in a frontpage web you should seign the DB "then" include it into the web. You may find it difficult to get into the DB from Frontpage as you need to be running access to get into an Access DB with the corect permissions. -- Wayne Manchester, England. Enjoy whatever it is you do "Dee" wrote: Yes, I am the administrator. I am building a web site on my local machine. I have access and sql logging in with the windows administrator. why would it make a difference if I was running this in front page, this is how I am designing the web site. Thank you Dee "Dee" wrote: This is what is in the calendar_script.asp string with line 35 objConn.Execute(strSQL) Set objRS = Nothing objConn.Close Set objConn = Nothing I do not know how to check IUSR_machinename. The directory, folders, etc., I took the read only off. How do you set that for RWXD. I know how to do this lin Unix and Linux, but not in windows. Thanks Dee "Douglas J. Steele" wrote: Without knowing what line 35 in updateCalendar_script.asp is, it's pretty hard to suggest anything. Does the application work otherwise? Are you able to apply any updates to the database? If not, does the security context running the ASP page (usually IUSR_machinename) have the necessary permissions (RWXD) on the folder where the MDB file is located? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message ... I am getting the following error when trying to connect to my access database: Technical Information (for support personnel) Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /saveyonce/calendar/updateCalendar_script.asp, line 35 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) Page: POST 62 bytes to /saveyonce/calendar/updateCalendar_script.asp POST Data: calendarText=Darlene+-+color+10%3A00¤tDate=10%2F7%2F2006 Time: Saturday, October 07, 2006, 1:14:27 PM More information: Microsoft Support I am running windows xp sp2, Office 2003. I have down loaded all updates for windows and office, made sure the folders are not read only. made sure the database is 2002-2003, went to %systemroot%:\Program Files\Common Files\System\Ole db and typed regsvr32 sqloledb.dll. I do not know what else to do, and I am trying to get a web site done. Also I am using frontpage 2003, why is it my .asp files do not run in any other browser. When creating a web site I test the most important browsers. In this case it wants to open or save the file. Thank you Dee |
#16
|
|||
|
|||
Error trying to connect to Access Database
Hello,
Just wanted to let you know that I have fix my problem by going to the internet service manager. Thank both of you for your assistance. Dee "Wayne-I-M" wrote: Oh and you may want to check this site for info http://www.webwizguide.com/asp/faq/a...tabase_faq.asp -- Wayne Manchester, England. Enjoy whatever it is you do |
|
Thread Tools | |
Display Modes | |
|
|