Frontpage 2003, asp.net, Database Interface Wizard

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I nedd to be able to enter data into a SQL database table from a website.

I ran through the database interface wizard selecting asp.net and connecting
to a sql database. I have an established connection under Site Settings. I am
able to log-in and view my submission_form.aspx. However when I hit the
submit button I get this error:

Invalid Authorization Specification
----------------
....And a reference to line 33 in the submission_form.aspx
------------
Source error:

DataTable curDataTable = Connection.GetDataSet(true).Tables[0];
--------------
I have not made any modifications of any kind. this is the result from the
files created by the wizard. I have looked into this error without success.
Please Help!

I am now wondering if I can enter data into a SQL database using asp.net and
the Wizard? Or, do I need to switch to asp and the wizard instead.

Or, do I have a configuration problem on my server: IIS 6.0, Windows Server
2003?

Thank you in advance
 
Don't have a MSsql server to try, but I tried it on my windows XP SP2
machine with IIS5.1 installed ran through the wizard and the data base works
fine.(Note this was to a Access Data Base) Check your SQL server settings,
I will also ry and look around some more to see what I can find, IF anyone
else reads this message, feel free to comment.
 
Thanks Joe I would appreciate any more help you can offer; I am still working
Don't have a MSsql server to try, but I tried it on my windows XP SP2
machine with IIS5.1 installed ran through the wizard and the data base works
fine.(Note this was to a Access Data Base) Check your SQL server settings,
I will also ry and look around some more to see what I can find, IF anyone
else reads this message, feel free to comment.

HollyylloH said:
I nedd to be able to enter data into a SQL database table from a website.

I ran through the database interface wizard selecting asp.net and
connecting
to a sql database. I have an established connection under Site Settings. I
am
able to log-in and view my submission_form.aspx. However when I hit the
submit button I get this error:

Invalid Authorization Specification
----------------
...And a reference to line 33 in the submission_form.aspx
------------
Source error:

DataTable curDataTable = Connection.GetDataSet(true).Tables[0];
--------------
I have not made any modifications of any kind. this is the result from the
files created by the wizard. I have looked into this error without
success.
Please Help!

I am now wondering if I can enter data into a SQL database using asp.net
and
the Wizard? Or, do I need to switch to asp and the wizard instead.

Or, do I have a configuration problem on my server: IIS 6.0, Windows
Server
2003?

Thank you in advance
Click to expand...
Click to expand...
 
On your server did you install SP1 yet?? And what version of the SQL server
are you running, if it is even MSFTs

HollyylloH said:
Thanks Joe I would appreciate any more help you can offer; I am still
working
Don't have a MSsql server to try, but I tried it on my windows XP SP2
machine with IIS5.1 installed ran through the wizard and the data base
works
fine.(Note this was to a Access Data Base) Check your SQL server
settings,
I will also ry and look around some more to see what I can find, IF
anyone
else reads this message, feel free to comment.

HollyylloH said:
I nedd to be able to enter data into a SQL database table from a
website.

I ran through the database interface wizard selecting asp.net and
connecting
to a sql database. I have an established connection under Site
Settings. I
am
able to log-in and view my submission_form.aspx. However when I hit the
submit button I get this error:

Invalid Authorization Specification
----------------
...And a reference to line 33 in the submission_form.aspx
------------
Source error:

DataTable curDataTable = Connection.GetDataSet(true).Tables[0];
--------------
I have not made any modifications of any kind. this is the result from
the
files created by the wizard. I have looked into this error without
success.
Please Help!

I am now wondering if I can enter data into a SQL database using
asp.net
and
the Wizard? Or, do I need to switch to asp and the wizard instead.

Or, do I have a configuration problem on my server: IIS 6.0, Windows
Server
2003?

Thank you in advance
Click to expand...
Click to expand...
Click to expand...
 
Joe,
On the Webserver I have Frontpage 2003 and IIS 6.0 Server 2003 and have NOT
installed SP1. I have on a second server, Windows Server 2003 w/o SP1, MSSQL
2000, and Visual Studio .NET 2003.

Any ideas?

JoeM said:
On your server did you install SP1 yet?? And what version of the SQL server
are you running, if it is even MSFTs

HollyylloH said:
Thanks Joe I would appreciate any more help you can offer; I am still
working
Don't have a MSsql server to try, but I tried it on my windows XP SP2
machine with IIS5.1 installed ran through the wizard and the data base
works
fine.(Note this was to a Access Data Base) Check your SQL server
settings,
I will also ry and look around some more to see what I can find, IF
anyone
else reads this message, feel free to comment.

I nedd to be able to enter data into a SQL database table from a
website.

I ran through the database interface wizard selecting asp.net and
connecting
to a sql database. I have an established connection under Site
Settings. I
am
able to log-in and view my submission_form.aspx. However when I hit the
submit button I get this error:

Invalid Authorization Specification
----------------
...And a reference to line 33 in the submission_form.aspx
------------
Source error:

