Chat LIVE With Programming Experts! There Are 23 Online Right Now...

Welcome to Dream.In.Code
Become a VB Expert!

Join 244,288 VB Programmers for FREE! Get instant access to thousands of VB experts, tutorials, code snippets, and more! There are 971 people online right now. Registration is fast and FREE... Join Now!




Connecting VB to OpenOffice database

 
Reply to this topicStart new topic

Connecting VB to OpenOffice database

informantspies
14 Sep, 2008 - 12:14 AM
Post #1

New D.I.C Head
*

Joined: 20 May, 2008
Posts: 1


I am trying to connect from VB2008 to OpenOffice.

So the connection to Microsoft is

Build connection string to connect to
' -- an OleDB Data provider
sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;"
sConnection = sConnection & "User ID=Admin;"
sConnection = sConnection & "Data Source="
sConnection = sConnection & Application.StartupPath & _
"\camerashop.mdb"

Do I have to change both the Provider and StartupPath or just 1?

User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic

Time is now: 7/4/09 03:32PM

Live VB Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

VB Tutorials

Reference Sheets

VB Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month