Ask Your Question
0

Vb.Net connection string

asked 2017-06-15 13:45:14 +0200

tobyaus gravatar image

updated 2017-06-15 13:46:04 +0200

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

edit retag flag offensive close merge delete

Comments

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?

Ratslinger gravatar imageRatslinger ( 2017-06-15 16:25:40 +0200 )edit

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.

tobyaus gravatar imagetobyaus ( 2017-06-16 03:16:26 +0200 )edit

1 Answer

Sort by » oldest newest most voted
0

answered 2017-06-16 16:15:04 +0200

Ratslinger gravatar image

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.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-06-15 13:45:14 +0200

Seen: 488 times

Last updated: Jun 16 '17