LibreOffice Connect to SQL Server with BASIC

[@michelecavallerin4968]

Hi, how opening and closing the connection is managed via base object? Why don't you close any?

[@loup_gcl1599]

thanks you

[@andrewahyunugroho2816]

Thank you so much

[@walterscarcella5072]

Hey man this works so good! Thanks :) While it is filling data on the sheet i receive a msgbox saying "Area not valid". Am i losing some record somewhere?

[@AllTechPage]

Hello Walter, I never got that error. Do you have NULL values in the data you're getting from SQL?

[@walterscarcella5072]

Hey thanks for your answer :) Yes, i run a SELECT with 2 left outer joined tables and some records are NULL. Do i have to use some if NOT isNULL.. sentence?

[@walterscarcella5072]

but i get it also when i simply use 'SELECT * FROM tablename'. SInce i haven't sql11 native client here i used standard win 10 driver for sql. Is this could be a driver failure?

[@TuanLe-ve7lm]

can we connect to a data table just by Basic without setting up the "dummy" table?

[@AllTechPage]

Hello Tuân, the dummy table was just an example :)