Help!

Connecting to my sql server from frontpage 2003

 
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Client RSS
Next:  Form results to Access 2003 database  
Author Message
Shyam
External


Since: May 09, 2005
Posts: 3



PostPosted: Mon May 09, 2005 11:57 am    Post subject: Connecting to my sql server from frontpage 2003
Archived from groups: microsoft>public>frontpage>client (more info?)

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
Back to top
Harikumar H [MSFT]
External


Since: Mar 04, 2004
Posts: 39



PostPosted: Mon May 09, 2005 7:30 pm    Post subject: RE: Connecting to my sql server from frontpage 2003 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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
|
Back to top
Shyam
External


Since: May 09, 2005
Posts: 3



PostPosted: Mon May 09, 2005 7:30 pm    Post subject: RE: Connecting to my sql server from frontpage 2003 [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)

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.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
> |
>
>
>
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Client All times are: Eastern Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum