0x80004005 error

T

Tigerxxx

I am designing my web site usin front page using excel db...When i run
databbse result wizard ...i am getting this error...plz tell me how to solve
this error??


Server error: Unable to connect to a database from the Web server using the
connection string 'DSN=bbbb;DRIVER={Microsoft Excel Driver (*.xls)}'.

The following error message comes from the database driver software; it may
appear in a different language depending on how the driver is configured.
-------------------------------------------------------
[Microsoft][ODBC Excel Driver] External table is not in the expected format.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147467259 (0x80004005)


thanks in advance
 
S

Stefan B Rusynko

Is your Excel worksheet set up correctly as a data table with acceptable data column headings without any spaces

FYI
- use of Excel as a DB is not recommended
- convert your Excel worksheet to an Access database




|I am designing my web site usin front page using excel db...When i run
| databbse result wizard ...i am getting this error...plz tell me how to solve
| this error??
|
|
| Server error: Unable to connect to a database from the Web server using the
| connection string 'DSN=bbbb;DRIVER={Microsoft Excel Driver (*.xls)}'.
|
| The following error message comes from the database driver software; it may
| appear in a different language depending on how the driver is configured.
| -------------------------------------------------------
| [Microsoft][ODBC Excel Driver] External table is not in the expected format.
|
| Source: Microsoft OLE DB Provider for ODBC Drivers
| Number: -2147467259 (0x80004005)
|
|
| thanks in advance
 
T

Tigerxxx

Thanks stefan..
I will convert my excel to access. If i want to display my records should i
run it on webb server? or should i preview it on web broswer to see my
records?
 
K

Kathleen Anderson

You need to run this on a Windows server that supports ASP and Access.

--

~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
Expression Web Resources: http://www.spiderwebwoman.com/xweb/
FrontPage Resources: http://www.spiderwebwoman.com/resources/
Please reply to the newsgroup for the benefit of others



Tigerxxx said:
Thanks stefan..
I will convert my excel to access. If i want to display my records should
i
run it on webb server? or should i preview it on web broswer to see my
records?

Stefan B Rusynko said:
Is your Excel worksheet set up correctly as a data table with acceptable
data column headings without any spaces

FYI
- use of Excel as a DB is not recommended
- convert your Excel worksheet to an Access database




|I am designing my web site usin front page using excel db...When i run
| databbse result wizard ...i am getting this error...plz tell me how to
solve
| this error??
|
|
| Server error: Unable to connect to a database from the Web server using
the
| connection string 'DSN=bbbb;DRIVER={Microsoft Excel Driver (*.xls)}'.
|
| The following error message comes from the database driver software; it
may
| appear in a different language depending on how the driver is
configured.
| -------------------------------------------------------
| [Microsoft][ODBC Excel Driver] External table is not in the expected
format.
|
| Source: Microsoft OLE DB Provider for ODBC Drivers
| Number: -2147467259 (0x80004005)
|
|
| thanks in advance
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top