I'm trying to use an Oracle database through a SYSTEM DSN that I created 

with the 32-bit ODBC control panel applet.  I confirmed that the DSN works 

by using it to link an oracle table to an MS Access database.  The driver is 

called "Oracle ODBC Driver" and is supplied by Oracle, not Microsoft.



- - - - - - - - - -

ASP code for test 1:



connectstring = "DSN=test_web_oracle"

set LHDB=server.createobject("ADODB.Connection")

LHDB.open connectstring



Result: it complained that I hadn't supplied a password.  OK, see test 2...



- - - - - - - - - -

ASP code for test 2:



connectstring = "DSN=test_web_oracle;PWD=route19"

set LHDB=server.createobject("ADODB.Connection")

LHDB.open connectstring



Result: open failed with this message:

Microsoft OLE DB Provider for ODBC Drivers error '80040e21'

The request properties can not be supported by this ODBC Driver.



I'm not sure where to go to correct this.  I used the correct password. 

Ultimately I want to use a DSN-less connection, but I thought I'd start by 

using a connection that I could verify worked - which I've proven by linking 

Oracle data to MS Access.



Thanks,

Ken Mosher

_________________________________________________________________

Get your FREE download of MSN Explorer at http://explorer.msn.com