Frontpage Extensions

[Slim]

I am trying to develop a corporate intranet but my
Frontpage Components on the site aren't working.
According to the Add/Remove Windows Components, I have
the Frontpage 2000 extensions installed on the server but
I get the following error when viewing the site.

Database Results Error
[Microsoft][ODBC Excel Driver] '(unknown)' is not a valid
path. Make sure that the path name is spelled correctly
and that you are connected to the server on which the
file resides.

The rest of the site works fine except my database
results and forms.

What am I missing?

[Ray Costanzo [MVP]]

Is there any particular reason you're using Excel as a "database?"

Can you post the relevant code that is trying to connect to this data
source?

Ray at work

"Slim" <an*******@discussions.microsoft.com> wrote in message
news:52****************************@phx.gbl...

I am trying to develop a corporate intranet but my
Frontpage Components on the site aren't working.
According to the Add/Remove Windows Components, I have
the Frontpage 2000 extensions installed on the server but
I get the following error when viewing the site.

Database Results Error
[Microsoft][ODBC Excel Driver] '(unknown)' is not a valid
path. Make sure that the path name is spelled correctly
and that you are connected to the server on which the
file resides.

The rest of the site works fine except my database
results and forms.

What am I missing?

[joker]

First off stop using ODBC. Second get a real database like access,
mySql, SQL server or something like that to use instead.

Second read the following pages. The first one give you some idea of
what you should be doing with a real database. The second one mentions
that ODBC is being Deprecated from the MDAC starting with ADO version 2.8.

http://www.aspfaq.com/show.asp?id=2126

http://msdn.microsoft.com/library/de...components.asp

Slim wrote:

I am trying to develop a corporate intranet but my
Frontpage Components on the site aren't working.
According to the Add/Remove Windows Components, I have
the Frontpage 2000 extensions installed on the server but
I get the following error when viewing the site.

Database Results Error
[Microsoft][ODBC Excel Driver] '(unknown)' is not a valid
path. Make sure that the path name is spelled correctly
and that you are connected to the server on which the
file resides.

The rest of the site works fine except my database
results and forms.

What am I missing?

[joker]

I just realized it should be first second & then third. My bad.

joker wrote:

First off stop using ODBC. Second get a real database like access,
mySql, SQL server or something like that to use instead.

Second read the following pages. The first one give you some idea of
what you should be doing with a real database. The second one mentions
that ODBC is being Deprecated from the MDAC starting with ADO version 2.8.

http://www.aspfaq.com/show.asp?id=2126

http://msdn.microsoft.com/library/de...components.asp
Slim wrote:

I am trying to develop a corporate intranet but my Frontpage
Components on the site aren't working. According to the Add/Remove
Windows Components, I have
the Frontpage 2000 extensions installed on the server but I get the
following error when viewing the site.

Database Results Error
[Microsoft][ODBC Excel Driver] '(unknown)' is not a valid path. Make
sure that the path name is spelled correctly and that you are
connected to the server on which the file resides.

The rest of the site works fine except my database results and forms.

What am I missing?