Changing My Database Path In Web.config

Hey guys,

I uploaded my website from VWD Express to ipower.  My database did not work, which I have learned upon some research should have not been a shock to me, but most definetely was.  When I contacted tech support they told my that my web.config files were pointing to my local paths.  That I should change them and I should be fine.  Elsewhere, in the knowledge base I found the strConnect that I am under the impression I need to use.

strConnect = "Provider=SQLOLEDB; Server=SQL-A1; UID=account_username; PWD=account_password; Database=user_db_name"
oSQLServer.Connect strServer,strLogin,strPwd


The problem is, I'm a complete newbie, learning as I go and I can't find anything on where or how I insert this into my web.config to correct my paths.  IPower will not help with coding.  I know my current connection string is in web.config in the appsettings, that's about as far as my knowledge goes.

So, could anyone show me how I go about putting this into my web.config?  Examples are very helpful :]

On a side note, I've been reading that this is a common problem among newbies like myself.  So, is changing these files actually going to work, or am I wasting my time?  Also, before I get knee-deep into it, is the database-publishing kit put out by MS the way to go here?

 Thanks for any and all replies, you guys are always awesome.