ASP.NET Deployment

[DateWifaDiff]

ok first ever time attempting to deploy an asp.net solution

so though i'd start a thread to take other newbies through the common pitfalls

IF i manage to solve them

ok first thing i came across -

web.config

change
<customErrors mode="RemoteOnly" />

to
<customErrors mode="Off" />

inorder to get the errors as thrown when working locally

:-)

[DateWifaDiff]

ok where to actually put the files

i found that if i dumped the top level folder in it didn't like it at all

that would be the folder that you would see under IIS on your own machine

soon as i transfered my files from that folder up one it liked it better

ie config on iis

defaultwebsite
|
mysite
|
folder1
|
folder2
|
page1

becomes

wwwroot
|
folder1
|
folder2
|
page1

[DateWifaDiff]

sqlconn.ConnectionString = "Password=*****;Persist Security Info=True;User ID=*******;Initial Catalog=datewithadifference;Data Source=mssql.active-ns.com"



eh datasource is usually the name of the instance of the sql server

think i got it wrong as it can't find stored procedures

Data Source=mssql.active-ns.com

anyone?

[DateWifaDiff]

having transfered my database which didn't have the database user from this system

i think i'll find that all my Stored procedures need granted exec permission for the database user on this system

let you know in 5 :-)


nope not that...... my user has the permissions

:-( dam no chance it was gonna be that simple

[DateWifaDiff]

ok bit of advice if your using dlls to do your calls to the database


Dim oCnn As SqlConnection = Database.GetSQLConnection.GetConnection
Dim oCmd As New SqlCommand()
Dim oRdr As SqlDataReader

With oCmd

.Connection = oCnn
.CommandText = "dbo.[sp_User_Select]"
.CommandType = CommandType.StoredProcedure




problem is this line of code

.CommandText = "dbo.[sp_User_Select]"


the dbo is fine and dandy when your on your own machine building databases

not so cool when you move to another server where the user who will be accessing the sp aint the databaseowner

corrected to

.CommandText = "sp_User_Select"

well am off to do lots of find and replace :-)

[WhiskyFudge]

To change the owner of your objects to dbo see http://www.experts-exchange.com/Data..._21117511.html

Jas

[DateWifaDiff]

that post was very helpful

:-)


my next problem is sending mail from events on the website

ie user registers

in asp this used to be done via cdonts

however i am not sure if this is still an option

at present i have a class to send mail via

Imports System.Web.Mail
Imports System.Web.Mail.MailMessage

however this seems to need a smtp server....do we get one with the package?

or are thier on site components to send mail ?

[Tim Marshall]

SMTP is mail.yourdomain.co.uk for script usage.

Tim Marshall