Dev to Production

I have been foisted with the unenviable task of finding out why a form that sends an email and writes to a database works in a dev environment but not in testing or production (3 different servers)

I should note the dev 'server' is my local machine, the other two are owned by some great force in another team.

In test and prod the form sends the email properly and moves on to the 'successful mail' page but doesn't write to the database, the person assigned this job previously said the database rollsback for whatever reason - is there a simple way I can find out what is causing this?? Error trapping is not my forte obviously and I would appreciate any suggestions!

First of all, if you are sending mail in a dev environment be be sure to make checks you can in fact route email through the CDONTS service (I presume that is what you are using) AND that the dev machine has a route to send the email.

Setting up CDONTS at the best of times is awkward to say the least, but it's a complete nightmare to get mails to leave the box when in a dev environment withouta true internet domain.

Regards the database.... obviously make sure you are being connected to it. Last think to check only if it is an access database (and I presume it is.... and where the problem lies) is that you have write permissions set on the database folder.

you need to give the iusr_machinename account write permissions. You can do this by right clicking the folder in explorer and selecting properties. Next click on the security tab and add in the permission.

Hope this helps.

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder

ok I am completely stumped.

The mail works ok, in dev I just use badmail to make sure its 'trying' to go where I want it to.

The databases are my problem. I checked and the database is connecting but to which one and where I am not sure - I will try to explain.

There is an include that contains all the connection strings (hardcoded) - I have this set at TestServer, in the asp for the form it calls a connection string from the following code:
strConnectionString = "Provider=SQLOLEDB;Data Source=" & GetSharedGroupValue("FeedbackDBServer") & ";Initial Catalog=" & GetSharedGroupValue("FeedbackDBCatalogue") & ";User Id="& GetSharedGroupValue("FeedbackDBUser") & ";password=" & GetSharedGroupValue("FeedbackDBPassword")



Interestingly enough the above code produces a connection to a different server (OldServer)! With a copy of the same database. The insert statement does not insert the data to either old or test when called. It will insert manually (me typing sql into enterprise mngr) on the old server but not test. Test tells me the user does not exist on another database on the same server that appears to have no connection whatsoever with the one I am working on - mostly because it is completely empty.

Have I confused anyone? I know I haven't a clue. Any help would be appreciated.

look at the code for the function GetSharedGroupValue()

It must have the database details in there which you need to change. (IP Address)

Oooo.... jolly!

What a palarva!

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder