topic Error OLE DB Provider for SQL Server, The statement has been terminated in QlikView

Error OLE DB Provider for SQL Server, The statement has been terminated

Wed, 20 Jan 2016 15:11:52 GMT

Hi guys,

I have a problem when running my development, I checked the size of my fields created to rule that this limit is exceeded when inserting into the SQL Server, and all is ok.

As additional data on my PC if run the project, but on the PC of the person that load the qvw (to then upload to the server) has this error, and also I created the table in SQL Server.

Someone can give help me regarding this error.

Thanks so much

Re: Error OLE DB Provider for SQL Server, The statement has been terminated

Gysbert_Wassenaar — Wed, 20 Jan 2016 18:27:47 GMT

Make sure you're allowed to write to the database. You need to enable that in the qlikview document too on the Settings tab in the Script Editor.

Re: Error OLE DB Provider for SQL Server, The statement has been terminated

Wed, 20 Jan 2016 19:58:23 GMT

I´m not sure, I'm going to review it, and can you say me please, what is the option where I can enable it in qlikview? Menu > Setting and then?...

Thanks so much Gysbert

Re: Error OLE DB Provider for SQL Server, The statement has been terminated

maxgro — Wed, 20 Jan 2016 22:48:37 GMT

script editor (ctrl+e) --> settings tab

Re: Error OLE DB Provider for SQL Server, The statement has been terminated

Fri, 22 Jan 2016 22:49:13 GMT

Hi maxgro,

I tried with that but I have the same error. Any other suggestions of what might be happening? or how can i fix it?

Thanks so much.

Re: Error OLE DB Provider for SQL Server, The statement has been terminated

maxgro — Sat, 23 Jan 2016 10:38:38 GMT

start simple, remove if not exists begin end and check the result;

SQL INSERT .....

as Jahan suggested here

Re: how to insert CSV file data into database using Qlikview script

Re: Error OLE DB Provider for SQL Server, The statement has been terminated

Wed, 02 Mar 2016 21:01:42 GMT

Hi Maxgro,

The error is the same, i'm thinking that the error is for incompatibility of version maybe in drivers?, anyone know how to see drivers of OLE DB? or any other solution?

Thanks you very much.