DataTable curDataTable = Connection.GetDataSet(true).Tables[0];
--------------
I have not made any modifications of any kind. this is the result from
the
files created by the wizard. I have looked into this error without
success.
Please Help!

I am now wondering if I can enter data into a SQL database using
asp.net
and
the Wizard? Or, do I need to switch to asp and the wizard instead.

Or, do I have a configuration problem on my server: IIS 6.0, Windows
Server
2003?

Thank you in advance
Click to expand...
Click to expand...
Click to expand...
 
Don't know but will look around more. You can try something make sure the
MSSQL server is up to date and The Server has SP1 on it. If this is a
server you can play around with, in any case IMage the server(use Norton
Ghost 2003) back it up try the updates and see what happens. I searched
around a little on msnsearch and some sites say that MSSQL 2000 needed to be
updated to the latest SPs, also try to update the server. Some said yes and
some said no. But if you backup the server it can't hurt to try, you
don't loose anything.
Hope this helps, will continue to look around.

HollyylloH said:
Joe,
On the Webserver I have Frontpage 2003 and IIS 6.0 Server 2003 and have
NOT
installed SP1. I have on a second server, Windows Server 2003 w/o SP1,
MSSQL
2000, and Visual Studio .NET 2003.

Any ideas?

JoeM said:
On your server did you install SP1 yet?? And what version of the SQL
server
are you running, if it is even MSFTs

HollyylloH said:
Thanks Joe I would appreciate any more help you can offer; I am still
working
on this.

:

Don't have a MSsql server to try, but I tried it on my windows XP SP2
machine with IIS5.1 installed ran through the wizard and the data base
works
fine.(Note this was to a Access Data Base) Check your SQL server
settings,
I will also ry and look around some more to see what I can find, IF
anyone
else reads this message, feel free to comment.

I nedd to be able to enter data into a SQL database table from a
website.

I ran through the database interface wizard selecting asp.net and
connecting
to a sql database. I have an established connection under Site
Settings. I
am
able to log-in and view my submission_form.aspx. However when I hit
the
submit button I get this error:

Invalid Authorization Specification
----------------
...And a reference to line 33 in the submission_form.aspx
------------
Source error:

DataTable curDataTable = Connection.GetDataSet(true).Tables[0];
--------------
I have not made any modifications of any kind. this is the result
from
the
files created by the wizard. I have looked into this error without
success.
Please Help!

I am now wondering if I can enter data into a SQL database using
asp.net
and
the Wizard? Or, do I need to switch to asp and the wizard instead.

Or, do I have a configuration problem on my server: IIS 6.0, Windows
Server
2003?

Thank you in advance
Click to expand...
Click to expand...
Click to expand...
 
Thanks Joe

JoeM said:
Don't know but will look around more. You can try something make sure the
MSSQL server is up to date and The Server has SP1 on it. If this is a
server you can play around with, in any case IMage the server(use Norton
Ghost 2003) back it up try the updates and see what happens. I searched
around a little on msnsearch and some sites say that MSSQL 2000 needed to be
updated to the latest SPs, also try to update the server. Some said yes and
some said no. But if you backup the server it can't hurt to try, you
don't loose anything.
Hope this helps, will continue to look around.

HollyylloH said:
Joe,
On the Webserver I have Frontpage 2003 and IIS 6.0 Server 2003 and have
NOT
installed SP1. I have on a second server, Windows Server 2003 w/o SP1,
MSSQL
2000, and Visual Studio .NET 2003.

Any ideas?

JoeM said:
On your server did you install SP1 yet?? And what version of the SQL
server
are you running, if it is even MSFTs

Thanks Joe I would appreciate any more help you can offer; I am still
working
on this.

:

Don't have a MSsql server to try, but I tried it on my windows XP SP2
machine with IIS5.1 installed ran through the wizard and the data base
works
fine.(Note this was to a Access Data Base) Check your SQL server
settings,
I will also ry and look around some more to see what I can find, IF
anyone
else reads this message, feel free to comment.

I nedd to be able to enter data into a SQL database table from a
website.

I ran through the database interface wizard selecting asp.net and
connecting
to a sql database. I have an established connection under Site
Settings. I
am
able to log-in and view my submission_form.aspx. However when I hit
the
submit button I get this error:

Invalid Authorization Specification
----------------
...And a reference to line 33 in the submission_form.aspx
------------
Source error:

DataTable curDataTable = Connection.GetDataSet(true).Tables[0];
--------------
I have not made any modifications of any kind. this is the result
from
the
files created by the wizard. I have looked into this error without
success.
Please Help!

I am now wondering if I can enter data into a SQL database using
asp.net
and
the Wizard? Or, do I need to switch to asp and the wizard instead.

Or, do I have a configuration problem on my server: IIS 6.0, Windows
Server
2003?

Thank you in advance
Click to expand...
Click to expand...
Click to expand...
 
Back
Top