Hi,
When using Microsoft Access with Vb.Net, i use a connection string to the database as following:
Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\myFolder\myAccessFile.accdb;
What is the equivalent connection string for Vb.Net?
Thanks
Further information is needed. LibreOffice is NOT M$. What exactly are you attempting to do? Access data through macro, bring specific data in from a table or query in Base, link to an Access table? Its probable that you are using Windows, but what version of LO are you using?
Thank you for your reply.
I’m trying to use a VB.Net program to add/edit data from a table created using LibreOffice (.odb). I’m not trying to link to an Access table - I can already do this as shown in my first message. The problem I am facing is that I can’t find the connection string required in the VB.Net program to connect to the LibreOffice database.
I am using Windows 7 and LibreOffice version 5.3.3.2.
Thanks.
Thank you for the additional information. It turns out your question has little to do with LibreOffice. Your question could have been ‘what connection string do I use to connect to MySQL or PostgreSQL’.
LibreOffice is installed with HSQLDB embedded v1.8 database. With this embedded HSQLDB, I don’t believe you will be able to connect. You would need to ‘split’ out the DB info (see this post for how to do this) from the .odb and then you can set up your connection to HSQLDB using a JDBC driver.
Again, this has nothing to do with LO except that Base uses (unless otherwise specified) the included HSQLDB for the database.