ASP to MySQL database

DJFear

New Member
I send 4 strings from my iPhone to this aspx file.Those 4 things are: id, longitude, latitude, stringFromDateOnly in PHP my code was working, but i want it to be in ASP, because the company said so.....Here's my code.What am i doing wrong? I'm very bad at ASP, so please be gentle.\[code\]<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="UTF-8" %><% Dim sConnectionDim oConnectionDim oRS Dim id = Request.Form["id"];Dim longitude = Request.Form["longitude"];Dim latitude = Request.Form["latitude"];Dim timestamp = Request.Form["stringFromDate"];sConnection = "DRIVER={MySQL ODBC 3.51 Driver}; SERVER=servername; DATABASE=db_name; UID=user_name;PASSWORD=password; OPTION=3" Set oRS= oConnection.Execute("INSERT INTO locatie (id, longitude, latitude, timestamp)VALUES (id, longitude,latitude,timestamp )")Set oConnection = Server.CreateObject("ADODB.Connection") oConnection.Open(sConnection) oRS.CloseSet oRS = NothingoConnection.CloseSet oConnection = Nothing%>\[/code\]
 
Back
Top