I am using sbs2003. I have installed both frontpage 2003 and sql server that
came with the software. Now I am developing a website using frontpage 2003
and want to link pages to data in my database. In addition to the two
standard database servers sbsmonitoring and sharepoint, I have created a new
database server called testserver. How do I access the data in testserver
from within frontpage 2003? I want to both populate the database from forms
created by fp2003 and display content in the database through the web pages.
I have already created the forms and tables for this purpose.

I tried to create database connections using the insert>database>results
command, selecting "asp.net" and "connect to an external database", then
"next", "Sql server" for database driver, "servername\testserver" for Server,
and a database I created in Testserver called "Customer" for database name. I
provided the correct username and password (administrator) below and clicked
next. I got a "Database Connection Error" pop up box, saying "the server
encountered an error when processing a database request".

In the details the following was there: Server error: Unable to connect to a
database from the web server using the connection string 'DRIVER={SQL
Server};SERVER=SERVERNAME\TESTSERVER;DATABASE=Customer;UID=********;PWD=********'.

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]Login failed for user
'administrator'. Reason: Not associated with a trusted SQL Server connection.

Source: Microsoft OLE DB Provider for ODBC Drivers
Number: -2147217843 (0x80040e4d)

Please help
--
Thanks very much

Shyam

Hi Shyam,

Check the following KB article


You receive a "Database Results Wizard Error" error message when you open
or browse Database Results Wizard ASP pages or ASP.NET pages in FrontPage
2003
http://support.microsoft.com/default...b;en-us;898721

Hope this helps


regards

Hari
MSFT

This posting is provided "as is" with no warranties and confers no rights
--------------------

| I am using sbs2003. I have installed both frontpage 2003 and sql server
that
| came with the software. Now I am developing a website using frontpage
2003
| and want to link pages to data in my database. In addition to the two
| standard database servers sbsmonitoring and sharepoint, I have created a
new
| database server called testserver. How do I access the data in testserver
| from within frontpage 2003? I want to both populate the database from
forms
| created by fp2003 and display content in the database through the web
pages.
| I have already created the forms and tables for this purpose.
|
| I tried to create database connections using the insert>database>results
| command, selecting "asp.net" and "connect to an external database", then
| "next", "Sql server" for database driver, "servername\testserver" for
Server,
| and a database I created in Testserver called "Customer" for database
name. I
| provided the correct username and password (administrator) below and
clicked
| next. I got a "Database Connection Error" pop up box, saying "the server
| encountered an error when processing a database request".
|
| In the details the following was there: Server error: Unable to connect
to a
| database from the web server using the connection string 'DRIVER={SQL
|
Server};SERVER=SERVERNAME\TESTSERVER;DATABASE=Customer;UID=********;PWD=****
****'.
|
| 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]Login failed for user
| 'administrator'. Reason: Not associated with a trusted SQL Server
connection.
|
| Source: Microsoft OLE DB Provider for ODBC Drivers
| Number: -2147217843 (0x80040e4d)
|
| Please help
| --
| Thanks very much
|
| Shyam
|

Dear Harikumar:

Thanks for your prompt response. I tried to follow your instructions. But
when I went to Tools>Site Settings, in the database tab, there are no
connections at all for me to modify. I guess this is the problem. Can you
help me set up a connection? When I click on Add, I get the following
choices, 1. file or folder in current web site, 2. System data source on web
server, 3. Network connection to database server, and 4. Custom definition. I
think choice 3. is the appropriate one, but when I select it, the "OK" button
is greyed out. How do I proceed from here?
--
Thanks very much

Shyam


"Harikumar H [MSFT]" wrote:

> Hi Shyam,
>
> Check the following KB article
>
>
> You receive a "Database Results Wizard Error" error message when you open
> or browse Database Results Wizard ASP pages or ASP.NET pages in FrontPage
> 2003
> http://support.microsoft.com/default...b;en-us;898721
>
> Hope this helps
>
>
> regards
>
> Hari
> MSFT
>
> This posting is provided "as is" with no warranties and confers no rights
> --------------------
>
> | I am using sbs2003. I have installed both frontpage 2003 and sql server
> that
> | came with the software. Now I am developing a website using frontpage
> 2003
> | and want to link pages to data in my database. In addition to the two
> | standard database servers sbsmonitoring and sharepoint, I have created a
> new
> | database server called testserver. How do I access the data in testserver
> | from within frontpage 2003? I want to both populate the database from
> forms
> | created by fp2003 and display content in the database through the web
> pages.
> | I have already created the forms and tables for this purpose.
> |
> | I tried to create database connections using the insert>database>results
> | command, selecting "asp.net" and "connect to an external database", then
> | "next", "Sql server" for database driver, "servername\testserver" for
> Server,
> | and a database I created in Testserver called "Customer" for database
> name. I
> | provided the correct username and password (administrator) below and
> clicked
> | next. I got a "Database Connection Error" pop up box, saying "the server
> | encountered an error when processing a database request".
> |
> | In the details the following was there: Server error: Unable to connect
> to a
> | database from the web server using the connection string 'DRIVER={SQL
> |
> Server};SERVER=SERVERNAME\TESTSERVER;DATABASE=Customer;UID=********;PWD=****
> ****'.
> |
> | 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]Login failed for user
> | 'administrator'. Reason: Not associated with a trusted SQL Server
> connection.
> |
> | Source: Microsoft OLE DB Provider for ODBC Drivers
> | Number: -2147217843 (0x80040e4d)
> |
> | Please help
> | --
> | Thanks very much
> |
> | Shyam
> |
>
>
>