[DB-SIG] python odbc module
Thu, 17 Jul 1997 13:43:31 -0700
That could be related to security contexts. See if your DSN has the
"Trusted Connection" flag turned on. That will cause problems since the
IIS process might not be running in an appropriate security context to
connect to the remote database.
I can definitely say that the ODBC module works with remote machines.
There is probably some weird setup that you're running into.
From: Christina Perkins [SMTP:email@example.com]
Sent: Tuesday, July 15, 1997 1:18 PM
To: firstname.lastname@example.org; email@example.com; firstname.lastname@example.org
Subject: [DB-SIG] python odbc module
I'm working on implementing a web site using Python CGI scripts. We're
running Microsoft IIS 3.0 and SQL Server 6.5. The ODBC module works
perfectly as long as the database and web servers are on the same
machine. However, when I try to access a remote datasource in the same
domain, I get the following error:
dbi.operation-error: [Microsoft][ODBC SQL Server
Driver][dbnmpntw]ConnectionOpen (CreateFile()). in LOGIN
It seems that ConnectionOpen() needs permission to write a file, and I
can't figure out where it's trying to open this file.
The user cgi scripts are executed as a domain user with change control
on the cgi directories through both sharing and regular file system
Has anyone run into this before? Any advice would be helpful.
Decision Systems Group
DB-SIG - SIG on Tabular Databases in Python
send messages to: email@example.com
administrivia to: firstname.lastname@example.org