FrontPage Wizard Error

Utilized FrontPage 2003 Database Wizard to create an online feedback form.
The Submission form indicates that everything transferred smoothly to the
database. BUT.
When I ask to see the results online or edit the database content I receive
the following error.

Database Results Wizard Error
The operation failed. If this continues, please contact your server
administrator.

I've checked the ODBC connection on the server and nothing appears to be
wrong.
Any ideas?

Dave

Re: FrontPage Wizard Error

You will probably get more help in the FrontPage group -
microsoft.public.frontpage.client.

I don't imagine many, if any, people here use Wizards - let alone FP
Wizards - to code ASP.

Bob Lehmann

"H8ids" wrote in message
news:edCmvPrwEHA.1976@TK2MSFTNGP09.phx.gbl...
> Utilized FrontPage 2003 Database Wizard to create an online feedback form.
> The Submission form indicates that everything transferred smoothly to the
> database. BUT.
> When I ask to see the results online or edit the database content I
receive
> the following error.
>
> Database Results Wizard Error
> The operation failed. If this continues, please contact your server
> administrator.
>
> I've checked the ODBC connection on the server and nothing appears to be
> wrong.
> Any ideas?
>
> Dave
>
>
>

Re: FrontPage Wizard Error

Thanks Bob, so far the Wizard hasn't been much help for a beginning coder.

"Bob Lehmann" wrote in message
news:OgdoWt0wEHA.2732@TK2MSFTNGP12.phx.gbl...
> You will probably get more help in the FrontPage group -
> microsoft.public.frontpage.client.
>
> I don't imagine many, if any, people here use Wizards - let alone FP
> Wizards - to code ASP.
>
> Bob Lehmann
>
> "H8ids" wrote in message
> news:edCmvPrwEHA.1976@TK2MSFTNGP09.phx.gbl...
>> Utilized FrontPage 2003 Database Wizard to create an online feedback
>> form.
>> The Submission form indicates that everything transferred smoothly to the
>> database. BUT.
>> When I ask to see the results online or edit the database content I
> receive
>> the following error.
>>
>> Database Results Wizard Error
>> The operation failed. If this continues, please contact your server
>> administrator.
>>
>> I've checked the ODBC connection on the server and nothing appears to be
>> wrong.
>> Any ideas?
>>
>> Dave
>>
>>
>>
>
>

Re: FrontPage Wizard Error

It's not much help, for anybody. Even in the FP group you'll get answers
like - change the grey code, but not the green code inside the bot tags,
blah blah blah...

You should try writing it on your own, and post questions here as they come
up.

Bob Lehmann

"H8ids" wrote in message
news:#mwMsg1wEHA.2908@tk2msftngp13.phx.gbl...
> Thanks Bob, so far the Wizard hasn't been much help for a beginning coder.
>
> "Bob Lehmann" wrote in message
> news:OgdoWt0wEHA.2732@TK2MSFTNGP12.phx.gbl...
> > You will probably get more help in the FrontPage group -
> > microsoft.public.frontpage.client.
> >
> > I don't imagine many, if any, people here use Wizards - let alone FP
> > Wizards - to code ASP.
> >
> > Bob Lehmann
> >
> > "H8ids" wrote in message
> > news:edCmvPrwEHA.1976@TK2MSFTNGP09.phx.gbl...
> >> Utilized FrontPage 2003 Database Wizard to create an online feedback
> >> form.
> >> The Submission form indicates that everything transferred smoothly to
the
> >> database. BUT.
> >> When I ask to see the results online or edit the database content I
> > receive
> >> the following error.
> >>
> >> Database Results Wizard Error
> >> The operation failed. If this continues, please contact your server
> >> administrator.
> >>
> >> I've checked the ODBC connection on the server and nothing appears to
be
> >> wrong.
> >> Any ideas?
> >>
> >> Dave
> >>
> >>
> >>
> >
> >
>
>

Re: FrontPage Wizard Error

I am a newbie in a process of learning ASP coding. By trial & error - and
generous help from anonymous friends in the online community - I am
gradually getting there. However, I would recommend one wizard which has
helped me to learn ASP. It's called ASPWizard. It generates clean code
(unlike FP) and has it own little SQL manager for those who are unfamiliar
with that kind of statements. It also has a CSS manager.

