Re: Newbie question on SQL connection
From: Rudy (Rudy_at_discussions.microsoft.com)
Date: 01/17/05
- Next message: Raed Sawalha: "ViewState Problem with a Form?"
- Previous message: Stuart: "datagrid_ItemCommand problem"
- In reply to: Patrick Olurotimi Ige: "Re: Newbie question on SQL connection"
- Next in thread: Patrick Olurotimi Ige: "Re: Newbie question on SQL connection"
- Reply: Patrick Olurotimi Ige: "Re: Newbie question on SQL connection"
- Reply: Juan T. Llibre: "Re: Newbie question on SQL connection"
- Messages sorted by: [ date ] [ thread ]
Date: Sun, 16 Jan 2005 22:39:02 -0800
Hello!
Wanted to give an update. I have tried your tips, still no go. But I have
made progress. With your help, and reading alot of tech notes, I am getting
a diffrent error.
I have made a new user called aspnet1, trying to by pass the machine name of
aspnet. I have set all the permission that I have been told by Microsoft.
Here is my new error.
"The 'identity' start tag on line '41' doesn't match the end tag of
'system.web' in file"
Line 97: <globalization requestEncoding="utf-8" responseEncoding="utf-8"
/>
Line 98:
Line 99: </system.web>
in my web config file. Now I did add a identy impersionate value, again a
suggestion from what I have read off the web. Here is my copy of the web
config.
<?xml version="1.0" encoding="utf-8" ?>
<configuration>
<appSettings>
<add key="ConnectionString"
value="server=localhost;database=IMS" />
</appSettings>
<system.web>
<!-- DYNAMIC DEBUG COMPILATION
Set compilation debug="true" to insert debugging symbols (.pdb
information)
into the compiled page. Because this creates a larger file that
executes
more slowly, you should set this value to true only when debugging
and to
false at all other times. For more information, refer to the
documentation about
debugging ASP.NET files.
-->
<compilation defaultLanguage="vb" debug="true" />
<!-- CUSTOM ERROR MESSAGES
Set customErrors mode="On" or "RemoteOnly" to enable custom error
messages, "Off" to disable.
Add <error> tags for each of the errors you want to handle.
-->
<customErrors mode="RemoteOnly" />
<!-- AUTHENTICATION
This section sets the authentication policies of the application.
Possible modes are "Windows",
"Forms", "Passport" and "None"
-->
<authentication mode="Forms"></authentication>
<!--forms name="imsapp"
path="/" loginUrl="login.aspx" /-->
<identity impersonate="true" userName="STMBL\aspnet" password="tesla1515">
<forms loginUrl="login.aspx">
<credentials passwordFormat="Clear">
<user name="Teresa" password="Gracie" />
</credentials>
</forms>
<!-- AUTHORIZATION
This section sets the authorization policies of the application.
You can allow or deny access
to application resources by user or role. Wildcards: "*" mean
everyone, "?" means anonymous
(unauthenticated) users.
-->
<authorization>
<deny users="?" /> <!-- Allow all users -->
<!-- <allow users="[comma separated list of users]"
roles="[comma separated list of roles]"/>
<deny users="[comma separated list of users]"
roles="[comma separated list of roles]"/>
-->
</authorization>
<!-- APPLICATION-LEVEL TRACE LOGGING
Application-level tracing enables trace log output for every page
within an application.
Set trace enabled="true" to enable application trace logging. If
pageOutput="true", the
trace information will be displayed at the bottom of each page.
Otherwise, you can view the
application trace log by browsing the "trace.axd" page from your
web application
root.
-->
<trace enabled="false" requestLimit="10" pageOutput="false"
traceMode="SortByTime" localOnly="true" />
<!-- SESSION STATE SETTINGS
By default ASP.NET uses cookies to identify which requests belong
to a particular session.
If cookies are not available, a session can be tracked by adding a
session identifier to the URL.
To disable cookies, set sessionState cookieless="true".
-->
<sessionState
mode="InProc"
stateConnectionString="tcpip=127.0.0.1:42424"
sqlConnectionString="data source=127.0.0.1;user id=sa;password="
cookieless="false"
timeout="20"
/>
<!-- GLOBALIZATION
This section sets the globalization settings of the application.
-->
<globalization requestEncoding="utf-8" responseEncoding="utf-8" />
</system.web>
</configuration>
It's so late, I can't remember what I did exactly to get this. I try to keep
a log of steps I take, and note any changes, but I was interupted, came back
in a couple of hours, and can't remember what I did.
I do see alot of the same problems that people have with this, you would
think there would be like a basic guide how to do this. But I guess there
are alot variables, it's hard to pinpoint a sure way.
Anyway, any help would be appreciated.
Thanks!
Rudy
- Next message: Raed Sawalha: "ViewState Problem with a Form?"
- Previous message: Stuart: "datagrid_ItemCommand problem"
- In reply to: Patrick Olurotimi Ige: "Re: Newbie question on SQL connection"
- Next in thread: Patrick Olurotimi Ige: "Re: Newbie question on SQL connection"
- Reply: Patrick Olurotimi Ige: "Re: Newbie question on SQL connection"
- Reply: Juan T. Llibre: "Re: Newbie question on SQL connection"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
