Connecting to my sql server from frontpage 2003

[Shyam]

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

 

[Harikumar H [MSFT]]

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.aspx?scid=kb;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
|

 

[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

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.aspx?scid=kb;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
|