XOInstance Password (OpenInsight 32-bit Specific)
At 31 AUG 2010 07:03:30PM John Win wrote:
Hi all, I am attempting to connect to SAS using XOInstance. The password is case sensitive on the SAS database, and I am typing it with correct case on the dialog box. However I keep getting an incorrect password error. OI is 8.0.3
Does this function keep the password in the same case when sending or does it convert it to upper case.
At 02 SEP 2010 11:51AM Bob Carten wrote:
AFAIK there is nothing in XOInstance that changes the case of the password. I reviewed the code and tested a connection to a mySql database with a case sensitive password. I believe the ODBC dll is compiled against ODBC 2.x, SAS might be using some ODBC 3.x feature.
Some ideas:
If you turn on tracing in the ODBC connection ( windows start, run ODBCAD32, follow the tabs till you see enable tracing) then connect do you get beter information about the error?
When you test the connection using the ODBC administrator does it connect ok?
If you change the password of a test user to all upper case or all lower case does that succeed?
If none of these does if for you, you could try using OLECREATEINSTANCE with ADODB.Connection and ADO.Recordset.