re: Updating SQL Server database with FP03

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Jim Buyens (news_at_interlacken.com)
Date: 07/14/04 

Date: Wed, 14 Jul 2004 12:51:47 -0700

Howdy.

Just offhand, it looks as if the username/password you
specified isn't valid, at least not from teh computer
running the Web server.

Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
||---------------------------------------------------
|| Web Database Development Step by Step .NET Edition
|| Microsoft FrontPage Version 2002 Inside Out
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------

>-----Original Message-----
>Hi,
>
>I created a form using the DIW in FP03. First I created
>the connection using the site settings which was
>explained in a post. Then I chose the DIW. After the
>site is published I can see the Submission Form created
>and I can put data in the form, however, I can not get
>the form to update the database. I'm getting the
>following error. It looks like the problem stems from
>the fpdbnet.cs file. I'm clueless on how to fix this.
>
>The server running SQL Server is different than the
>server to which the uploading of the pages occurs. Not
>sure if that matters at all. The server that I am
>uploading to is a Sharepoint server.
>
>If someone can shed some light on this, I would grealty
>appreciate it.
>
>Thanks.
>
>Jason
>
>
>Invalid authorization specification
>Description: An unhandled exception occurred during the
>execution of the current web request. Please review the
>stack trace for more information about the error and
>where it originated in the code.
>
>Exception Details: System.Data.OleDb.OleDbException:
>Invalid authorization specification
>
>Source Error:
>
>
>Line 291:
>Line 292: try{
>Line 293: _dBConn.Open();
>Line 294: DataTable literalInfo =
>_dBConn.GetOleDbSchemaTable
>(OleDbSchemaGuid.DbInfoLiterals, null);
>Line 295: OdcbCommand.QuotePrefix =
>(String)literalInfo.Select("LiteralName='Quote_Prefix'")
>[0]["LiteralValue"];
>
>
>Source File: C:\Inetpub\wwwroot\Craterlake\srinitest1\7_14
>\_fpclass\fpdbnet.cs Line: 293"
>
>.
>

Relevant Pages

  • re: How do I delete published files?
    ... > facility, how do i delete them off the server? ... the remote server. ... Are you uploading by FTP? ... Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.client)
  • re: Updating SQL Server database with FP03
    ... Problem is there is no username ... access the form or access the SQL Server data. ... >Microsoft FrontPage MVP ...
    (microsoft.public.frontpage.programming)
  • Re: RFD: How To Recognize Bad Javascript Code v0.3
    ... misnomer because in practice it means "last uploaded to the server". ... It has nothing to do with "uploading". ... right options on "rsync" the file's last modified timestamp doesn't ...
    (comp.lang.javascript)
  • Re: File Permissions problem : Cry for HELP
    ... Me2resh Lists wrote: ... also about configuring the server i am uploading to, i dont think that there is something wrnog with the server cause when i upload the same files from windows, it works with no problems ... You need to change the umask used when you are saving web files. ... Depending on how you are uploading the files, ...
    (Fedora)
  • Re: FP2002 SP3 Publishing error need help "The server sent a response.
    ... Most people who install SP2 *don't* have this problem. ... Microsoft FrontPage MVP ... > "The server sent a response which FrontPage could not parse. ...
    (microsoft.public.frontpage.client)