Re: database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Kevin Spencer (kevin_at_DIESPAMMERSDIEtakempis.com)
Date: 02/15/05 

Date: Tue, 15 Feb 2005 10:48:31 -0500

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.
"gmead7" <gmead7@discussions.microsoft.com> wrote in message 
news:33D4B79B-C5D0-4402-BD70-5215CF0D0007@microsoft.com...
> 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.
>
> "Kevin Spencer" wrote:
>
>> 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.
>>
>> "gmead7" <gmead7@discussions.microsoft.com> wrote in message
>> news:DE4951CC-09D6-4B98-AAB2-7C30933661D8@microsoft.com...
>> >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
>> >
>>
>>
>>

Relevant Pages

  • Re: database
    ... Maybe you should use a "for dummies" database: ... Kevin Spencer ... >> Okay, so where is the SQL Server located, with respect to the web site? ...
    (microsoft.public.frontpage.client)
  • Re: Upload image into SQL Server database
    ... How do I build the form so that includes both an insert into an SQL Server ... "Kevin Spencer" wrote in message ... > path to the image in the database. ... >> I need them to be able to upload an image as well and to have it saved ...
    (microsoft.public.frontpage.programming)
  • Re: database
    ... SQL Server is a full-blown database server. ... Kevin Spencer ... >> Maybe you should use a "for dummies" database: ...
    (microsoft.public.frontpage.client)
  • Re: database
    ... I've tried creating it through Insert Database - data viewer. ... The SQL server is using Windows Authentication. ... I believe it is on a web server. ... "Kevin Spencer" wrote: ...
    (microsoft.public.frontpage.client)
  • Re: Does VS download database?
    ... A SQL Server database has a master database that has quite a ... > "Kevin Spencer" wrote in message ... It was downloading the schema. ... >> .Net Developer ...
    (microsoft.public.vstudio.general)