Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 246
  • Last Modified:

getting the results to go to an database

I am writing a web database to gather information on employee traveling routines. What is the best way to do an online questionnaire and record the results ? (ideally i would like to record the results in a database)



  • 7
  • 4
  • 2
  • +1
1 Solution
There are a few ways to handle this type of process on the Web.  It is becoming very common to use Microsoft Active Server Pages to pass information to and from an ODBC compliant database.  MY particular method of choice is to use Cold Fusion (available at www.allaire.com)  To pass information back and forth.  Cold Fusion uses its own hybrid language (CFML) which is a hybrid between standard SQL commands and HTML.  I found it easy to learn and both flexible and scalable enough to suit my needs.
Let me know if you need more information.
itssbellAuthor Commented:
How would i use Active Server pages  ?
There's a comprehensive online tutorial located at:
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

You don't specify your operating system, but if you are using a Unix system, you
can try using mSQL from Hugues technologies. mSQL is an alternative to the high-end
commercial software and is useful in smaller scale applications. Cold Fusion, as
suggsted above, is a very powerful app that works with NT and with Unix (well,
just with Solaris 2.5.x at this point) and will most certainly meet your needs.

Just use HTML forms to pass named information into your database application,
running as a service on NT or through CGI on a Unix system.

Perhaps specifying your base OS, web server type, and the scope of your work would
be helpful for future answers. If you have higher end requirements, something like
Oracle would be useful, if you are midrange, something like Lotus Notes/Domino may
serve(r) you well. If you have low end requirements, mSQL may get you by.

Please let us know your situation. Thanks, Curt

itssbellAuthor Commented:
I am using an NT system with IIS 4.0 installed


Here is how to use Active Server Page, all the points below have to be on the server side.

1 - Create a file named "default.htm" and paste in it the following:

<H2>Employee Information</H2>
<FORM NAME="Emp_Form" ACTION="Submit.asp" METHOD="POST">
<P>Employee Name: <INPUT TYPE="Text" NAME="Emp_Name" SIZE="16"></P>
<P>Employee Address: <INPUT TYPE="Text" NAME="Emp_Address" SIZE="16"></P>
<P>Telephone No.: <INPUT TYPE="Text" NAME="Emp_Tel" SIZE="16"><P>
<INPUT TYPE="submit" NAME="Submit" VALUE="Submit">
<INPUT TYPE="reset" NAME="Reset" VALUE="Reset">

2 - Create another file named "submit.asp" and paste in it the following:


 Set Conn = Server.CreateObject("ADODB.Connection")
 Conn.Open "employee"
 Conn.Execute("INSERT INTO EmployeeInfo (Emp_Name, Emp_Address, Emp_Tel) " & _
               "VALUES('" & Request("Emp_Name") & "','" & Request("Emp_Address") & _
               "','" & Request("Emp_Tel") & "')")
 Set Conn=Nothing

 <SCRIPT Language="JavaScript">
  function goDefault()
        window.location.href = "default.htm";
 // -->

<H3>Employee Information was saved sucessfully.</H1>
<p><INPUT TYPE="button" VALUE="Click here to go to Employee Information"
NAME="GoDef" ONCLICK="return goDefault()"></P>

3 - Create MS Access Database named "emp" and create a table called "employeeinfo", this table will consist of three fields Emp_Name, Emp_Address and Emp_Tel.

4 - Create an ODBC data source named "employee" (Microsoft Access Driver) to be pointed to "emp" database which was created in step 3.

This sample have three fields only, you can expand it as much as you can.

Best regards,
Bin Huwairib
itssbellAuthor Commented:
Using your code i got an error message -

270 (0x0000010e)

 I think its because i haven't set up the ODBC database up properly - can explain in a bit more depth how i set this up

Thanks a lot


Do the following steps on your server machine:

1 - Goto the (Settings/Control Panel) then double click on the ODBC icon.
2 - Goto (System DSN) tab and click on (Add) button.
3 - Select "Microsoft Access Driver (*.mdb)" then click on (Finish).
4 - Enter "employee" in (Data Source Name) text box.
5 - Click on select and choose "emp" database (assuming that you created "emp" database -check step no.3 in the previous answer-).
6 - Click OK.

That is all, please let me know if you require any other details.

Best regards
Bin Huwairib
itssbellAuthor Commented:
I have followed your instructions to create the odbc database called employee, but its still coming up with the same error.

THe URL is


Thanks for your help so far


It's nothing to do with the ODBC database, look at this artical it might help you.

PSS ID Number: Q180710

When a user makes a request for a Web page from Microsoft Internet
Information Server (IIS), the server reports an error 270 (0x0000010e) in
the browser.
This error occurs because an application is running in the IIS process's
memory space. The application is modifying threads within the process to a
thread type called Apartment Model Threading. When the application is ready
to return control of the thread, the application does not convert the
thread back to a "free threaded" thread. This causes IIS to experience a
memory exception error and reports it to the browser.
To work around the problem, determine which component is causing the
problem and either fix it or do not use it.
Custom-developed components can cause the problem. You should also check
for any ISAPI (for example, a filter or .dll file) or an ActiveX object
that may use the IIS thread pool, and remove or repair them.
Microsoft is researching this problem and will post new information here in
the Microsoft Knowledge Base as it becomes available.
To determine which ISAPI filters are currently in use on the system, you
will need to use Registry Editor. Start Registry Editor (Regedt32.exe) and
locate the following registry key:
Find the value "Filter DLLs" and double-click it. The Edit Value dialog box
appears. If the value is selected, clear the highlighting before you
attempt to view it. (To clear the selection, press the left or right arrow
key.) Filter DLLs that are in use will be listed by path and file name,
separated by a comma. By default, IIS installs the ISAPI filter
Sspifilt.dll. Both versions of Microsoft Proxy Server, if installed on the
system, will include a filter named W3proxy.dll. These do not cause this
problem and should be left in place.

Best regards
Bin Huwairib
itssbellAuthor Commented:
so is there a patch/fix/update for it ?

Cheers Itssbell

Which version of IIS installed on your server.

Bin Huwairib
itssbellAuthor Commented:
IIS 4.0


itssbellAuthor Commented:
Thanks for all your help - you have been a star

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

  • 7
  • 4
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now