Re: Frontpage-Desktop-Engine-SQL
From: Kevin Spencer (kevin_at_DIESPAMMERSDIEtakempis.com)
Date: 01/25/05
- Next message: Rick Budde: "Re: FP 2002"
- Previous message: Stefan B Rusynko: "Re: Frontpage 2000 synchronization"
- In reply to: Jim Warren: "Re: Frontpage-Desktop-Engine-SQL"
- Next in thread: Jim Warren: "Re: Frontpage-Desktop-Engine-SQL"
- Reply: Jim Warren: "Re: Frontpage-Desktop-Engine-SQL"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 25 Jan 2005 08:47:11 -0500
When you run ASP, you're not running under the System user, or yourself, as
you would be with an executable. The IUSer<machine name> anonymous Internet
User account has very few privileges. In order to insert or update or delete
records in an Access database, the account must have the necessary file
system permissions, as the database file is changed by the operation.
As to the MSDE errors, you would have to post the specific errors in order
for me to help. I'm not going to be helpful with FrontPage errors, as I
never use FrontPage to do database work (I write my own). But there are
people here who are familiar with the DRW and the FrontPage errors. I'm
hoping one of them will chime in.
I can help you with database errors that are "raw" (not intercepted aby
FrontPage and translated into something proprietary).
-- HTH, Kevin Spencer Microsoft MVP .Net Developer Neither a follower nor a lender be. "Jim Warren" <jwarrenatl25@comcast.net> wrote in message news:usOsRWnAFHA.1188@tk2msftngp13.phx.gbl... > There were some help.... I have managed to connect to a Access Database > and > run the ASP Page and get some Data-back, Ok... I tried connecting to a > local > SQL Database that I have on the Machine and made sure of the default > values. > I got a funny responce On a few of the tables Frontpage could not read the > table and gave me a error message- unable to connect to table. > > I could not delete or enter any new data into the database(Using Access) > the > tables would not move pass the last record,,, and allow me to enter > another > record. Which I think is a bit weird. Feels like i dont have ecusive > rights > to the database. but reality i do > > > I got the same error message when I try to connect to a local SQL > database, > so I am back to square one. The web Server is running fine and the test > intranet is working great.. just this asp problem. I can connect through > ODBC on the local database and extract data into Word Excel... ect.. > > > > "Kevin Spencer" <kevin@DIESPAMMERSDIEtakempis.com> wrote in message > news:OB75PMmAFHA.3840@tk2msftngp13.phx.gbl... >> I understand. MSDE I know about. Did you check the articles I mentioned? >> >> -- >> HTH, >> >> Kevin Spencer >> Microsoft MVP >> .Net Developer >> Neither a follower nor a lender be. >> >> "Jim Warren" <jwarrenatl25@comcast.net> wrote in message >> news:etOAM5lAFHA.3472@TK2MSFTNGP14.phx.gbl... >> > OR QUERY ON MSDE2000 >> > >> > >> > "Jim Warren" <jwarrenatl25@comcast.net> wrote in message >> > news:%23gT592lAFHA.4004@tk2msftngp13.phx.gbl... >> >> I have 3 PC's Running Windows XP Professional connected together in > it's >> > own >> >> intranet.(Remote Office). Offfice 2003 comes with a Light Version of > SQL >> >> 2000 Query Under MSDERe1a this will give you the info you are looking >> >> for...This Allow you to run a local copy of SQL and you add the >> >> service >> >> pac's to Server 2003 >> >> >> >> I need the standalone iis to function (I can't justfiy a standalone >> >> server)(users are at a remote site) and need them to be able to talk >> >> to >> > SQL >> >> so the user will have access to up to date information at their >> >> desktop >> > via >> >> asp pages querying off of local SQL Databases on The Server PC and >> >> then >> >> replication back to the home office via replication... or data >> >> transfer >> > once >> >> a day... The need access to the company's intranet.. at their office, >> > forms >> >> doucments, policys ect which will run off of the Server PC(Slim Down >> > Version >> >> is what they are getting) >> >> >> >> Thanks for your Help >> >> J >> >> >> >> >> >> >> >> "Kevin Spencer" <kevin@DIESPAMMERSDIEtakempis.com> wrote in message >> >> news:uXy4zJlAFHA.3376@TK2MSFTNGP12.phx.gbl... >> >> > That error message would preclude the error message that ASP is not >> >> running, >> >> > as it would not occur if ASP was not running. >> >> > >> >> > In fact, ASP IS running. >> >> > >> >> > You may find an answer in one of the 2 articles below: >> >> > >> >> > http://support.microsoft.com/default.aspx?scid=kb;en-us;828898 >> >> > http://support.microsoft.com/default.aspx?scid=kb;en-us;828905 >> >> > >> >> > I looked up the datbase you're using, but I couldn't find any > reference >> > to >> >> > it. I'm not saying you didn't get it from the Office 2003 > installation. >> > I >> >> > just couldn't find any mention of it on the MS Office web site. What > I >> > did >> >> > find (by Googling) is that it is a "light" version of SQL Server. >> >> > I'm >> > not >> >> > sure how you've deployed it in your app. As a matter of fact, I >> >> > still >> >> can't >> >> > figure out how your whole system is designed, whether you're running >> >> > off >> >> of >> >> > a local machine, an Internet web site, or what. Knowing that would >> >> > help. >> >> > >> >> > -- >> >> > HTH, >> >> > >> >> > Kevin Spencer >> >> > Microsoft MVP >> >> > .Net Developer >> >> > Neither a follower nor a lender be. >> >> > >> >> > "Jim Warren" <jwarrenatl25@comcast.net> wrote in message >> >> > news:OBgAyZkAFHA.3264@TK2MSFTNGP12.phx.gbl... >> >> > > Here is the acutal error message from the browser when I try to >> >> > > access >> >> the >> >> > > asp page >> >> > > >> >> > > J >> >> > > >> >> > > Database Results Wizard Error >> >> > > The operation failed. If this continues, please contact your >> >> > > server >> >> > > administrator. >> >> > > >> >> > > >> >> > > "Kevin Spencer" <kevin@DIESPAMMERSDIEtakempis.com> wrote in >> >> > > message >> >> > > news:eBObr4hAFHA.1084@tk2msftngp13.phx.gbl... >> >> > >> Hmm, seems I remember asking for you to post "the exact error, >> >> > >> and >> >> > > provided >> >> > >> the details I've been trying to fill in." In response to my >> > 7-paragraph >> >> > >> explanation and guesses, as well as a specific request for more >> >> > > information, >> >> > >> you reply with a single sentence. >> >> > >> >> >> > >> Well, I suppose I could go back and forth with you, prodding you > for >> >> each >> >> > >> piece of data, but Homey don't play dat. >> >> > >> >> >> > >> -- >> >> > >> HTH, >> >> > >> >> >> > >> Kevin Spencer >> >> > >> Microsoft MVP >> >> > >> .Net Developer >> >> > >> Neither a follower nor a lender be. >> >> > >> >> >> > >> "Jim Warren" <jwarrenatl25@comcast.net> wrote in message >> >> > >> news:uCIGPNhAFHA.3120@TK2MSFTNGP12.phx.gbl... >> >> > >> > Office 2003 Comes with SQL 16 LIc Version for your Desktop >> >> > >> > "Kevin Spencer" <kevin@DIESPAMMERSDIEtakempis.com> wrote in >> >> > >> > message >> >> > >> > news:%23t0bwHW$EHA.3416@TK2MSFTNGP09.phx.gbl... >> >> > >> >> Hi Jim, >> >> > >> >> >> >> > >> >> Oay, I'm a little confused. When you say "Im have installed > the >> >> > > desktop >> >> > >> >> engine" I am going to guess that by "the desktop engine" >> >> > >> >> you're >> >> > > referring >> >> > >> > to >> >> > >> >> MSDE. That much I can guess. "on a local machine" is kind of >> > fuzzy, >> >> > >> > though. >> >> > >> >> Local to what? Your home or office? Is your office an ISP > office, >> > or >> >> > > just >> >> > >> >> your office? And when you say "so a user can run SQL locally" >> >> > >> >> I >> > have >> >> > >> >> to >> >> > >> >> wonder what "a user" is, and what "run SQL locally" means. >> >> > >> >> That >> > is, >> >> > >> >> are >> >> > >> > you >> >> > >> >> talking about someone walking into your office, using the > "local >> >> > > machine" >> >> > >> >> and running MSDE on the machine on which it is installed? That >> > would >> >> > > not >> >> > >> > be >> >> > >> >> a problem. But if you mean a user somewhere in the cloud, I > have >> > to >> >> > >> >> wonder >> >> > >> >> how you plan on having them "run SQL locally." >> >> > >> >> >> >> > >> >> So, I'm going to take my best guess, and correct me if I'm > wrong >> > as >> >> I >> >> > >> >> rephrase your question: >> >> > >> >> >> >> > >> >> You've installed MSDE on some machine that is local to you. >> >> > >> >> You >> > want >> >> > >> > someone >> >> > >> >> in your office to be able to use it in a web site that they >> >> > >> >> are >> >> > >> >> publishing >> >> > >> >> from either the same machine or some other machine on the same >> > LAN. >> >> > >> >> Apparently, that person or yourself is creating some ASP page > on >> >> that >> >> > >> >> machine, and when they publish the web (to some unknown >> > destination, >> >> > >> > whether >> >> > >> >> server-based or file-based web site, you didn't say). When >> >> > >> >> they >> >> > >> >> do >> >> so, >> >> > >> > they >> >> > >> >> get an error, either during publishing, or when running the >> >> > >> >> ASP >> > page >> >> > > (you >> >> > >> >> didn't specify) that says something about ASP not running. It >> > would >> >> > > help >> >> > >> > if >> >> > >> >> you posted the exact error, and provided the details I've been >> >> trying >> >> > > to >> >> > >> >> fill in. >> >> > >> >> >> >> > >> >> -- >> >> > >> >> HTH, >> >> > >> >> >> >> > >> >> Kevin Spencer >> >> > >> >> Microsoft MVP >> >> > >> >> .Net Developer >> >> > >> >> Neither a follower nor a lender be. >> >> > >> >> >> >> > >> >> "Jim Warren" <jwarrenatl25@comcast.net> wrote in message >> >> > >> >> news:ufCbkiS$EHA.4092@TK2MSFTNGP09.phx.gbl... >> >> > >> >> >I have installed the desktop engine on a local machine so a > user >> >> can >> >> > > run >> >> > >> >> >SQL >> >> > >> >> > locally, I am using Frontpage 2003 and when they publish >> >> > >> >> > they >> > get >> >> an >> >> > >> > error >> >> > >> >> > message "Asp is not running Please find a Machine that is >> > running >> >> > > ASP" >> >> > >> >> > and >> >> > >> >> > will finish publishing and the site will work fine except > for >> > the >> >> > > ASP >> >> > >> >> > page. >> >> > >> >> > >> >> > >> >> > I am running iis 5.1 on this machine >> >> > >> >> > >> >> > >> >> > >> >> > >> >> >> >> > >> >> >> >> > >> > >> >> > >> > >> >> > >> >> >> > >> >> >> > > >> >> > > >> >> > >> >> > >> >> >> >> >> > >> > >> >> > >
- Next message: Rick Budde: "Re: FP 2002"
- Previous message: Stefan B Rusynko: "Re: Frontpage 2000 synchronization"
- In reply to: Jim Warren: "Re: Frontpage-Desktop-Engine-SQL"
- Next in thread: Jim Warren: "Re: Frontpage-Desktop-Engine-SQL"
- Reply: Jim Warren: "Re: Frontpage-Desktop-Engine-SQL"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
