topic Re: Loading script error in QlikView

Loading script error

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello, I've finished some development on a QlikView app and the client asked me to share the .qvw on one of their test servers(they want to integrate the app into a website). I've send the .qvw file on their test server(Windows Server 2008 R2). The server has the exact same database as the one that I used to develop the app on the local computer. However, when I'm trying to run the loading script I get this error for all the tables that I'm supposed to load:Connector reply error: SQL##f - SqlState: S0002, ErrorCode: 1146, ErrorMsg: [MySQL][ODBC 8.0(w) Driver][mysqld-5.7.22-log]Table 'alfaintes.ciclo_alpha' doesn't exist

The ODBC connector is properly set up, and if I do a select via QlikView's own interface it sees and recognizes the tables in the database.

Am I doing something wrong? Can anyone help, please?

Re: Loading script error

YoussefBelloum — Mon, 30 Jul 2018 09:53:11 GMT

Hi,

maybe you will need to generate the ODBC connection string line ?

Re: Loading script error

Anonymous — Mon, 30 Jul 2018 09:56:28 GMT

You mean the: "ODBC CONNECT TO <DSN> (XUserId is somethingsomething, XPassword is somethingsomething);" ? I already have that autogenerated via the Connect command

Re: Loading script error

YoussefBelloum — Mon, 30 Jul 2018 10:13:05 GMT

Yes..

Re: Loading script error

dapostolopoylos — Mon, 30 Jul 2018 10:36:00 GMT

A same error was the issue on this topic also : SQL##f - SqlState: S0002, ErrorCode: 4294967092

It might be helpfull

Re: Loading script error

pooja_prabhu_n — Mon, 30 Jul 2018 10:42:31 GMT

Hi,

Refer this. It might be helpful.

SQL##f - SqlState: ErrorCode:

Re: Loading script error

Anonymous — Mon, 30 Jul 2018 13:15:28 GMT

Thanks. Apparently they changed the database name from "alfaintes" to "Alfaintes" so that's why they couldn't find the tables.