Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi,
maybe you will need to generate the ODBC connection string line ?
You mean the: "ODBC CONNECT TO <DSN> (XUserId is somethingsomething, XPassword is somethingsomething);" ? I already have that autogenerated via the Connect command
Yes..
A same error was the issue on this topic also : SQL##f - SqlState: S0002, ErrorCode: 4294967092
It might be helpfull
Thanks. Apparently they changed the database name from "alfaintes" to "Alfaintes" so that's why they couldn't find the tables.