topic Re: OLEDB CONNECT32 Provider ErrorSource: (null), ErrorMsg: (null) General Script Error in QlikView

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

Anonymous — Mon, 08 Jan 2018 01:45:25 GMT

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,

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

Anil_Babu_Samineni — Mon, 08 Jan 2018 02:25:43 GMT

Are you connecting from different Work station or same?

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

Anonymous — Mon, 08 Jan 2018 02:27:53 GMT

Hi loveisfail,

Different Work station.

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

Anil_Babu_Samineni — Mon, 08 Jan 2018 02:30:32 GMT

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?

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

Anonymous — Mon, 08 Jan 2018 03:29:00 GMT

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,

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

Anil_Babu_Samineni — Mon, 08 Jan 2018 04:54:28 GMT

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?

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

satheshreddy — Mon, 08 Jan 2018 07:25:18 GMT

Hi Juan,

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

Regards

Sathish

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

stabben23 — Mon, 08 Jan 2018 07:37:47 GMT

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);

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

petter — Mon, 08 Jan 2018 07:43:41 GMT

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.

topic Re: OLEDB CONNECT32 *Provider* ErrorSource: (null), ErrorMsg: (null) General Script Error in QlikView

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

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

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

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

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

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

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

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

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

topic Re: OLEDB CONNECT32 Provider ErrorSource: (null), ErrorMsg: (null) General Script Error in QlikView

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

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

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

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

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

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

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

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

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