Re: database
From: Kevin Spencer (kevin_at_DIESPAMMERSDIEtakempis.com)
Date: 02/15/05
- Next message: 2mac: "Re: Website background picture not showing in FrontPage Preview?"
- Previous message: Ktahy: "Re: Eliminate form fields that are not used in completeing a form"
- In reply to: gmead7: "Re: database"
- Next in thread: gmead7: "Re: database"
- Reply: gmead7: "Re: database"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 15 Feb 2005 12:03:25 -0500
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.
"gmead7" <gmead7@discussions.microsoft.com> wrote in message
news:87F24D0F-B28E-4DBB-8E07-328CFCA636BE@microsoft.com...
> ... 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.
>
> "Kevin Spencer" wrote:
>
>> 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.
>>
>> "gmead7" <gmead7@discussions.microsoft.com> wrote in message
>> news:645292B7-2EBB-4C37-9D24-F47D17EF09A5@microsoft.com...
>> > 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.
>> >
>> > "Kevin Spencer" wrote:
>> >
>> >> 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
>> >> >> >
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>
- Next message: 2mac: "Re: Website background picture not showing in FrontPage Preview?"
- Previous message: Ktahy: "Re: Eliminate form fields that are not used in completeing a form"
- In reply to: gmead7: "Re: database"
- Next in thread: gmead7: "Re: database"
- Reply: gmead7: "Re: database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
