OLEDB CONNECT32 *Provider* ErrorSource: (null), ErrorMsg: (null) General Script Error

[Anonymous]

Hi guys,

I have been presented with a complication when reloading my qvw file through the qlikview management console, but when I recharge it from qvw I have no problem, this is the message it throws at me.

07/01/2018  8:33:25 PM:      Execution started.

07/01/2018  8:33:25 PM:      QlikView Version:11.20.12577.0

07/01/2018  8:33:25 PM:      CPU Target                    x64

07/01/2018  8:33:25 PM:      Operating System              Windows Server 2008 R2 Standard Service Pack 1 (64 bit edition)

07/01/2018  8:33:25 PM:      Wow64 mode                    Not using Wow64

07/01/2018  8:33:25 PM:      MDAC Version                  6.1.7601.17514

07/01/2018  8:33:25 PM:      MDAC Full Install Version     6.1.7601.17514

07/01/2018  8:33:25 PM:      PreferredCompression          2

07/01/2018  8:33:25 PM:      EnableParallelReload          1

07/01/2018  8:33:25 PM:      ParallelizeQvdLoads           1

07/01/2018  8:33:25 PM:      AutoSaveAfterReload           0

07/01/2018  8:33:25 PM:      BackupBeforeReload            0

07/01/2018  8:33:25 PM:      EnableFlushLog                0

07/01/2018  8:33:25 PM:      SaveInfoWhenSavingFile        0

07/01/2018  8:33:25 PM:      UserLogfileCharset            1200

07/01/2018  8:33:25 PM:      OdbcLoginTimeout              -1

07/01/2018  8:33:25 PM:      OdbcConnectionTimeout         -1

07/01/2018  8:33:25 PM:      ScriptWantsDbWrite            false

07/01/2018  8:33:25 PM:      ScriptWantsExe                false

07/01/2018  8:33:25 PM:      LogFile CodePage Used:        1200

07/01/2018  8:33:25 PM:       Reload Executed By SAN_LORENZO\AdminQV

07/01/2018  8:33:25 PM:       Process Executing: QVB

07/01/2018  8:33:25 PM:       Process ID: 5988

07/01/2018  8:33:25 PM: 0002  SET ThousandSep=','

07/01/2018  8:33:25 PM: 0003  SET DecimalSep='.'

07/01/2018  8:33:25 PM: 0004  SET MoneyThousandSep=','

07/01/2018  8:33:25 PM: 0005  SET MoneyDecimalSep='.'

07/01/2018  8:33:25 PM: 0006  SET MoneyFormat='S/. #,##0.00;S/. -#,##0.00'

07/01/2018  8:33:25 PM: 0007  SET TimeFormat='hh:mm:ss TT'

07/01/2018  8:33:25 PM: 0008  SET DateFormat='DD/MM/YYYY'

07/01/2018  8:33:25 PM: 0009  SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff] TT'

07/01/2018  8:33:25 PM: 0010  SET MonthNames='ene;feb;mar;abr;may;jun;jul;ago;sep;oct;nov;dic'

07/01/2018  8:33:25 PM: 0011  SET DayNames='lun;mar;mié;jue;vie;sáb;dom'

07/01/2018  8:33:25 PM: 0017  OLEDB CONNECT32*Provider*

07/01/2018  8:33:25 PM:       Error: ErrorSource: (null), ErrorMsg: (null)

07/01/2018  8:33:25 PM:       General Script Error

07/01/2018  8:33:25 PM:       Execution Failed

07/01/2018  8:33:25 PM:      Execution finished.

This is my connection string:

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Produccion;Data Source=PELIMDATABASE;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=SLPBI;Use Encryption for Data=False;Tag with column collation when possible=False];

I hope to support me.

Thank you very much Community.

Best regards,

[Anil_Babu_Samineni]

Are you connecting from different Work station or same?

[Anonymous]

Hi loveisfail,

Different Work station.

[Anil_Babu_Samineni]

Sure, Can we talk little more when you say different AMI that means you are not carrying DB with the same machine. Can you explain with some cluster / node level so then i can understand the concern exactly where you are?

[Anonymous]

Hi loveisfail,

The server where qlikview is installed is a different one in which we have the BD from which we extract the data. I did not answer your question or how you could guide me to answer your question.

Best regards,

[Anil_Babu_Samineni]

I am trying to help you as much i know ..

Here, Have you connected using 32 bit? If so, Have you forced "Force 32" checked using Qlik?

[satheshreddy]

Hi Juan,

Your getting when you run manually? or when you started job in QMC?

Regards

Sathish

[stabben23]

Hi,

try to create a New Connection string With password to DB:

OLEDB CONNECT32 TO [Provider=SQLOLEDB.1;Persist Security Info=True;User ID=sa;Initial Catalog=ProDB;Data Source=N\SQLEXPRESS;Use Procedure for Prepare=1;Auto Translate=True;Packet Size=4096;Workstation ID=H9;Use Encryption for Data=False;Tag with column collation when possible=False] (XPassword is CFaMQRdNODdeWaJOaA);

[petter]

For me it looks like you haven't installed the same ODBC driver on your server computer as you have on your workstation. SQLOLEDB indicates that it is the Microsoft SQL Server driver you are using. Make sure that this driver has been installed on the server.