ODBC
Posted: 09 Feb 2022, 11:22
Hi Bruce,
Following on from the last topic that you've helped me with....but its about ODBC in general.
Looking at youtube vids now to learn query....but Microsoft query itself keeps hanging/not responding. If my data table joins are wrong would I just get a warning or return no data....or would this cause it to hang as well.
I’ve downloaded 64bit connector to match my operating system….but read an article where connecting to 1 company only (that’s all we have) the article referenced 32 bit only?
I think the link is working as occasionally I get as far as previewing data when building my query, but its constantly crashing/not responding.
Started excel in safe mode, checked office for updates and done a full internet repair. Also uninstalled & re-installed odbc driver 64 bit.
Find it crashes slightly later if I don’t use the wizard.
Is it crashing because I’ve got join editor open in sage looking at the joins to match?
Thanks
Following on from the last topic that you've helped me with....but its about ODBC in general.
Looking at youtube vids now to learn query....but Microsoft query itself keeps hanging/not responding. If my data table joins are wrong would I just get a warning or return no data....or would this cause it to hang as well.
I’ve downloaded 64bit connector to match my operating system….but read an article where connecting to 1 company only (that’s all we have) the article referenced 32 bit only?
I think the link is working as occasionally I get as far as previewing data when building my query, but its constantly crashing/not responding.
Started excel in safe mode, checked office for updates and done a full internet repair. Also uninstalled & re-installed odbc driver 64 bit.
Find it crashes slightly later if I don’t use the wizard.
Is it crashing because I’ve got join editor open in sage looking at the joins to match?
Thanks