Hi,

Ive created a basic ASP file, incorporating WML to select an employee from a 'company' database and allow them entry into the WAP site. I have configured my DSN already to the database i want to work with. My code is below:

<%Response.ContentType = "text/vnd.wap.wml" %>
<?xml version="1.0"?>
<!DOCTYPE wml PUBLIC "-//WAPFORUM//DTD WML 1.1//EN"
"http://www.wapforum.org/DTD/wml_1.1.xml">
<wml>
<card id="menu" title="menu">
<p>
<%
dim dbConn, sql, empl

set dbConn = Server.CreateObject("ADODB.Connection&quot
dbConn.open("dsn=company&quot

sql = "SELECT * FROM tblEmpl WHERE username='ctull' AND password='232456'"

set empl = EOF then
Response.Write "You have entered an invalid login."
else
Response.Write "Welcome, " & empl("fname&quot
end if

empl.Close
dbConn.Close
set empl = Nothing
set dbConn = Nothing

%>
</p>
</card>
</wml>

The result i get from the Nokia Simulator, and any other simulator for that fact is a compilation error. I dont think theres anything wrong with my database as it looks to be correct. I have only one table called 'empl' listing the employees. As you can tell from the above code i want to select the employee 'ctull' with password '232456'. This entry exists in my database!

Any solutions..??? Much appreciated. Thanks.