database

[Guest]

I keep trying to connect a Frontpage web page to a table on SQL server and
keep getting this error message:

Server error: Unable to retrieve schema information from the record source
'tblHSITESstaff' in a database using the connection string:

'DRIVER={SQL Server};SERVER=vhaiswsqdt1\nodtsql1;DATABASE=HSITESadminDB'.

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 SQL Server Driver][SQL Server]Invalid object name
'tblHSITESstaff'.

Source: Microsoft OLE DB Provider for ODBC Drivers

Number: -2147467259 (0x80004005)


Any thoughts as to what this means? I need the "For Dummies" translation.

thank you

 

[Kevin Spencer]

How did you create the connection? Is the SQL Server using Windows
Authentication or mixed? Where is the SQL Server located?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

 

[Guest]

I've tried creating it through Insert Database - data viewer. I've also
tried to create a form and then work through properties and I've tried to use
the Database Interface Wizard.

The SQL server is using Windows Authentication.

I believe it is on a web server (??).

thank you.

How did you create the connection? Is the SQL Server using Windows
Authentication or mixed? Where is the SQL Server located?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I keep trying to connect a Frontpage web page to a table on SQL server and
keep getting this error message:

Server error: Unable to retrieve schema information from the record source
'tblHSITESstaff' in a database using the connection string:

'DRIVER={SQL Server};SERVER=vhaiswsqdt1\nodtsql1;DATABASE=HSITESadminDB'.

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 SQL Server Driver][SQL Server]Invalid object name
'tblHSITESstaff'.

Source: Microsoft OLE DB Provider for ODBC Drivers

Number: -2147467259 (0x80004005)


Any thoughts as to what this means? I need the "For Dummies" translation.

thank you

 

[Kevin Spencer]

You can't insert a DataView into a regular web. You have to have SharePoint
installed, and use it with a SharePoint web site.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I've tried creating it through Insert Database - data viewer. I've also
tried to create a form and then work through properties and I've tried to
use
the Database Interface Wizard.

The SQL server is using Windows Authentication.

I believe it is on a web server (??).

thank you.

How did you create the connection? Is the SQL Server using Windows
Authentication or mixed? Where is the SQL Server located?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I keep trying to connect a Frontpage web page to a table on SQL server
and
keep getting this error message:

Server error: Unable to retrieve schema information from the record
source
'tblHSITESstaff' in a database using the connection string:

'DRIVER={SQL
Server};SERVER=vhaiswsqdt1\nodtsql1;DATABASE=HSITESadminDB'.

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 SQL Server Driver][SQL Server]Invalid object name
'tblHSITESstaff'.

Source: Microsoft OLE DB Provider for ODBC Drivers

Number: -2147467259 (0x80004005)


Any thoughts as to what this means? I need the "For Dummies"
translation.

thank you

 

[Guest]

I'm sorry, I erroneously typed DataView, but it was really Results.
Moreover, this same error appears when I try to establish the connection 2
other ways.

You can't insert a DataView into a regular web. You have to have SharePoint
installed, and use it with a SharePoint web site.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I've tried creating it through Insert Database - data viewer. I've also
tried to create a form and then work through properties and I've tried to
use
the Database Interface Wizard.

The SQL server is using Windows Authentication.

I believe it is on a web server (??).

thank you.

How did you create the connection? Is the SQL Server using Windows
Authentication or mixed? Where is the SQL Server located?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I keep trying to connect a Frontpage web page to a table on SQL server
and
keep getting this error message:

Server error: Unable to retrieve schema information from the record
source
'tblHSITESstaff' in a database using the connection string:

'DRIVER={SQL
Server};SERVER=vhaiswsqdt1\nodtsql1;DATABASE=HSITESadminDB'.

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 SQL Server Driver][SQL Server]Invalid object name
'tblHSITESstaff'.

Source: Microsoft OLE DB Provider for ODBC Drivers

Number: -2147467259 (0x80004005)


Any thoughts as to what this means? I need the "For Dummies"
translation.

thank you

 

[Kevin Spencer]

Okay, so where is the SQL Server located, with respect to the web site?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I'm sorry, I erroneously typed DataView, but it was really Results.
Moreover, this same error appears when I try to establish the connection 2
other ways.

