Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Vid laddning av data erhåller jag felmeddelandet nedan. Vid laddning kompletteras tabellnamnet med användarnamnet i ODBC-källan). Vad kan detta bero på?
SQL##f - SqlState: S0002, ErrorCode: 4294967092, ErrorMsg: [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "UFORU01.BI_BETYGSGRADER" is an undefined name. SQLSTATE=42704
SQL SELECT *
FROM BI_BETYGSGRADER
P-O
Looks like this error comes from data source. Does that tables are there?
Hi Per-Otto,
Write in English will increase Your chances to get an answer.
Have you tick Generate Logfile here? You find below Settings-->Document Properties.
It much easier to see whats happens in that logfile.
Is it a reload from desktop or server? Have it ever work before?
Does Your user have read authorization to the database?
But first give us some more info from logfile.
Hi and thank you för your help!
I get table information to Excel using MS Query and same ODBC source ...
Here is the end of my log file:
2018-01-15 15:14:12 0026 LET StartTime=Now()
2018-01-15 15:14:12 0031 ODBC CONNECT TO ***
2018-01-15 15:14:14 0044 BETYGSGRADER:
2018-01-15 15:14:14 0045 LOAD
2018-01-15 15:14:14 0046 *
2018-01-15 15:14:14 0047 SQL SELECT *
2018-01-15 15:14:14 0048 FROM BI_BETYGSGRADER
2018-01-15 15:14:14 Error: SQL##f - SqlState: S0002, ErrorCode: 4294967092, ErrorMsg: [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "UFORU01.BI_BETYGSGRADER" is an undefined name. SQLSTATE=42704
2018-01-15 15:14:14
2018-01-15 15:28:00 SQL##f - SqlState: S0002, ErrorCode: 4294967092, ErrorMsg: [IBM][CLI Driver][DB2/LINUXX8664] SQL0204N "UFORU01.BI_BETYGSGRADER" is an undefined name. SQLSTATE=42704
2018-01-15 15:28:00
2018-01-15 15:28:00 Execution Failed
Ok, looks like you dont get any Connect to DB by using ODBC.
Create a New Connect with a OLE DB for SQL server instead.