Oracle gurus:



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

A connect string for an odbc data source should look like the following

"Provider=MSDASQL.1;Persist Security Info=True;User 

ID=qwerty;Password=qaz;Data Source=MyDataSource"

Dave