Hello All...

Have a problem with an Access database which I've created
and imported into my FP 2000 web before uploading via LAN
to Windows Server 2003 running IIS6 with ASP & ASP.NET
enabled.

Problem was that form results weren't being
displayed...Now I am getting a response of "No records
returned"...

Help..I've been through everything I can think of, such as
importing the database, adding the connection as a File in
Current Web, Choosing the right record source and the
fields to display, but just no joy...

Anyone have any ideas - is there a service in IIS6 that
I've missed, is there something other than FPserver
extensions and ASP that needs to be installed on the
server??

In IIS6 on the Home Directory TAB, Script Source Access is
enabled as is read, and write...??

Not sure what you meant by "uploading via LAN" but you should PUBLISH the
site, to have everything working corectly.

--
HTH,
Kevin Spencer
..Net Developer
Microsoft MVP
Big things are made up
of lots of little things.

"Sim Marsh" <(E-Mail Removed)> wrote in message
news:010c01c3d948$e7291d90$(E-Mail Removed)...
> Hello All...
>
> Have a problem with an Access database which I've created
> and imported into my FP 2000 web before uploading via LAN
> to Windows Server 2003 running IIS6 with ASP & ASP.NET
> enabled.
>
> Problem was that form results weren't being
> displayed...Now I am getting a response of "No records
> returned"...
>
> Help..I've been through everything I can think of, such as
> importing the database, adding the connection as a File in
> Current Web, Choosing the right record source and the
> fields to display, but just no joy...
>
> Anyone have any ideas - is there a service in IIS6 that
> I've missed, is there something other than FPserver
> extensions and ASP that needs to be installed on the
> server??
>
> In IIS6 on the Home Directory TAB, Script Source Access is
> enabled as is read, and write...??

>-----Original Message-----
>Hello All...

Howdy.

>Have a problem with an Access database which I've created
>and imported into my FP 2000 web before uploading via LAN
>to Windows Server 2003 running IIS6 with ASP & ASP.NET
>enabled.
>
>Problem was that form results weren't being
>displayed...Now I am getting a response of "No records
>returned"...
>
>Help..I've been through everything I can think of, such
>as importing the database, adding the connection as a
>File in Current Web, Choosing the right record source and
>the fields to display, but just no joy...
>
>Anyone have any ideas - is there a service in IIS6 that
>I've missed, is there something other than FPserver
>extensions and ASP that needs to be installed on the
>server??
>
>In IIS6 on the Home Directory TAB, Script Source Access
>is enabled as is read, and write...??

Most likely your database is empty or your selection
criteria are incorrect.

To check for an empty database, open it in Access and make
sure the records you think should be there are, in fact,
present.

To check your selection criteria:

1. Double-click the Database Results Region.
2. Advance to page 3 of the wizard.
3. Click More Options and then Criteria.
4. Verify that the listed criteria are correct.

If the problem persists:

1. Restart the wizard and stop on page 2.
2. Select Custom Query and then click Edit.
3. Select the entire contents of the SQL Statement
test box, and post them to this thread.

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)
|/---------------------------------------------------
*----------------------------------------------------

Hi Jim thanks for your super speedy response...

Erm the Access Db is a very quick 5 line table that I
created as a test, so I take it that each numbered line in
the table counts as a record.

As far as Selection Criteria is concerned, I didn't
specify any because I had so few records to output.

Is this a vital part ??

Sim

>-----Original Message-----
>>-----Original Message-----
>>Hello All...
>
>Howdy.
>
>>Have a problem with an Access database which I've
created
>>and imported into my FP 2000 web before uploading via
LAN
>>to Windows Server 2003 running IIS6 with ASP & ASP.NET
>>enabled.
>>
>>Problem was that form results weren't being
>>displayed...Now I am getting a response of "No records
>>returned"...
>>
>>Help..I've been through everything I can think of, such
>>as importing the database, adding the connection as a
>>File in Current Web, Choosing the right record source and
>>the fields to display, but just no joy...
>>
>>Anyone have any ideas - is there a service in IIS6 that
>>I've missed, is there something other than FPserver
>>extensions and ASP that needs to be installed on the
>>server??
>>
>>In IIS6 on the Home Directory TAB, Script Source Access
>>is enabled as is read, and write...??
>
>Most likely your database is empty or your selection
>criteria are incorrect.
>
>To check for an empty database, open it in Access and
make
>sure the records you think should be there are, in fact,
>present.
>
>To check your selection criteria:
>
>1. Double-click the Database Results Region.
>2. Advance to page 3 of the wizard.
>3. Click More Options and then Criteria.
>4. Verify that the listed criteria are correct.
>
>If the problem persists:
>
>1. Restart the wizard and stop on page 2.
>2. Select Custom Query and then click Edit.
>3. Select the entire contents of the SQL Statement
> test box, and post them to this thread.
>
>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)
>|/---------------------------------------------------
>*----------------------------------------------------
>
>.
>