You can't insert a DataView into a regular web. You have to have
SharePoint
installed, and use it with a SharePoint web site.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I've tried creating it through Insert Database - data viewer. I've
also
tried to create a form and then work through properties and I've tried
to
use
the Database Interface Wizard.

The SQL server is using Windows Authentication.

I believe it is on a web server (??).

thank you.

:

How did you create the connection? Is the SQL Server using Windows
Authentication or mixed? Where is the SQL Server located?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I keep trying to connect a Frontpage web page to a table on SQL
server
and
keep getting this error message:

Server error: Unable to retrieve schema information from the record
source
'tblHSITESstaff' in a database using the connection string:

'DRIVER={SQL
Server};SERVER=vhaiswsqdt1\nodtsql1;DATABASE=HSITESadminDB'.

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 SQL Server Driver][SQL Server]Invalid object name
'tblHSITESstaff'.

Source: Microsoft OLE DB Provider for ODBC Drivers

Number: -2147467259 (0x80004005)


Any thoughts as to what this means? I need the "For Dummies"
translation.

thank you

 

[Guest]

.... I warned you... I need the "For Dummies" version... I'm not certain what
this means. I'm building the "web site" locally on my c: drive for now and
the database is on a MS Sequel Server web server.

Okay, so where is the SQL Server located, with respect to the web site?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I'm sorry, I erroneously typed DataView, but it was really Results.
Moreover, this same error appears when I try to establish the connection 2
other ways.

You can't insert a DataView into a regular web. You have to have
SharePoint
installed, and use it with a SharePoint web site.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I've tried creating it through Insert Database - data viewer. I've
also
tried to create a form and then work through properties and I've tried
to
use
the Database Interface Wizard.

The SQL server is using Windows Authentication.

I believe it is on a web server (??).

thank you.

:

How did you create the connection? Is the SQL Server using Windows
Authentication or mixed? Where is the SQL Server located?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I keep trying to connect a Frontpage web page to a table on SQL
server
and
keep getting this error message:

Server error: Unable to retrieve schema information from the record
source
'tblHSITESstaff' in a database using the connection string:

'DRIVER={SQL
Server};SERVER=vhaiswsqdt1\nodtsql1;DATABASE=HSITESadminDB'.

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 SQL Server Driver][SQL Server]Invalid object name
'tblHSITESstaff'.

Source: Microsoft OLE DB Provider for ODBC Drivers

Number: -2147467259 (0x80004005)


Any thoughts as to what this means? I need the "For Dummies"
translation.

thank you

 

[Kevin Spencer]

Maybe you should use a "for dummies" database: Access. It is much simpler to
work with. And database operations are not simple by nature.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

... I warned you... I need the "For Dummies" version... I'm not certain
what
this means. I'm building the "web site" locally on my c: drive for now
and
the database is on a MS Sequel Server web server.

Okay, so where is the SQL Server located, with respect to the web site?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I'm sorry, I erroneously typed DataView, but it was really Results.
Moreover, this same error appears when I try to establish the
connection 2
other ways.

:

You can't insert a DataView into a regular web. You have to have
SharePoint
installed, and use it with a SharePoint web site.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I've tried creating it through Insert Database - data viewer. I've
also
tried to create a form and then work through properties and I've
tried
to
use
the Database Interface Wizard.

The SQL server is using Windows Authentication.

I believe it is on a web server (??).

thank you.

:

How did you create the connection? Is the SQL Server using Windows
Authentication or mixed? Where is the SQL Server located?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I keep trying to connect a Frontpage web page to a table on SQL
server
and
keep getting this error message:

Server error: Unable to retrieve schema information from the
record
source
'tblHSITESstaff' in a database using the connection string:

'DRIVER={SQL
Server};SERVER=vhaiswsqdt1\nodtsql1;DATABASE=HSITESadminDB'.

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 SQL Server Driver][SQL Server]Invalid object
name
'tblHSITESstaff'.

Source: Microsoft OLE DB Provider for ODBC Drivers

Number: -2147467259 (0x80004005)


Any thoughts as to what this means? I need the "For Dummies"
translation.

thank you

 

[Guest]

As a matter of fact Access is what I started with. I'm now exploring a move
to SQL Server for a variety of reasons...

