Search the Community

Hi all, I hope you can help me with this. I need to connect to a Database using Cloudera ODBC Driver for Impala. I installed the driver, created a User DSN (drona2) and tested it successfully (got the message: Successfully connected to data source!) but when I try to connect to the database using a Conneciton String, it simply didn't work. I tried connecting to the database using the User DSN, I previously created, that has all parameters needed but got the following error: $ProviderDatasource = 'DSN=drona2;' $conn_Database = ObjCreate ("ADODB.Connection") $conn_Database.ConnectionString = $ProviderDatasource $conn_Database.Open ==> The requested action with this object has failed.: $conn_Database.Open $conn_Database.Open^ ERROR Also I tried adding all parameters to my connection string as follows but also got the same error: $ProviderDatasource = 'Driver=Cloudera ODBC Driver for Impala;Host=MyHost.domain.com;PORT=21050;AuthMech=3;UID=MyUserId@domain.com;PWD=MyPasswordc;Schema=default;SSL=1;AllowSelfSignedCerts=1;AllowHostNameCNMismatch=1;CheckCertRevocation=1;KrbFQDN=_HOTS;KrbServiceName=impala;ServicePrincipalCanonicalization=1' I hope someone has used this driver successfully before and can shed some light here. If you need additional information, let me know. Regards,