I'm a retired social worker creating some eLearning lessons and have a lesson that saves to a MS SQL Server DB, using ASP. I also have a component file in the lesson that can post/get back data but usually does this using PHP and a MySQL DB. The tutorial to help beginners like me provides PHP scripts compatible with the MySQL DB. But I need to post/get back data from a MS SQL Server DB and if possible use ASP for this.
I have the PHP scripts from the tutorial, and I've tested these with a sample MySQL DB. They work. What I need to do is "translate" the PHP into ASP so I can instead use a MS SQL Server DB which already is set up in the eLearning lesson.
I've seeached and searched, tried many sample scripts, connection strings. Nothing has worked.
I am posting the insert.php, select.php and delete.php scripts for a test project set up with a MySQL DB from the tutorial, in the hope that someone can suggest a way to "translate" these into working ASP versions that I can use with my MS SQL DB. I alos know that the connection string for the MS SQL Server DB uses OLE DB, but I already have this configuration from the eLearning lesson. (I don't know ehere to put it in an ASP script.)
$first = $HTTP_POST_VARS['first'];
$last = $HTTP_POST_VARS['last'];
$address = $HTTP_POST_VARS['address'];
View Complete Post