so any thoughts on the original question?

Frontpage advertises connectivity to SQL Server so what's the problem? I'm
able to identify the database in front page connectivity (Frontpage finds my
database, because it gives me a list of tables to choose from from the
identified database... it poops out though when trying to identify the
columns.

Maybe you should use a "for dummies" database: Access. It is much simpler to
work with. And database operations are not simple by nature.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

... I warned you... I need the "For Dummies" version... I'm not certain
what
this means. I'm building the "web site" locally on my c: drive for now
and
the database is on a MS Sequel Server web server.

Okay, so where is the SQL Server located, with respect to the web site?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I'm sorry, I erroneously typed DataView, but it was really Results.
Moreover, this same error appears when I try to establish the
connection 2
other ways.

:

You can't insert a DataView into a regular web. You have to have
SharePoint
installed, and use it with a SharePoint web site.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I've tried creating it through Insert Database - data viewer. I've
also
tried to create a form and then work through properties and I've
tried
to
use
the Database Interface Wizard.

The SQL server is using Windows Authentication.

I believe it is on a web server (??).

thank you.

:

How did you create the connection? Is the SQL Server using Windows
Authentication or mixed? Where is the SQL Server located?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I keep trying to connect a Frontpage web page to a table on SQL
server
and
keep getting this error message:

Server error: Unable to retrieve schema information from the
record
source
'tblHSITESstaff' in a database using the connection string:

'DRIVER={SQL
Server};SERVER=vhaiswsqdt1\nodtsql1;DATABASE=HSITESadminDB'.

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 SQL Server Driver][SQL Server]Invalid object
name
'tblHSITESstaff'.

Source: Microsoft OLE DB Provider for ODBC Drivers

Number: -2147467259 (0x80004005)


Any thoughts as to what this means? I need the "For Dummies"
translation.

thank you

 

[Kevin Spencer]

SQL Server is a full-blown database server. As such, it has tricky
permissions issues associated with it. I don't think I can give you a "for
dummies" version of what is needed:

At this point, I can guess that you're experiencing a security/permissions
issue with your SQL Server, and that's about it.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

As a matter of fact Access is what I started with. I'm now exploring a
move
to SQL Server for a variety of reasons...

so any thoughts on the original question?

Frontpage advertises connectivity to SQL Server so what's the problem?
I'm
able to identify the database in front page connectivity (Frontpage finds
my
database, because it gives me a list of tables to choose from from the
identified database... it poops out though when trying to identify the
columns.

Maybe you should use a "for dummies" database: Access. It is much simpler
to
work with. And database operations are not simple by nature.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

... I warned you... I need the "For Dummies" version... I'm not certain
what
this means. I'm building the "web site" locally on my c: drive for now
and
the database is on a MS Sequel Server web server.

:

Okay, so where is the SQL Server located, with respect to the web
site?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I'm sorry, I erroneously typed DataView, but it was really Results.
Moreover, this same error appears when I try to establish the
connection 2
other ways.

:

You can't insert a DataView into a regular web. You have to have
SharePoint
installed, and use it with a SharePoint web site.

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I've tried creating it through Insert Database - data viewer.
I've
also
tried to create a form and then work through properties and I've
tried
to
use
the Database Interface Wizard.

The SQL server is using Windows Authentication.

I believe it is on a web server (??).

thank you.

:

How did you create the connection? Is the SQL Server using
Windows
Authentication or mixed? Where is the SQL Server located?

--
HTH,

Kevin Spencer
Microsoft MVP
..Net Developer
Neither a follower nor a lender be.

I keep trying to connect a Frontpage web page to a table on SQL
server
and
keep getting this error message:

Server error: Unable to retrieve schema information from the
record
source
'tblHSITESstaff' in a database using the connection string:

'DRIVER={SQL
Server};SERVER=vhaiswsqdt1\nodtsql1;DATABASE=HSITESadminDB'.

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 SQL Server Driver][SQL Server]Invalid object
name
'tblHSITESstaff'.

Source: Microsoft OLE DB Provider for ODBC Drivers

Number: -2147467259 (0x80004005)


Any thoughts as to what this means? I need the "For Dummies"
translation.

thank you