You need to publish via http to the web server.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

<(E-Mail Removed)> wrote in message
news:01b501c3d94c$51e96ce0$(E-Mail Removed)...
> Sorry I meant Published over the LAN
>
> Sim
> >-----Original Message-----
> >Not sure what you meant by "uploading via LAN" but you
> should PUBLISH the
> >site, to have everything working corectly.
> >
> >--
> >HTH,
> >Kevin Spencer
> >..Net Developer
> >Microsoft MVP
> >Big things are made up
> >of lots of little things.
> >
> >"Sim Marsh" <(E-Mail Removed)> wrote
> in message
> >news:010c01c3d948$e7291d90$(E-Mail Removed)...
> >> Hello All...
> >>
> >> Have a problem with an Access database which I've
> created
> >> and imported into my FP 2000 web before uploading via
> LAN
> >> to Windows Server 2003 running IIS6 with ASP & ASP.NET
> >> enabled.
> >>
> >> Problem was that form results weren't being
> >> displayed...Now I am getting a response of "No records
> >> returned"...
> >>
> >> Help..I've been through everything I can think of, such
> as
> >> importing the database, adding the connection as a File
> in
> >> Current Web, Choosing the right record source and the
> >> fields to display, but just no joy...
> >>
> >> Anyone have any ideas - is there a service in IIS6 that
> >> I've missed, is there something other than FPserver
> >> extensions and ASP that needs to be installed on the
> >> server??
> >>
> >> In IIS6 on the Home Directory TAB, Script Source Access
> is
> >> enabled as is read, and write...??
> >
> >
> >.
> >

Hi Thomas

Yes I have published via http to my server which sits at
the other side of my LAN running IIS6.

I have not enable OBDC sources, as the mdb file sits
within the current web...

Does IIS 'Home Directory tab', configuration, options,
DEFAULT ASP language make any difference??

Sim


>-----Original Message-----
>You need to publish via http to the web server.
>
>--
>
>==============================================
>Thomas A. Rowe (Microsoft MVP - FrontPage)
>WEBMASTER Resources(tm)
>http://www.ycoln-resources.com
>FrontPage Resources, Forums, WebCircle,
>MS KB Quick Links, etc.
>==============================================
>To assist you in getting the best answers for FrontPage
support see:
>http://www.net-sites.com/sitebuilder/newsgroups.asp
>
><(E-Mail Removed)> wrote in message
>news:01b501c3d94c$51e96ce0$(E-Mail Removed)...
>> Sorry I meant Published over the LAN
>>
>> Sim
>> >-----Original Message-----
>> >Not sure what you meant by "uploading via LAN" but you
>> should PUBLISH the
>> >site, to have everything working corectly.
>> >
>> >--
>> >HTH,
>> >Kevin Spencer
>> >..Net Developer
>> >Microsoft MVP
>> >Big things are made up
>> >of lots of little things.
>> >
>> >"Sim Marsh" <(E-Mail Removed)> wrote
>> in message
>> >news:010c01c3d948$e7291d90$(E-Mail Removed)...
>> >> Hello All...
>> >>
>> >> Have a problem with an Access database which I've
>> created
>> >> and imported into my FP 2000 web before uploading via
>> LAN
>> >> to Windows Server 2003 running IIS6 with ASP &
ASP.NET
>> >> enabled.
>> >>
>> >> Problem was that form results weren't being
>> >> displayed...Now I am getting a response of "No
records
>> >> returned"...
>> >>
>> >> Help..I've been through everything I can think of,
such
>> as
>> >> importing the database, adding the connection as a
File
>> in
>> >> Current Web, Choosing the right record source and the
>> >> fields to display, but just no joy...
>> >>
>> >> Anyone have any ideas - is there a service in IIS6
that
>> >> I've missed, is there something other than FPserver
>> >> extensions and ASP that needs to be installed on the
>> >> server??
>> >>
>> >> In IIS6 on the Home Directory TAB, Script Source
Access
>> is
>> >> enabled as is read, and write...??
>> >
>> >
>> >.
>> >
>
>
>.
>

Make sure that Home Directory that you have configured the Application Root,
you may need to delete it, then click configure to generate it. Then in FP
open the web, then Tools | Web Settings | Database and set up the connection
or verify the connection.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Sim Marsh" <(E-Mail Removed)> wrote in message
news:023901c3d953$9c32e540$(E-Mail Removed)...
> Hi Thomas
>
> Yes I have published via http to my server which sits at
> the other side of my LAN running IIS6.
>
> I have not enable OBDC sources, as the mdb file sits
> within the current web...
>
> Does IIS 'Home Directory tab', configuration, options,
> DEFAULT ASP language make any difference??
>
> Sim
>
>
> >-----Original Message-----
> >You need to publish via http to the web server.
> >
> >--
> >
> >==============================================
> >Thomas A. Rowe (Microsoft MVP - FrontPage)
> >WEBMASTER Resources(tm)
> >http://www.ycoln-resources.com
> >FrontPage Resources, Forums, WebCircle,
> >MS KB Quick Links, etc.
> >==============================================
> >To assist you in getting the best answers for FrontPage
> support see:
> >http://www.net-sites.com/sitebuilder/newsgroups.asp
> >
> ><(E-Mail Removed)> wrote in message
> >news:01b501c3d94c$51e96ce0$(E-Mail Removed)...
> >> Sorry I meant Published over the LAN
> >>
> >> Sim
> >> >-----Original Message-----
> >> >Not sure what you meant by "uploading via LAN" but you
> >> should PUBLISH the
> >> >site, to have everything working corectly.
> >> >
> >> >--
> >> >HTH,
> >> >Kevin Spencer
> >> >..Net Developer
> >> >Microsoft MVP
> >> >Big things are made up
> >> >of lots of little things.
> >> >
> >> >"Sim Marsh" <(E-Mail Removed)> wrote
> >> in message
> >> >news:010c01c3d948$e7291d90$(E-Mail Removed)...
> >> >> Hello All...
> >> >>
> >> >> Have a problem with an Access database which I've
> >> created
> >> >> and imported into my FP 2000 web before uploading via
> >> LAN
> >> >> to Windows Server 2003 running IIS6 with ASP &
> ASP.NET
> >> >> enabled.
> >> >>
> >> >> Problem was that form results weren't being
> >> >> displayed...Now I am getting a response of "No
> records
> >> >> returned"...
> >> >>
> >> >> Help..I've been through everything I can think of,
> such
> >> as
> >> >> importing the database, adding the connection as a
> File
> >> in
> >> >> Current Web, Choosing the right record source and the
> >> >> fields to display, but just no joy...
> >> >>
> >> >> Anyone have any ideas - is there a service in IIS6
> that
> >> >> I've missed, is there something other than FPserver
> >> >> extensions and ASP that needs to be installed on the
> >> >> server??
> >> >>
> >> >> In IIS6 on the Home Directory TAB, Script Source
> Access
> >> is
> >> >> enabled as is read, and write...??
> >> >
> >> >
> >> >.
> >> >
> >
> >
> >.
> >

Sim:
When you imported the database into your local web, it should have ended up
in a folder called fpdb, and the import should also have created a
global.asa in the root of your web:
http://www.spiderwebwoman.com/tutorials/create_dbc.htm Did this happen?

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/


