CGI, Apache, and mxODBC

Sat Jan 15 11:39:30 EST 2000

Hi all,

First of all, sorry for the length of this message...

Okay, I've been successful in getting Python CGI scripts to run under Apache
1.3.9 under Windows/NT.  Now it's time to add database functionality using
mxODBC to the script, but I'm encountering some problems.  I have provided
my script and the Apache environment debug listing below.

The script, as written, gives me a Internal Server Error.  If I comment out
the lines dealing with mxODBC (i.e., db = Odbc.Win..., etc.), the script
works fine; just doesn't do much.

Thanks in advance your help,
Paul

----------------------------------------------------------------------------
---
#!c:\progra~1\python\python.exe

import os, string, sys, cgi, re, Odbc

def Main():
     sql = 'Select * from cashacct'

     db = Odbc.Windows.Connect('TestDB','testid','testpw')

     # Add the columns
     cols = ()
     c = db.cursor()
     c.execute(sql)
     cols = c.description

     # Print the HTML header info
     print "Content-type: text/html"
     print
     print "<HTML>"
     print "<HEAD>"
     print "SQL Statement Test"
     print "</HEAD>"
     print "<BODY>"

     # Add the columns to the Access table
     print '<table border="0">'
     print "<tr>"
     for idx in range(len(cols)):
          print "<td>" + cols[idx][0] + "</td>"
     print "</tr>"
     print "</table>"

     print "</BODY>"
     print "</HTML>"
     sys.exit(0)

Main()

----------------------------------------------------------------------------
---

Shell Environment:
COMSPEC
D:\WINNT\system32\cmd.exe
DOCUMENT_ROOT
c:/apache/htdocs
GATEWAY_INTERFACE
CGI/1.1
HTTP_ACCEPT
image/gif, image/x-xbitmap, image/jpeg, image/pjpeg,
application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword,
application/x-comet, */*
HTTP_ACCEPT_ENCODING
gzip, deflate
HTTP_ACCEPT_LANGUAGE
en-us
HTTP_CONNECTION
Keep-Alive
HTTP_HOST
XX.X.XX.XXX
HTTP_REFERER
http://XX.X.XX.XXX/blank.htm
HTTP_USER_AGENT
Mozilla/4.0 (compatible; MSIE 5.01; Windows NT)
PATH
C:\orant\bin;D:\WINNT\system32;D:\WINNT;C:\RECYCLER\S-1-5-21-862944694-15761
02806-697575874-500\DC0;C:\RECYCLER\S-1-5-21-862944694-1576102806-697575874-
500\DC0\Perl;c:\Program Files\Symantec\pcAnywhere;c:\Program Files\python
PYTHONPATH
c:\Program Files\python;c:\Program Files\Lib;c:\Program
Files\python\lib\tkinter;c:\Program Files\python\win32com;c:\Program
Files\python\win32
PYTHONUNBUFFERED
1
QUERY_STRING
sql=select+*+from+cashacct&submit-button=Submit
REMOTE_ADDR
XX.X.XX.XXX
REMOTE_PORT
1052
REQUEST_METHOD
GET
REQUEST_URI
/cgi-bin/sql.py?sql=select+*+from+cashacct&submit-button=Submit
SCRIPT_FILENAME
c:/apache/cgi-bin/sql.py
SCRIPT_NAME
/cgi-bin/sql.py
SERVER_ADDR
XX.X.XX.XXX
SERVER_ADMIN
webmaster at home.com
SERVER_NAME
XX.X.XX.XXX
SERVER_PORT
80
SERVER_PROTOCOL
HTTP/1.1
SERVER_SIGNATURE
<ADDRESS>Apache/1.3.9 Server at 24.6.21.112 Port 80</ADDRESS>
SERVER_SOFTWARE
Apache/1.3.9 (Win32)
SystemRoot
D:\WINNT
WINDIR
D:\WINNT
None
These environment variables could have been set:
AUTH_TYPE
CONTENT_LENGTH
CONTENT_TYPE
DATE_GMT
DATE_LOCAL
DOCUMENT_NAME
DOCUMENT_ROOT
DOCUMENT_URI
GATEWAY_INTERFACE
LAST_MODIFIED
PATH
PATH_INFO
PATH_TRANSLATED
QUERY_STRING
REMOTE_ADDR
REMOTE_HOST
REMOTE_IDENT
REMOTE_USER
REQUEST_METHOD
SCRIPT_NAME
SERVER_NAME
SERVER_PORT
SERVER_PROTOCOL
SERVER_ROOT
SERVER_SOFTWARE
In addition, HTTP headers sent by the server may be passed in the
environment as well. Here are some common variable names:
HTTP_ACCEPT
HTTP_CONNECTION
HTTP_HOST
HTTP_PRAGMA
HTTP_REFERER
HTTP_USER_AGENT
None