ODBC, mxODBC problem

[rockjock810 at my-deja.com]

I tried it again using:

odbc.odbc("express/Admin/")
odbc.odbc("express/Admin")

Not one works. And with mxODBC:

ODBC.Windows.DriverConnect("DSN=express;UID=Admin;PWD=;")
ODBC.Windows.ODBC("express","Admin","")

Not much luck here either. I tried running said statement(s) in
Pythonwin's interactive mode, and it works. Something's wrong somewhere
and I'm already at the edge of whatever's left of my wits. Help!

In article <88jk4o$vsg$1 at nnrp1.deja.com>,
  rockjock810 at my-deja.com wrote:
> I've been tinkering with both ODBC and mxODBC modules with no success
> for the past 24 hours.
>
> I tried this with the ODBC module:
>
> import cgi,dbi,odbc
> db=odbc.odbc("express")
> # no UID, no PWD
>
> Traceback (innermost last): File "d:\the-cafe\cgi-bin\express.py",
line
> 25, in ? db=odbc.odbc("express") dbi.operation-error: [Microsoft][ODBC
> Microsoft Access 97 Driver] The Microsoft Jet database engine cannot
> open the file '(unknown)'. It is already opened exclusively by another
> user, or you need permission to view its data. in LOGIN
>
> I tried the mxODBC variant with not much success.
>
> The "express" MS Access database is on a network share:
> \\core\e$\express\express.mdb
>
> The System DSN was not opened at all exclusively and I haven't been
> having problems accessing the same using Perl ODBC. Help!
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>


Sent via Deja.com http://www.deja.com/
Before you buy.