(E-Mail Removed) wrote:
> Hi Jim thanks for your super speedy response...
>
> Erm the Access Db is a very quick 5 line table that I
> created as a test, so I take it that each numbered line in
> the table counts as a record.
>
> As far as Selection Criteria is concerned, I didn't
> specify any because I had so few records to output.
>
> Is this a vital part ??
>
> Sim
>
>> -----Original Message-----
>>> -----Original Message-----
>>> Hello All...
>>
>> Howdy.
>>
>>> Have a problem with an Access database which I've created
>>> and imported into my FP 2000 web before uploading via LAN
>>> to Windows Server 2003 running IIS6 with ASP & ASP.NET
>>> enabled.
>>>
>>> Problem was that form results weren't being
>>> displayed...Now I am getting a response of "No records
>>> returned"...
>>>
>>> Help..I've been through everything I can think of, such
>>> as importing the database, adding the connection as a
>>> File in Current Web, Choosing the right record source and
>>> the fields to display, but just no joy...
>>>
>>> Anyone have any ideas - is there a service in IIS6 that
>>> I've missed, is there something other than FPserver
>>> extensions and ASP that needs to be installed on the
>>> server??
>>>
>>> In IIS6 on the Home Directory TAB, Script Source Access
>>> is enabled as is read, and write...??
>>
>> Most likely your database is empty or your selection
>> criteria are incorrect.
>>
>> To check for an empty database, open it in Access and make
>> sure the records you think should be there are, in fact,
>> present.
>>
>> To check your selection criteria:
>>
>> 1. Double-click the Database Results Region.
>> 2. Advance to page 3 of the wizard.
>> 3. Click More Options and then Criteria.
>> 4. Verify that the listed criteria are correct.
>>
>> If the problem persists:
>>
>> 1. Restart the wizard and stop on page 2.
>> 2. Select Custom Query and then click Edit.
>> 3. Select the entire contents of the SQL Statement
>> test box, and post them to this thread.
>>
>> 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)
>>> /---------------------------------------------------
>> *----------------------------------------------------
>>
>> .

Hi Kathleen

Yes it did create fpdb as well as global.asa.

The web is saved onto the local machine b4 being published
via http to a nearby box over LAN running iis6.

I keep getting JScript compilation error '800a03f7'

Unterminated string constant

/first.asp, line 5

.....EVEN THOUGH FPAGE Created all of this code ??

Sim

>-----Original Message-----
>Sim:
>When you imported the database into your local web, it
should have ended up
>in a folder called fpdb, and the import should also have
created a
>global.asa in the root of your web:
>http://www.spiderwebwoman.com/tutorials/create_dbc.htm
Did this happen?
>
>--
>~ Kathleen Anderson
>Microsoft MVP - FrontPage
>Spider Web Woman Designs
>http://www.spiderwebwoman.com/resources/
>
>
>(E-Mail Removed) wrote:
>> Hi Jim thanks for your super speedy response...
>>
>> Erm the Access Db is a very quick 5 line table that I
>> created as a test, so I take it that each numbered line
in
>> the table counts as a record.
>>
>> As far as Selection Criteria is concerned, I didn't
>> specify any because I had so few records to output.
>>
>> Is this a vital part ??
>>
>> Sim
>>
>>> -----Original Message-----
>>>> -----Original Message-----
>>>> Hello All...
>>>
>>> Howdy.
>>>
>>>> Have a problem with an Access database which I've
created
>>>> and imported into my FP 2000 web before uploading via
LAN
>>>> to Windows Server 2003 running IIS6 with ASP & ASP.NET
>>>> enabled.
>>>>
>>>> Problem was that form results weren't being
>>>> displayed...Now I am getting a response of "No records
>>>> returned"...
>>>>
>>>> Help..I've been through everything I can think of,
such
>>>> as importing the database, adding the connection as a
>>>> File in Current Web, Choosing the right record source
and
>>>> the fields to display, but just no joy...
>>>>
>>>> Anyone have any ideas - is there a service in IIS6
that
>>>> I've missed, is there something other than FPserver
>>>> extensions and ASP that needs to be installed on the
>>>> server??
>>>>
>>>> In IIS6 on the Home Directory TAB, Script Source
Access
>>>> is enabled as is read, and write...??
>>>
>>> Most likely your database is empty or your selection
>>> criteria are incorrect.
>>>
>>> To check for an empty database, open it in Access and
make
>>> sure the records you think should be there are, in
fact,
>>> present.
>>>
>>> To check your selection criteria:
>>>
>>> 1. Double-click the Database Results Region.
>>> 2. Advance to page 3 of the wizard.
>>> 3. Click More Options and then Criteria.
>>> 4. Verify that the listed criteria are correct.
>>>
>>> If the problem persists:
>>>
>>> 1. Restart the wizard and stop on page 2.
>>> 2. Select Custom Query and then click Edit.
>>> 3. Select the entire contents of the SQL Statement
>>> test box, and post them to this thread.
>>>
>>> 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)
>>>> /---------------------------------------------------
>>> *----------------------------------------------------
>>>
>>> .
>
>
>.
>

What is on line 5?

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

"Sim" <(E-Mail Removed)> wrote in message
news:089301c3d97b$4789bdc0$(E-Mail Removed)...
> Hi Kathleen
>
> Yes it did create fpdb as well as global.asa.
>
> The web is saved onto the local machine b4 being published
> via http to a nearby box over LAN running iis6.
>
> I keep getting JScript compilation error '800a03f7'
>
> Unterminated string constant
>
> /first.asp, line 5
>
> ....EVEN THOUGH FPAGE Created all of this code ??
>
> Sim
>
> >-----Original Message-----
> >Sim:
> >When you imported the database into your local web, it
> should have ended up
> >in a folder called fpdb, and the import should also have
> created a
> >global.asa in the root of your web:
> >http://www.spiderwebwoman.com/tutorials/create_dbc.htm
> Did this happen?
> >
> >--
> >~ Kathleen Anderson
> >Microsoft MVP - FrontPage
> >Spider Web Woman Designs
> >http://www.spiderwebwoman.com/resources/
> >
> >
> >(E-Mail Removed) wrote:
> >> Hi Jim thanks for your super speedy response...
> >>
> >> Erm the Access Db is a very quick 5 line table that I
> >> created as a test, so I take it that each numbered line
> in
> >> the table counts as a record.
> >>
> >> As far as Selection Criteria is concerned, I didn't
> >> specify any because I had so few records to output.
> >>
> >> Is this a vital part ??
> >>
> >> Sim
> >>
> >>> -----Original Message-----
> >>>> -----Original Message-----
> >>>> Hello All...
> >>>
> >>> Howdy.
> >>>
> >>>> Have a problem with an Access database which I've
> created
> >>>> and imported into my FP 2000 web before uploading via
> LAN
> >>>> to Windows Server 2003 running IIS6 with ASP & ASP.NET
> >>>> enabled.
> >>>>
> >>>> Problem was that form results weren't being
> >>>> displayed...Now I am getting a response of "No records
> >>>> returned"...
> >>>>
> >>>> Help..I've been through everything I can think of,
> such
> >>>> as importing the database, adding the connection as a
> >>>> File in Current Web, Choosing the right record source
> and
> >>>> the fields to display, but just no joy...
> >>>>
> >>>> Anyone have any ideas - is there a service in IIS6
> that
> >>>> I've missed, is there something other than FPserver
> >>>> extensions and ASP that needs to be installed on the
> >>>> server??
> >>>>
> >>>> In IIS6 on the Home Directory TAB, Script Source
> Access
> >>>> is enabled as is read, and write...??
> >>>
> >>> Most likely your database is empty or your selection
> >>> criteria are incorrect.
> >>>
> >>> To check for an empty database, open it in Access and
> make
> >>> sure the records you think should be there are, in
> fact,
> >>> present.
> >>>
> >>> To check your selection criteria:
> >>>
> >>> 1. Double-click the Database Results Region.
> >>> 2. Advance to page 3 of the wizard.
> >>> 3. Click More Options and then Criteria.
> >>> 4. Verify that the listed criteria are correct.
> >>>
> >>> If the problem persists:
> >>>
> >>> 1. Restart the wizard and stop on page 2.
> >>> 2. Select Custom Query and then click Edit.
> >>> 3. Select the entire contents of the SQL Statement
> >>> test box, and post them to this thread.
> >>>
> >>> 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)
> >>>> /---------------------------------------------------
> >>> *----------------------------------------------------
> >>>
> >>> .
> >
> >
> >.
> >