Dreamweaver - ASP.NET form that submits to SQL database (school

Author

ASP.NET form that submits to SQL database (school

Cheryl888

2005-02-23, 6:20 pm

Hello,
I am taking a graduate course and our group project is develop a working
website. Our group is made up of a bunch of non-programmers so ALL of this
stuff is new to us. The page I am in charge of is form for the user to enter
their personal information. When they hit "Submit" this information should be
added to the database.

I have been using Dreamweaver to set up my form and had no problems doing
that. The errors come into play when I try to set up the connection string to
the database. I can't even get to the point where it makes the connection
string. When I use Dreamweaver and try to set up the database connection
using the database tab, it asks me to input in the server name, user name &
password, and location of the database. After entering all this information I
get an "Access is denied" error message. Does this mean there is a problem
with the way I have set things up? Or does it have something to do with how SQL
is set up?

I am not sure how much info you all need. I can post the code that I have in
my form (better yet I can post the link to where the test form is set up -
www.theworldspa.com/cheryl/reservationsaspnetform.aspx

I am not sure where to go from here as I have no clue what the problem is. I
did also have some errors occur in setting up the testing server in
Dreamweaver. Could that be related to the access is denied message?

Thanks in advance for any help you can provide. Let me know if you need any
more information, I would be happy to provide it. I am flying blind here, so
any ideas or suggestions would be appreciated!

Cheryl888

2005-02-24, 6:16 pm

Let me try to answer your question and give you some background. At school we
have our own setup and we had to do the installs on all the machines (4 servers
and 2 workstations). Our database which is SQL is on Server 2, our web server
is Server 3, and Dreamweaver is on Workstation 6. So the database is on a
different server than the one I am working off of, but they are all connected
and in the same domain. Do you think the problem is with how the SQL database
is actually set up? Or something I am doing wrong when entering in the
information for the connection string?

Here is a copy of what I had entered into the Connection String. When I
selected "Test" after this I got the "Access is denied message." (FYI the name
of Server 2 where SQL is installed is Stacey.)
"Persist Security Info=False;
Data Source=[Stacey];
Initial Catalog=\\Stacey\c$\Program Files\Microsoft SQL
Server\MSSQL\Data\CHERYL_Data.MDF];
User ID=[testuser];
Password=[****]"

>If you are getting Access denied error messages then you are going to have
>problems with writing to the database. Is this database on the same site as
>the page, and what type is it?
:light;

augdjb

2005-02-28, 6:27 pm

I think, though I'm not sure, that if you change the Data Source string/path to
the Initial Catalog path, it might work. Also, there was a fix that you can
download that might help.
http://download.macromedia.com/pub/...2DBFix1.0.2.mxp

Hopefully this helps.[color=darkred]
"Persist Security Info=False;
Data Source=[Stacey];
Initial Catalog=\\Stacey\c$\Program Files\Microsoft SQL
Server\MSSQL\Data\CHERYL_Data.MDF];
User ID=[testuser];
Password=[****]"