Data Lost?

I have an ASP form created in FrontPage on an XP client
that connects to a "remote" SQL database hosted on a
Win2003 server. Connection tests, field mapping etc. all
indicate OK. When I fill out the form and submit, I get
confirmation and no indication of problems, however data
does not appear in the database. Some insight in to what
may be going on would be appreciated, TKS
BB3
Hi,
Please open the SQL profiler and check the statements fired. You can use the
profilers default template.
Thanks
Hari
MCDBA
"BB3" <anonymous@.discussions.microsoft.com> wrote in message
news:2f9a001c46d00$b4b588c0$a301280a@.phx.gbl...
> I have an ASP form created in FrontPage on an XP client
> that connects to a "remote" SQL database hosted on a
> Win2003 server. Connection tests, field mapping etc. all
> indicate OK. When I fill out the form and submit, I get
> confirmation and no indication of problems, however data
> does not appear in the database. Some insight in to what
> may be going on would be appreciated, TKS
> BB3

Data Lost?

I have an ASP form created in FrontPage on an XP client
that connects to a "remote" SQL database hosted on a
Win2003 server. Connection tests, field mapping etc. all
indicate OK. When I fill out the form and submit, I get
confirmation and no indication of problems, however data
does not appear in the database. Some insight in to what
may be going on would be appreciated, TKS
BB3Hi,
Please open the SQL profiler and check the statements fired. You can use the
profilers default template.
Thanks
Hari
MCDBA
"BB3" <anonymous@.discussions.microsoft.com> wrote in message
news:2f9a001c46d00$b4b588c0$a301280a@.phx
.gbl...
> I have an ASP form created in FrontPage on an XP client
> that connects to a "remote" SQL database hosted on a
> Win2003 server. Connection tests, field mapping etc. all
> indicate OK. When I fill out the form and submit, I get
> confirmation and no indication of problems, however data
> does not appear in the database. Some insight in to what
> may be going on would be appreciated, TKS
> BB3

Data Lost

I have an ASP form created in FrontPage on an XP client
that connects to a "remote" SQL database hosted on a
Win2003 server. Connection tests, field mapping etc. all
indicate OK. When I fill out the form and submit, I get
confirmation and no indication of problems, however data
does not appear in the database. Some insight in to what
may be going on would be appreciated? TKS
BB3
You'l have to use Profiler to see what exact procedures are called, and what
queries are executed inside SQL Server.
It could be that you are suppressing errors in your ASP code. Check that as
well.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"BB3" <anonymous@.discussions.microsoft.com> wrote in message
news:3bab01c47285$3d18d170$a301280a@.phx.gbl...
I have an ASP form created in FrontPage on an XP client
that connects to a "remote" SQL database hosted on a
Win2003 server. Connection tests, field mapping etc. all
indicate OK. When I fill out the form and submit, I get
confirmation and no indication of problems, however data
does not appear in the database. Some insight in to what
may be going on would be appreciated? TKS
BB3

Data Lost

I have an ASP form created in FrontPage on an XP client
that connects to a "remote" SQL database hosted on a
Win2003 server. Connection tests, field mapping etc. all
indicate OK. When I fill out the form and submit, I get
confirmation and no indication of problems, however data
does not appear in the database. Some insight in to what
may be going on would be appreciated? TKS
BB3You'l have to use Profiler to see what exact procedures are called, and what
queries are executed inside SQL Server.
It could be that you are suppressing errors in your ASP code. Check that as
well.
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
Is .NET important for a database professional?
http://vyaskn.tripod.com/poll.htm
"BB3" <anonymous@.discussions.microsoft.com> wrote in message
news:3bab01c47285$3d18d170$a301280a@.phx.gbl...
I have an ASP form created in FrontPage on an XP client
that connects to a "remote" SQL database hosted on a
Win2003 server. Connection tests, field mapping etc. all
indicate OK. When I fill out the form and submit, I get
confirmation and no indication of problems, however data
does not appear in the database. Some insight in to what
may be going on would be appreciated? TKS
BB3