Database Results Problem

S

Sim Marsh

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...??
 
K

Kevin Spencer

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.
 
J

Jim Buyens

-----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...??
Click to expand...

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

Guest

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
 
T

Thomas A. Rowe

You need to publish via http to the web server.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
S

Sim Marsh

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
 
T

Thomas A. Rowe

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)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
S

Sim

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
 
T

Thomas A. Rowe

What is on line 5?

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
S

Sim

Hi Thomas

Here's the first part of the HTML text:
+++++++++++++++++++++++
<head>
<% ' FP_ASP -- ASP Automatically generated by a Frontpage
Component. Do not Edit.
FP_CharSet = "windows-1252"
FP_CodePage = 1252 %>
<meta http-equiv="Content-Type" content="text/html;
charset=windows-1252">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>CustomerID</title>
</head>

<body>

<table width="100%" border="1">
<thead>
<tr>
<td><b>CustomerID</b></td>
<td><b>CompanyName</b></td>
<td><b>ContactName</b></td>
<td><b>ContactTitle</b></td>
<td><b>Address</b></td>
<td><b>City</b></td>
</tr>
+++++++++++++++++++++++++++++++++++
IT seems to be objecting to the first bit of the code -->
I'm not a programmer but I wonder if it's missing an
enclosure mark " ' " ??

Thanks

Sim
 
T

Thomas A. Rowe

Is it possible for you to publish the site the internet, so that we can see
the error?

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
S

Sim

Hi Thomas

Actually this is the whole point of my project --> I'm
setting up a FPage focussed IIS6 web hosting server, and
as such I'm not needing to use the database functionality
myself --> but I appreciate that any clients likely will
want to use it...so I'm really testing things such as FTP
access, SSL and Dbases...It's just really sending me round
the bend that something that should work just won't...and
unlike most people I've had relatively few problems with
FPSE in the past !

Erm well I've up till now only ever published to free
sites and won't actually have the capability to use FPSE
and databases until the server that's sitting next to me
is transplanted into the hosting site.

Sim
 
T

Thomas A. Rowe

You might want to try posting to the IIS or Windows Server newsgroup.
Windows 2003 Server had many functions that were normally on by default in
Windows 2000 Server, disabled.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
S

Sim

Yes I've now posted to the server newsgroup, thx Tom.

One last thing though - I've not installed any office
applications on the server except for the Server
Extensions. I take it that these are sufficient along
with the FPage bots to understand commands in the mdb
access database that I uploaded to the server...?

Cheers for all your suggestions,

Sim
 
T

Thomas A. Rowe

Sim,

There is no need to install any Office application directly on the server.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
Top