Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

_juancorrea_
New Contributor III

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

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,

8 Replies

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

Are you connecting from different Work station or same?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
_juancorrea_
New Contributor III

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

Hi loveisfail,

Different Work station.


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

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?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
_juancorrea_
New Contributor III

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

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

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?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
satheshreddy
Contributor III

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

Hi Juan,

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

Regards

Sathish

stabben23
Honored Contributor

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

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

MVP
MVP

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

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.