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.

Try dropping the UID= and PWD= - they may not be supported by your database.

Define the necessary properties in the ODBC Control Panel when setting up

the DSN instead.



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: <mseils@s...>

Subject: [asp_database_setup] ODBC Driver Error- Can't seem to connect!

HELP!





: 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



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

Ken,



Thanks for the suggestion, but that does not work either. I set up the DSN 

and their driver asks for the UID but not the password, so I tried leaving 

out the UID and just use the password and that didn't work either. If you 

have any other suggestions, I am all ears. Thanks for the help.



Sincerely,



Michael





> Try dropping the UID= and PWD= - they may not be supported by your 

database.

> Define the necessary properties in the ODBC Control Panel when setting up

> the DSN instead.

> 

> Cheers

> Ken

> 

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> From: <mseils@s...>

> Subject: [asp_database_setup] ODBC Driver Error- Can't seem to connect!

> HELP!

> 

> 

> : 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

> 

> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

> 

Hmm,



Have you tried contacting simba? (http://www.simba.com)

They could probably tell you how to get the ODBC driver for their product

working...



Cheers

Ken



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

From: <mseils@s...>

Subject: [asp_database_setup] Re: ODBC Driver Error- Can't seem to connect!

HELP!





: Ken,

:

: Thanks for the suggestion, but that does not work either. I set up the DSN

: and their driver asks for the UID but not the password, so I tried leaving

: out the UID and just use the password and that didn't work either. If you

: have any other suggestions, I am all ears. Thanks for the help.

:

: Sincerely,

:

: Michael



~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~