Ok so I'm brand new to server-side development. I have implemented a simple asp script which posts data from a form to a database and displays the data in a table on my site. Works fine and dandy on my development server, but falls over on the real thing. The display of data works fine but not the "insert into" SQL statement. I asked the webhost guy to set appropriate writer permissions on the database, thinking this was the problem. He got back to me with this:
What's all this then? My script says this:There was no 'global.asa' file indicating the EXACT RELATIVE database location on the 'Virtual Root' path!
For the asp database connection code to work this is a must.
The connection strings in the 'message_send.asp' file will not work on this server (I'm surprised they worked at all) as you need a global.asa file which does all of this for you.
Doesn't that define the path to the data?? I thought 'global.asa' was an optional thing. Looking in the global.asa script, it all appears to be FrontPage stuff, which I thought was irrelevant since I am coding 'by hand' rather than using in-built FP features.set conn=Server.CreateObject("ADODB.Connection")
Can someone explain this to me?