Just some more information that I found relating to my problem. I thought
it might in the diagnosis...
These are the error message lines from Apache:
File "c:/apache/cgi-bin/sql.py", line 13, in Main
db = Odbc.Windows.Connect('Allegro','helistest','oilwell')
mxODBC.OperationalError: ('IM002', 0, '[Microsoft][ODBC Driver Manager] Data
source name not found and no default driver specified', 4265)
Thanks again,
Paul
"Paul E. Bible" <pbible at home.com> wrote in message
news:6p1g4.35$iL4.1041 at news.rdc1.tx.home.com...
> 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
>
>
>