"Bob Lehmann" wrote in message
news:OgdoWt0wEHA.2732@TK2MSFTNGP12.phx.gbl...
>
> I don't imagine many, if any, people here use Wizards - let alone FP
> Wizards - to code ASP.
>
> Bob Lehmann
>
> "H8ids" wrote in message
> news:edCmvPrwEHA.1976@TK2MSFTNGP09.phx.gbl...
>> Utilized FrontPage 2003 Database Wizard to create an online feedback
>> form.
>> The Submission form indicates that everything transferred smoothly to the
>> database. BUT.
>> When I ask to see the results online or edit the database content I
> receive
>> the following error.
>>
>> Database Results Wizard Error
>> The operation failed. If this continues, please contact your server
>> administrator.
>>
>> I've checked the ODBC connection on the server and nothing appears to be
>> wrong.
>> Any ideas?
>>
>> Dave
>>
>>
>>
>
>

Re: FrontPage Wizard Error

Follow the spooky diet at www.outfront.net/spooky/ if you wish to persist
with the DRW
It makes it a bit easier to modify.

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


"H8ids" wrote in message
news:#mwMsg1wEHA.2908@tk2msftngp13.phx.gbl...
> Thanks Bob, so far the Wizard hasn't been much help for a beginning coder.
>
> "Bob Lehmann" wrote in message
> news:OgdoWt0wEHA.2732@TK2MSFTNGP12.phx.gbl...
> > You will probably get more help in the FrontPage group -
> > microsoft.public.frontpage.client.
> >
> > I don't imagine many, if any, people here use Wizards - let alone FP
> > Wizards - to code ASP.
> >
> > Bob Lehmann
> >
> > "H8ids" wrote in message
> > news:edCmvPrwEHA.1976@TK2MSFTNGP09.phx.gbl...
> >> Utilized FrontPage 2003 Database Wizard to create an online feedback
> >> form.
> >> The Submission form indicates that everything transferred smoothly to
the
> >> database. BUT.
> >> When I ask to see the results online or edit the database content I
> > receive
> >> the following error.
> >>
> >> Database Results Wizard Error
> >> The operation failed. If this continues, please contact your server
> >> administrator.
> >>
> >> I've checked the ODBC connection on the server and nothing appears to
be
> >> wrong.
> >> Any ideas?
> >>
> >> Dave
> >>
> >>
> >>
> >
> >
>
>

Re: FrontPage Wizard Error

Nice, I'll check it out.



"TB" wrote in message
news:elcdupJxEHA.2568@TK2MSFTNGP11.phx.gbl...
>I am a newbie in a process of learning ASP coding. By trial & error - and
>generous help from anonymous friends in the online community - I am
>gradually getting there. However, I would recommend one wizard which has
>helped me to learn ASP. It's called ASPWizard. It generates clean code
>(unlike FP) and has it own little SQL manager for those who are unfamiliar
>with that kind of statements. It also has a CSS manager.
>
> "Bob Lehmann" wrote in message
> news:OgdoWt0wEHA.2732@TK2MSFTNGP12.phx.gbl...
>>
>> I don't imagine many, if any, people here use Wizards - let alone FP
>> Wizards - to code ASP.
>>
>> Bob Lehmann
>>
>> "H8ids" wrote in message
>> news:edCmvPrwEHA.1976@TK2MSFTNGP09.phx.gbl...
>>> Utilized FrontPage 2003 Database Wizard to create an online feedback
>>> form.
>>> The Submission form indicates that everything transferred smoothly to
>>> the
>>> database. BUT.
>>> When I ask to see the results online or edit the database content I
>> receive
>>> the following error.
>>>
>>> Database Results Wizard Error
>>> The operation failed. If this continues, please contact your server
>>> administrator.
>>>
>>> I've checked the ODBC connection on the server and nothing appears to be
>>> wrong.
>>> Any ideas?
>>>
>>> Dave
>>>
>>>
>>>
>>
>>
>
>

Re: FrontPage Wizard Error

Adjusted the code and now I'm seeing.

Database Results Wizard Error
The database connection named 'coursevbscriptresults' is undefined.

This problem can occur if:
* the connection has been removed from the web
* the file 'global.asa' is missing or contains errors
* the root folder does not have Scripting permissions enabled
* the web is not marked as an Application Root

I did check the ODBC set-up; it is directed toward the FrontPage generated
database. Folder permissions are set for writing and editting the database.
The "Global.asa" is in the location which it had been originally saved.

I don't understand what the following means.
* the connection has been removed from the web

Also, does the following refer to having the database in the wwwroot folder?
* the web is not marked as an Application Root

Thanks for your assistance.
Dave


