[DB-SIG] python odbc module

Greg Stein gstein@microsoft.com
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.


-----Original Message-----
From:	Christina Perkins [SMTP:cperkins@dsg.harvard.edu]
Sent:	Tuesday, July 15, 1997 1:18 PM
To:	pythonwin-sig@python.org; db-sig@python.org; web-sig@python.org
Subject:	[DB-SIG] python odbc module

Hi all,

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.

Chris Perkins
Decision Systems Group
Boston, MA

DB-SIG  - SIG on Tabular Databases in Python

send messages to: db-sig@python.org
administrivia to: db-sig-request@python.org