[FONT="]I've been using Power Query to pull data from an iseries AS400 system for the last 3 months. Now, within the last two weeks all of my current workbooks will not connect and I can't establish a connection with newly created workbooks. [/FONT]
[FONT="]Did something change within Excel? (recent updates were installed)[/FONT]
[FONT="]What am I missing here? I usually go New query/From other sources/From ODBC/choose my DSN and enter my SQL statement.
Error states: [DataSource.Error]ODBC: ERROR [HY000] [IBM][System i Access ODBC Driver]Syntax error in connection string.
ERROR [HY000] [IBM][System i Access ODBC Driver]Syntax error in connection string.
[/FONT]
[FONT="]Current connection string:[/FONT]
[FONT="]Provider=Microsoft.Mashup.OleDb.1;Data Source=[/FONT]
[FONT="]$Workbook$;Location=Query1;Extended[/FONT]
[FONT="]Properties=""[/FONT]
[FONT="]Did something change within Excel? (recent updates were installed)[/FONT]
[FONT="]What am I missing here? I usually go New query/From other sources/From ODBC/choose my DSN and enter my SQL statement.
Error states: [DataSource.Error]ODBC: ERROR [HY000] [IBM][System i Access ODBC Driver]Syntax error in connection string.
ERROR [HY000] [IBM][System i Access ODBC Driver]Syntax error in connection string.
[/FONT]
[FONT="]Current connection string:[/FONT]
[FONT="]Provider=Microsoft.Mashup.OleDb.1;Data Source=[/FONT]
[FONT="]$Workbook$;Location=Query1;Extended[/FONT]
[FONT="]Properties=""[/FONT]