"dave" wrote in message
news:OB8lF9LxEHA.3144@TK2MSFTNGP15.phx.gbl...
> Follow the spooky diet at www.outfront.net/spooky/ if you wish to persist
> with the DRW
> It makes it a bit easier to modify.
>
> 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
>
>
> "H8ids" wrote in message
> news:#mwMsg1wEHA.2908@tk2msftngp13.phx.gbl...
>> Thanks Bob, so far the Wizard hasn't been much help for a beginning
>> coder.
>>
>> "Bob Lehmann" wrote in message
>> news:OgdoWt0wEHA.2732@TK2MSFTNGP12.phx.gbl...
>> > You will probably get more help in the FrontPage group -
>> > microsoft.public.frontpage.client.
>> >
>> > I don't imagine many, if any, people here use Wizards - let alone FP
>> > Wizards - to code ASP.
>> >
>> > Bob Lehmann
>> >
>> > "H8ids" wrote in message
>> > news:edCmvPrwEHA.1976@TK2MSFTNGP09.phx.gbl...
>> >> Utilized FrontPage 2003 Database Wizard to create an online feedback
>> >> form.
>> >> The Submission form indicates that everything transferred smoothly to
> the
>> >> database. BUT.
>> >> When I ask to see the results online or edit the database content I
>> > receive
>> >> the following error.
>> >>
>> >> Database Results Wizard Error
>> >> The operation failed. If this continues, please contact your server
>> >> administrator.
>> >>
>> >> I've checked the ODBC connection on the server and nothing appears to
> be
>> >> wrong.
>> >> Any ideas?
>> >>
>> >> Dave
>> >>
>> >>
>> >>
>> >
>> >
>>
>>
>
>

Re: FrontPage Wizard Error

If you open your global.asa file, you may find a connection string like so :

Application("coursevbscriptresults_ConnectionString") = "....

If so, create a new asp page and save it to your root.
Place in it, this simple asp code :

Connection = <%=Application("coursevbscriptresults_ConnectionString") %>

When you open the page in your browser, does it show the connection string?



"H8ids" wrote in message
news:uBFQW7dxEHA.1168@TK2MSFTNGP10.phx.gbl...
> Adjusted the code and now I'm seeing.
>
> Database Results Wizard Error
> The database connection named 'coursevbscriptresults' is undefined.
>
> This problem can occur if:
> * the connection has been removed from the web
> * the file 'global.asa' is missing or contains errors
> * the root folder does not have Scripting permissions enabled
> * the web is not marked as an Application Root
>
> I did check the ODBC set-up; it is directed toward the FrontPage generated
> database. Folder permissions are set for writing and editting the
database.
> The "Global.asa" is in the location which it had been originally saved.
>
> I don't understand what the following means.
> * the connection has been removed from the web
>
> Also, does the following refer to having the database in the wwwroot
folder?
> * the web is not marked as an Application Root
>
> Thanks for your assistance.
> Dave
>
>
> "dave" wrote in message
> news:OB8lF9LxEHA.3144@TK2MSFTNGP15.phx.gbl...
> > Follow the spooky diet at www.outfront.net/spooky/ if you wish to
persist
> > with the DRW
> > It makes it a bit easier to modify.
> >
> > 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
> >
> >
> > "H8ids" wrote in message
> > news:#mwMsg1wEHA.2908@tk2msftngp13.phx.gbl...
> >> Thanks Bob, so far the Wizard hasn't been much help for a beginning
> >> coder.
> >>
> >> "Bob Lehmann" wrote in message
> >> news:OgdoWt0wEHA.2732@TK2MSFTNGP12.phx.gbl...
> >> > You will probably get more help in the FrontPage group -
> >> > microsoft.public.frontpage.client.
> >> >
> >> > I don't imagine many, if any, people here use Wizards - let alone FP
> >> > Wizards - to code ASP.
> >> >
> >> > Bob Lehmann
> >> >
> >> > "H8ids" wrote in message
> >> > news:edCmvPrwEHA.1976@TK2MSFTNGP09.phx.gbl...
> >> >> Utilized FrontPage 2003 Database Wizard to create an online feedback
> >> >> form.
> >> >> The Submission form indicates that everything transferred smoothly
to
> > the
> >> >> database. BUT.
> >> >> When I ask to see the results online or edit the database content I
> >> > receive
> >> >> the following error.
> >> >>
> >> >> Database Results Wizard Error
> >> >> The operation failed. If this continues, please contact your server
> >> >> administrator.
> >> >>
> >> >> I've checked the ODBC connection on the server and nothing appears
to
> > be
> >> >> wrong.
> >> >> Any ideas?
> >> >>
> >> >> Dave
> >> >>
> >> >>
> >> >>
> >> >
> >> >
> >>
> >>
> >
> >
>
>