Hi,

I am getting the same error. Only difference being that the DSN was 
created with Oracle ODBC Driver. My server runs on Advanced Server 2000. 
The Oracle Database resides on the same machine.

Can you send a reply if your problem was solved. Plz. mail at 
nagpalviplovs@y...

Thanx.

Viplov Nagpal
Kawin Interactive Ltd.
Gujarat, India



> I am getting the following error when trying to connect via a Simba 
driver:
> 
> "Microsoft OLE DB Provider for ODBC Drivers (0x80040E21)
> ODBC driver does not support the requested properties."
> 
> I feel as though the problem lies with the driver version (v.1). Simba 
is 
> up to v.6 but the customer does not want to upgrade. Here is the code I 
am 
> using which seems to work fine with Access and SQL Server 7: 
> 
> 	Set authConn = server.CreateObject("ADODB.Connection")   	
> 	authConn.Open "DSN=CustomerInfo;UID=***;PWD=***"
> 	
>    	strSQL = "Select CustomerCode, CustomerPassCode from CustomerData 
> where CustomerCode ='" & request.form("CustCode") & "'"
> 	
> 		dim objRS
> 		Set objRS= Server.CreateObject("ADODB.Recordset")
> 		objRS.Open strSQL, authConn
> 
> 
> 
> If anyone has any ideas or information of different connections using 
> Simba client please let me know. As mentioned, this code works with 
Access 
> and SQL Server 7, so I know the DSN is set up correctly. The strange 
> thing, is that I can import the data from the database using Access or 
> Excel, so I know that I can get a connection. If anyone has any 
> suggestions, it would be appreciated. Thanks,
> 
> Michael.