fetching Data From SAP

[#1]

What is the reason behind this error.When I fetched  the data from SAP after establishing the connection

[Anonymous]

Add the following parameter in the connection string in QlikView:

TimeOutFetch=n

[#3]

this is my SAP connection string:-

CUSTOM CONNECT TO "Provider=QvSAPConnector.dll;ASHOST=111.11.11.900;SYSNR=11;CLIENT=111;KeepCasing=1;NullDate=1;XUserId=JGJYaYRNJbaeFSFNBDbGE;XPassword=PSOaVDdNHScKWSZNRRMGTRA;";

plz tell where i have to add timeout fetch paramater

[Anonymous]

Hi try like this

TableName:

SQL SELECT GJAHR from TableName;
store TableName into $(vSource)TableName.QVD;

drop Table TableName;

by using the above script we can retrieve the field GJAHR from the table....

[#5]

any idea??????????

[Anonymous]

Please try this:

CUSTOM CONNECT TO "Provider=QvSAPConnector.dll;ASHOST=111.11.11.900;SYSNR=11;CLIENT=111;KeepCasing=1;NullDate=1;XUserId=JGJYaYRNJbaeFSFNBDbGE;XPassword=PSOaVDdNHScKWSZNRRMGTRA;TimeOutFetch=1800";

[#7]

I have used this connection string

CUSTOM CONNECT TO "Provider=QvSAPConnector.dll;ASHOST=111.11.11.900;SYSNR=11;CLIENT=111;TimeOutFetch=2000;KeepCasing=1;NullDate=1;XUserId=JGJYaYRNJbaeFSFNBDbGE;XPassword=PSOaVDdNHScKWSZNRRMGTRA;";

but it still throw the same error msg

even i tried with TimeOutFetch=20000 as well,but it won't work

[Peter_Cammaert]

AFAIK you are getting errors way before your SQL statement is transmitted to SAP. I guess something in your setup is wrong. Your logs should at least mention something like

Creation of function /QTQVC/OPEN_STREAM returned ...

before you can be sure that a usable connection has been established. But there is nothing of the kind in your logs.

Check your connection parameters (use the Test button of the SAP Connector setup screen)

IMHO 111.11.11.900 is not a valid IP-adres. Can you use a hostname?

Peter

[#9]

When I created the connection I have already done test connection ,and it was successful ,I know

111.11.11.900 is not a valid IP , I edit before pasting in community in order hide the security of my client