Database interface wizard problem
« Start of topic « Older Messages 1 - 8 of 8 Newer » End of
topic »
Fixed font - Proportional font
1. shaid Oct 9, 3:14 pm show options
Newsgroups: microsoft.public.frontpage.programming
From: "shaid" <
[email protected]> - Find messages by this author
Date: 9 Oct 2005 06:14:09 -0700
Local: Sun, Oct 9 2005 3:14 pm
Subject: Database interface wizard problem
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse
Hi,
I'm trying to create a connection to an sql server database using the
Database interface wizard. After locating the site and follwing the
wizard directions, i'm trying to open the result page from the website
but no results are shown and i get the following message:
"Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator."
Submiting data to the database is not working either, and no data
available also while using the editor option.
What is the problem and How can i use the wizard proparly and get some
results?
Thanks,
Shai
Reply
2. Kathleen Anderson [MVP - FrontPage] Oct 9, 3:18 pm show
options
Newsgroups: microsoft.public.frontpage.programming
From: "Kathleen Anderson [MVP - FrontPage]" <
[email protected]> -
Find messages by this author
Date: Sun, 9 Oct 2005 09:18:52 -0400
Local: Sun, Oct 9 2005 3:18 pm
Subject: Re: Database interface wizard problem
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse
What version of FrontPage and what service packs have you applied?
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
- Hide quoted text -
- Show quoted text -
I'm trying to create a connection to an sql server database using the
Database interface wizard. After locating the site and follwing the
wizard directions, i'm trying to open the result page from the website
but no results are shown and i get the following message:
"Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator."
Submiting data to the database is not working either, and no data
available also while using the editor option.
What is the problem and How can i use the wizard proparly and get some
results?
Shai
Reply
3. shaid Oct 9, 3:37 pm show options
Newsgroups: microsoft.public.frontpage.programming
From: "shaid" <
[email protected]> - Find messages by this author
Date: 9 Oct 2005 06:37:32 -0700
Local: Sun, Oct 9 2005 3:37 pm
Subject: Re: Database interface wizard problem
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse
Hi Kathleen,
I'm using FrontPage 2003 with SP2
Thanks,
Shai
Reply
4. Kathleen Anderson [MVP - FrontPage] Oct 9, 4:07 pm show
options
Newsgroups: microsoft.public.frontpage.programming
From: "Kathleen Anderson [MVP - FrontPage]" <
[email protected]> -
Find messages by this author
Date: Sun, 9 Oct 2005 10:07:57 -0400
Local: Sun, Oct 9 2005 4:07 pm
Subject: Re: Database interface wizard problem
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse
Shai:
Please do not snip previous posts - it makes it hard to follow the
thread.
The FP2003 code has changed slightly. To see the true error, open the
hidden
folder /_fpclass/ and edit the fpdbrgn1.inc file
At about line 19, change :
fp_DEBUG = False
to :
fp_DEBUG = True
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
- Hide quoted text -
- Show quoted text -
I'm using FrontPage 2003 with SP2
Thanks,
Shai
Reply
5. shaid Oct 9, 4:29 pm show options
Newsgroups: microsoft.public.frontpage.programming
From: "shaid" <
[email protected]> - Find messages by this author
Date: 9 Oct 2005 07:29:27 -0700
Local: Sun, Oct 9 2005 4:29 pm
Subject: Re: Database interface wizard problem
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse
Hi Kathleen,
Now i get a different error message:
"Database Results Wizard Error
Invalid authorization specification."
Shai
Reply
6. Kathleen Anderson [MVP - FrontPage] Oct 9, 4:34 pm show
options
Newsgroups: microsoft.public.frontpage.programming
From: "Kathleen Anderson [MVP - FrontPage]" <
[email protected]> -
Find messages by this author
Date: Sun, 9 Oct 2005 10:34:57 -0400
Local: Sun, Oct 9 2005 4:34 pm
Subject: Re: Database interface wizard problem
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse
Shai:
Please do not snip previous posts - it makes it hard to follow the
thread.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
- Hide quoted text -
- Show quoted text -
Now i get a different error message:
"Database Results Wizard Error
Invalid authorization specification."
Shai
Reply
7. shaid Oct 9, 4:52 pm show options
Newsgroups: microsoft.public.frontpage.programming
From: "shaid" <
[email protected]> - Find messages by this author
Date: 9 Oct 2005 07:52:27 -0700
Local: Sun, Oct 9 2005 4:52 pm
Subject: Re: Database interface wizard problem
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse
Hi,
I'm trying to create a connection to an sql server database using the
Database interface wizard. After locating the site and follwing the
wizard directions, i'm trying to open the result page from the website
but no results are shown and i get the following message:
"Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator."
Submiting data to the database is not working either, and no data
available also while using the editor option.
What is the problem and How can i use the wizard proparly and get some
results?
Thanks,
Shai
Reply
Kathleen Anderson [MVP - FrontPage] Oct 9, 3:18 pm show options
Newsgroups: microsoft.public.frontpage.programming
From: "Kathleen Anderson [MVP - FrontPage]" <
[email protected]> -
Find messages by this author
Date: Sun, 9 Oct 2005 09:18:52 -0400
Local: Sun, Oct 9 2005 3:18 pm
Subject: Re: Database interface wizard problem
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse
What version of FrontPage and what service packs have you applied?
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
- Hide quoted text -
- Show quoted text -
Hi,
I'm trying to create a connection to an sql server database using the
Database interface wizard. After locating the site and follwing the
wizard directions, i'm trying to open the result page from the website
but no results are shown and i get the following message:
"Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator."
Submiting data to the database is not working either, and no data
available also while using the editor option.
What is the problem and How can i use the wizard proparly and get some
results?
Thanks,
Shai
Reply
shaid Oct 9, 3:37 pm show options
Newsgroups: microsoft.public.frontpage.programming
From: "shaid" <
[email protected]> - Find messages by this author
Date: 9 Oct 2005 06:37:32 -0700
Local: Sun, Oct 9 2005 3:37 pm
Subject: Re: Database interface wizard problem
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse
Hi Kathleen,
I'm using FrontPage 2003 with SP2
Thanks,
Shai
Reply
Kathleen Anderson [MVP - FrontPage] Oct 9, 4:07 pm show options
Newsgroups: microsoft.public.frontpage.programming
From: "Kathleen Anderson [MVP - FrontPage]" <
[email protected]> -
Find messages by this author
Date: Sun, 9 Oct 2005 10:07:57 -0400
Local: Sun, Oct 9 2005 4:07 pm
Subject: Re: Database interface wizard problem
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse
Shai:
Please do not snip previous posts - it makes it hard to follow the
thread.
The FP2003 code has changed slightly. To see the true error, open the
hidden
folder /_fpclass/ and edit the fpdbrgn1.inc file
At about line 19, change :
fp_DEBUG = False
to :
fp_DEBUG = True
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
- Hide quoted text -
- Show quoted text -
Hi Kathleen,
I'm using FrontPage 2003 with SP2
Thanks,
Shai
Reply
shaid Oct 9, 4:29 pm show options
Newsgroups: microsoft.public.frontpage.programming
From: "shaid" <
[email protected]> - Find messages by this author
Date: 9 Oct 2005 07:29:27 -0700
Local: Sun, Oct 9 2005 4:29 pm
Subject: Re: Database interface wizard problem
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Remove | Report Abuse
Hi Kathleen,
Now i get a different error message:
"Database Results Wizard Error
Invalid authorization specification."
Shai
Reply
8. Kathleen Anderson [MVP - FrontPage] Oct 9, 5:17 pm show
options
Newsgroups: microsoft.public.frontpage.programming
From: "Kathleen Anderson [MVP - FrontPage]" <
[email protected]> -
Find messages by this author
Date: Sun, 9 Oct 2005 11:17:45 -0400
Local: Sun, Oct 9 2005 5:17 pm
Subject: Re: Database interface wizard problem
Reply | Reply to Author | Forward | Print | Individual Message | Show
original | Report Abuse
- Hide quoted text -
- Show quoted text -
I'm trying to create a connection to an sql server database using the
Database interface wizard. After locating the site and follwing the
wizard directions, i'm trying to open the result page from the website
but no results are shown and i get the following message:
"Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator."
Submiting data to the database is not working either, and no data
available also while using the editor option.
What is the problem and How can i use the wizard proparly and get some
results?
Shai
Kathleen Anderson [MVP - FrontPage] Oct 9, 3:18 pm show options
What version of FrontPage and what service packs have you applied?
Hi Kathleen,
I'm using FrontPage 2003 with SP2
The FP2003 code has changed slightly. To see the true error, open the
hidden
folder /_fpclass/ and edit the fpdbrgn1.inc file
At about line 19, change :
fp_DEBUG = False
to :
fp_DEBUG = True
Hi Kathleen,
Now i get a different error message:
"Database Results Wizard Error
Invalid authorization specification."
Shai:
Much better - thanks! (I did clean it up a bit).
My guess would be that either you don't have the required
username/password
specified in your database connection - take a look at the global.asa
to see
if this is true, or, you are using a reserved word that's allowed in
Access
but not for SQL server. This page:
http://pacosdrivers.com/asp/reserved/ has
a list of SQL Reserved Words - watch the pop-ups.
--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
web:
http://www.spiderwebwoman.com/resources/
Kathleen,
What kind of user name and password do i need?
It's still doesn't work when i'm using my administrator user and
password to the sql server.
Shai
