Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i trying to fetch the data from SAP BW and i have a script builder and i am trying to load ReloadDD.qvw file and i am getting error
ODBC connection failed
SQL SELECT * From DD02L;
Please help.
Not sure we can really help you with this one, other than to say check the ODBC is set up on the machine you are loading it on and the user has the correct access etc.
Check if the ODBC is 32/64 bit and make sure Qlik is set accordingly
You could also try OLEDB instead
Has this just started failing or has it never worked?
Hi Thanks for a quick reply
this is my SAP connection string
CUSTOM CONNECT TO "Provider=QvSAPConnector.dll;ASHOST=dtwdisap.dat.datwyler.biz;SYSNR=30;CLIENT=100;KeepCasing=1;NullDate=1;XUserId=aKEHXIRJJaSMVEVIXSSB;XPassword=PZRMNCFMUbXCFLFGSZMCA;";
and i have a question when we try to fetch the data from SAP side So why i get ODBC connection error
Hi,
have you saw this
HTH
André Gomes
Hi Andre,
thanks for the reply i have checked i don't have advance option but i am worried why i am getting this error.
Indeed, getting QDBC errors when connecting to SAP using the SAP Connector is a bit strange. Can you post the entire script log? Open ReLoadSAPDD.qvw, select Settings->Document Properties->General and enable option "Generate Log File". Then try to reload.
You did properly install and license the SAP Connector before running the reload scirpt, didn't you?
now its working fine I don't know why this will happen,,,Thanks guy thanks for your response
Vipin, For SAP Connector you need to create one DNS